RE: SPL problem
Posted in 2008
Art Kagel — — source: Usenet: comp.databases.informix
OK, tried one workaround last night that seems to be working. Changed out
the double quotes in the literal filters for single quotes and that is now
working. The engine is no longer stripping the quotes out. So I changed:
'... columnname = "valuestring" ...'
-to-
'... columnname = ''valuestring'' ...'
Where the second version is actually two single quotes which are stripped to
one single quote when it is saved in the query table. Now the cursor OPEN
is not stripping off the quotes.
Single quotes for literals is SQL standard, but I still don't understand why
the engine stripped the double quotes for the Windows .NET client and not
for the dbaccess Linux client. Well, I'll leave that for IBM.
Art