Re: Oracle Update failed with single quotes in the data

From: Keith Jamieson <Keith.Jamieson_at_phoenix.ie>
Date: Wed, 15 Nov 2000 11:03:52 -0000
Message-ID: <8utqna$u2j$1@kermit.esat.net>

I like the developers to concatenate chr(39) instead of using single quotes. Same result, less headaches.
Otherwise, you have to put two singkle quotes to get a single embedded quote

usuresh_at_my-deja.com wrote in message <8uphml$dpo$1_at_nnrp1.deja.com>...
>We are experiencing a strange problem during a
>database update when called from a C++ Executable
>compiled in "Multithreaded DLL" mode.
>If the update data has single quotes, the update
>fails and gives "Abnormal Program Termination"
>error. Database is Oracle 8i and connected
>through Oracle 8 ODBC driver. Using ADO and MDAC
>2.5.
>Update is successfull when data has no single
>quotes character.
>It is also successfull when one or both of client
>and server version is 7.3.x, even with single
>quotes in the update data.
>
>I'd be glad if someone could give me some advice.
>
>Regards,
>Suresh
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Wed Nov 15 2000 - 05:03:52 CST