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.