General information
Title:
Having problem with Insert query
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only