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