on 8/29/02 18:48, thoseThings at thosethings at hotmail D.OT com wrote:
> Ruslan,
>
> Is there an escape character that could be used to fix the following SQL
> statement? the field [notes] is a string(200).
>
> but you will notice the apostrophe used in the word [it's]. that will cause
> an error. is there an escape character?
>
> INSERT INTO aTable (notes) VALUES ('it's my note')
>
> can you reformat this SQL string to reflect the escape character problem? I
> am using SQL strings exactly like this statement. I am using valentina for
> director.
Hi Larry,
Yes, use '\'
INSERT INTO aTable (notes) VALUES ('it\'s my note')
--
Best regards,
Ruslan Zasukhin [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan@paradigmasoft.com
web: http://www.paradigmasoft.com
To subscribe to the Valentina mail list
send a letter to valentina-on at lists D.OT macserve.net
-------------------------------------------------------------
©2002 Ruslan Zasukhin |
