Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Error in Query

 
M. Imran
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,
Can any one tell what is problem in the following query, when I run this in a MS Access 2000 db from a java application it give error 'Syntax error in INSERT INTO statement' where date, desc, and memo fields are text type while other all are numeric.
query is : INSERT INTO Assets (transnum, acc_number, date, desc, memo, debit, credit, quantity, rate) VALUES ('10', '10', 'x', 'x', 'x', '10', '10', '10', '10' )
I will be very grateful to you,
Thank you,
Imran
 
vidya archana
Ranch Hand
Posts: 36
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
u dont have to use quotes for numerical values.
 
Nathan Pruett
Bartender
Posts: 4121
IntelliJ IDE Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm moving this to a more appropriate forum than Swing/JFC/AWT, since this question has nothing to do with building GUIs...
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic