p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Beginning Java 2 (http://p2p.wrox.com/forumdisplay.php?f=30)
-   -   Database access from java, INSERT query problem (http://p2p.wrox.com/showthread.php?t=1893)

nitusincog July 21st, 2003 05:35 AM

Database access from java, INSERT query problem
 
[B)] 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 July 21st, 2003 10:26 AM

Are quantity, price, and ex rate really strings?

Associate Instructor - Hofstra University


All times are GMT -4. The time now is 07:53 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.