>I have an insert query.
>When my ocrdata field has the data in two lines:
>'this is my
>first test'
>i am getting an error saying : Command contains unrecognized phrase/keyword.
>If the same data is in 1 line: 'this is my first test'
>that works perfect.
>How can i adjust my data when executing the query.
>
>*********Query************************
>the following fails:
>Insert into ocrdata(id,tiffile,ocdata,created_dt) Values(4333,'demdemorecv10','this is my
>first test',{9/7/2004})
>
>the following works fine:
>Insert into ocrdata(id,tiffile,ocdata,created_dt) Values(4333,'demdemorecv10','this is my first test',{9/7/2004})
>**************************************
>
>I am trying to use the above query via VB to foxpro.
>Please Help.
>
>Thank you very much.

Raj,
Duplicated thread. Thread #940824
Cetin