At 6:44 PM +0100 9/20/01, johnlucas-Arluna wrote:
>Hello
>
>I'm trying to do the following:
>
>"Update tblCompany SET CoName='&quot;tester&quot;' WHERE CoID=109"
>
>But getting an error message
>
>I tried the escape character "\" like
>
>"Update tblCompany SET CoName='&quot\;tester&quot\;' WHERE CoID=109"
>
>but get the same error
>
>This happens whether I use ADODB in VB or if I try executing the query
>through DBTools 1.0.9
>
>Can anybody tell me how I can escape the semi-colon please?
>
>Many thanks for any help
>
>John
Semicolons in strings aren't special. You may have some other problem.
You say you get an error message. What is it?
--
Paul DuBois, paul@stripped

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.