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 |