>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) "
_______________________________________________________________
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