Database access from java, INSERT query problem

nitusincog · #1 (**permalink**) July 21st, 2003, 05:35 AM

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

TomPaul · #2 (**permalink**) July 21st, 2003, 10:26 AM

Are quantity, price, and ex rate really strings?

Associate Instructor - Hofstra University

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
INSERT into Access Database from VBA for Excel	zuerlein	Excel VBA	0	June 3rd, 2007 01:51 AM
Insert row into MS-ACCESS database	ITladybug	ADO.NET	1	January 28th, 2006 07:57 AM
Insert into error with union query in Access 2002	roniestein	Access	8	December 21st, 2004 07:47 PM
INSERT info into a Access database for display	sideshow245	Classic ASP Databases	2	January 7th, 2004 04:25 PM
INSERT string into a Microsoft Access Database	gsolis	Classic ASP Databases	1	December 31st, 2003 05:31 PM