I thought maybe someone could explain this to me.
I had this statement in an app:
SET V zdb = (''+CVAL('dbpath')+'') -- Those are two sets of two
single quotes.
Which has worked fine for 90 odd days on a customer's system and mine
during testing. The customer had some computer work done, there was a
system error relative to printing, and afterwards the statement above
failed... it also failed on my computer when I downloaded a copy of
their DB.
If I connect to an old copy of their database the statement above
works fine.
The character settings are identical in both versions.
Changing the statement to:
SET V zdb = (''''+CVAL('dbpath')+'''') -- that's two sets of of
four single quotes
solved the problem.
I _think_ using four single quotes is correct, and my original
construct was wrong.
But:
1) Why did it the original work?
2) How can two different versions of the same database behave
differently in this regard? In other words, what could have changed
in the database when, apparently, there was a Windoze printer
definition problem that caused the change in behaviour?
Thanks,
Ben Petersen
