>Hello Everyone..
>
>Listed below is a sample code to update a table by using SQL passthrough statement.
>If someone keys in ? mark as part of the reference field, it causes a syntax error and program fails. Can someone guid me how to overcome this situation ?
>
>
>*-- Sample code
>cTemp.doc_numb = "0000212-00"
>cTemp.doc_refr = "Gadgets Size ? "
>
>lcSQL = "INSERT INTO cDetail (doc_numb, doc_refr) +;
> " VALUES(?cTemp.doc_numb, cTemp.doc_refr) "
>=ExecuteSQL(lcSQL)
>
>
>Thank you in advance...
>
>Raza Malik

Raza,
I think it's hidden in your ExecuteSQL() function. With SQLExec it'd be ?cTemp.doc_refr
Cetin