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
posted 11 years ago
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 .