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();