>>>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) "
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst