any escape sequence to get around odbc syntax error??

[dendog]

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

 

[tlbroadbent]

Try using brackets to delimit column names.

stmt.executeUpdate("update employee set [value]='" + new_id + "' where [keyname]='" + keynameCurr + "'"
Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin