sqlException

[kelly devon]

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

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

correction are welcomed thanks

[Rajendar Goud]

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]

thx