Hi All..

I am updating a database using SQL passthrough. Listed below is the part of sample code I use:

*-- Sample Code
gnC = SQLCONNECT("test_database")

lcSQL = "INSERT INTO cHistory (trn_numb, trn_date, itm_desc, id) " +;
" VALUES (?cTemp.trn_numb, ?cTemp.trn_date, ?cTemp.itm_desc, ?lnId) "

=SQLEXEC(gnC, tcSQL)
*-- End

The problem I am having is if user keys in ? mark as part of any fields such as Description, I get a syntex error. Is there any work around this problem.

Thank You in advance...

Sincerely,

Raza Malik