main logo
Subject: any escape sequence for odbc syntax error when feild has same name as odbc keword???
Author: Dennis Golovaty
Posted: 2001/07/02 17:12:15
 
View Entire Thread
New Search


hey all--
Im getting an ODBC sytax error when I try to run an update statement where i am trying to modify the value feild of the table. It is giving me this error because value happens to be a special key term of the odbc driver so the driver is getting confused--i was wondering if there was any escape sequence that should be used so that the driver would not get confused when trying to run a statement like
int change = stmt.executeUpdate("update employee set value='" + new_id + "' where keyname='" + keynameCurr+ "'");
Thank you very much fro your help!!!
 
©2001 Dennis Golovaty
<-- Prior Message New Search Next Message -->