>>>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
>>
>>Hi Raza,
>>The command line must be
>>

>>lcSQL = "INSERT INTO cDetail (doc_numb, doc_refr)" +;
>>" VALUES(?cTemp.doc_numb, cTemp.doc_refr) "
>>

>
>Yes, typo corrected but ? should be added as well.
>Cetin

Hi Cetin,
I agree. ? should be added.

lcSQL = "INSERT INTO cDetail (doc_numb, doc_refr)" +;
" VALUES(?cTemp.doc_numb, ?cTemp.doc_refr) "