hello, i have this question. i want to update a data base record. so i am using this coding. PreparedStatement st_stockaddps=st_stockaddcon.prepareStatement("INSERT INTO inventory VALUES("+st_descriptionst+","+st_ppust+","+st_qtyst+","+st_reorderlevelst+","+st_suppliercodest+","+st_totalcostst+","+st_totalcostst+")WHERE I_Code=?"); st_stockaddps.setString(1,st_itemcodest); st_stockaddps.executeUpdate(); but the problem is when i execute this statement it gives a sql exception saying "Missing semicolon( at the end of sql statement.. please send a quick reply. thank you.
SCJP 1.4, SCMAD 1.0<br />SCWCD, SCBCD (in progress)
hi, you certainly will have more success by posting this at the jdbc forum. normally the jdbc driver cares for semicolons at the end. so at a first glance, this seems to be a driver problem? cheers, chantal