------=_Part_10287_14869138.1210949675232
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
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
------=_Part_10287_14869138.1210949675232
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
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:<br>
<br>'... columnname = "valuestring"
...'<br><br>-to-<br><br>'... columnname =
''valuestring'' ...' <br><br>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.<br>
<br>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.<br>
<br>Art<br><br>
------=_Part_10287_14869138.1210949675232--
