View Single Post
  #1 (permalink)  
Old July 21st, 2003, 05:35 AM
nitusincog nitusincog is offline
Registered User
 
Join Date: Jul 2003
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Database access from java, INSERT query problem

Hello,
Am having problem with a sql query. I am connecting to msaccess database from java. The INSERT and SELECT queries work fine, but for some reason the UPDATE query does not work. Could you check to see if the syntax is correct please.

String qwy = "UPDATE QuoteLine SET " +
              "Item='" + txtprodName.getText() +
              "', Quantity='" + txtQuantity.getText() +
              "', QuotedPrice='" + getfinalPrToQuote() +
              "', ExRate='" + getConvRate() +
              "' WHERE QuoteRef=" + txtQuotRef.getText();