Win a copy of Escape Velocity: Better Metrics for Agile Teams this week in the Agile and Other Processes forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Tim Cooke
  • Paul Clapham
  • Jeanne Boyarsky
Sheriffs:
  • Ron McLeod
  • Frank Carver
  • Junilu Lacar
Saloon Keepers:
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Al Hobbs
  • Carey Brown
Bartenders:
  • Piet Souris
  • Frits Walraven
  • fred rosenberger

sqlException

 
Ranch Hand
Posts: 78
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hi,

someone help me out here i am trying to update using my gui
an access database and i keep getting an SQLException which
says "SQLException too few parameters expected1"
and this is the line of code doing this
correction are welcomed thanks
 
Ranch Hand
Posts: 220
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Kelly,
With the exception it looks like the parameters you r passing are less as compared to what the query expects.

In the query
stat.executeupdate("UPDATE Stock"+"SET Qty(dbfieldname)="+ quantity(variable)+" "+WHERE Itemsno(dbfieldname)='"item+"'");


quantity(variable) is a field i guess which u r picking from GUI.
so it too must be in single quotes .

stat.executeupdate("UPDATE Stock"+"SET Qty(dbfieldname)='"+ quantity(variable)+"'"+WHERE Itemsno(dbfieldname)='"item+"'");

try this out

thanks,
Rajendar
 
kelly devon
Ranch Hand
Posts: 78
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
thx
 
Anything worth doing well is worth doing poorly first. Just look at this tiny ad:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic