>>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