Sending a query to ADO with then character 39 :'

[Jean-Claude LEPOT]

I can't send a query to an ADO object if the query text contain the character
ascii 39. I'had try to double it (it works well when i work with the net
library accessing SQL Server Databases) but it occurs an error in this case
also.

The only solution i find is to send a query with db library, on doubling
the caracter to obtain the ID (field as int primary key), then i make a new
query to find this ID in the ADO object... I works but it is'nt very nice,
no ?

Thank's if you have a solution.

[Bill Vaughn]

I call this the "O'Malley" problem. It can be solved by letting ADO handle
the parameters for you (via a Command object and a Parameters collection)
or by doubling the single quote. If done right, either technique works.

bv

"Jean-Claude LEPOT" <jclepot@wineandco.com> wrote:
>
>I can't send a query to an ADO object if the query text contain the character
>ascii 39. I'had try to double it (it works well when i work with the net
>library accessing SQL Server Databases) but it occurs an error in this case
>also.
>
>The only solution i find is to send a query with db library, on doubling
>the caracter to obtain the ID (field as int primary key), then i make a
new
>query to find this ID in the ADO object... I works but it is'nt very nice,
>no ?
>
>Thank's if you have a solution.