Hi
There seem to be a number of posts already with this error message but none of them have helped me ...
I am trying to execute some dynamic SQL from an ASP form to update or delete from a table and I get the following output:-
==
SQL=Update StockItemMaterials set [MatQuantity]=3 WHERE [StockItemCompKey]="P0855" AND [MaterialCode]="GOGGW"
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
/Apps/sv_simUpd.asp, line 44
==
The table I am trying to update is:
Select * from StockItemMaterials WHERE StockItemCompKey='P0855'
StockItemCompKey Text
MaterialCode Text
MatQuantity Number
UnitPrice Number
OverRideFactor Number
Ganoksin Yes/No
TotalPrice Number
Example Data: P0855 GOGGW 5310 0 True 0
I also get the same error when trying to delete from this table:
==
SQL=Delete from StockItemMaterials WHERE [StockItemCompKey]="P0855" AND [MaterialCode]="GOGGW"
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
/Apps/sv_simUpd.asp, line 44
==
I have cut and pasted the SQL into an ACCESS query and it runs fine!
Thanks