Update statements.

hey im having a little bit of trouble excecuting my update statsments.
I chekd in access directly and am sure that there is no errors in my
SQL.

this is the code i used. The connection is fine its been tested before.


String remove = "UPDATE items SET qty = qty - 1 WHERE store =
'"+from+"' and barcode ='"+barcode+"'";

Statement stmt = null;

try {
stmt = conn01.createStatement();
stmt.executeUpdate(remove);
} catch (SQLException e) {
e.printStackTrace();
}


If anyone knows what the error is it would be greatly appreciated.
thanks
-morc

.

Relevant Pages

  • Excecuting Update Statements
    ... hey im having a little bit of trouble excecuting my update statsments. ... I chekd in access directly and am sure that there is no errors in my ... Statement stmt = null; ...
    (comp.lang.java.programmer)
  • Re: Update statements.
    ... I chekd in access directly and am sure that there is no errors in my ... SQL. ... The connection is fine its been tested before. ... Statement stmt = null; ...
    (comp.lang.java.databases)