mgmhicks
asked on
Access database won't remove 2nd rows
I have a datset that I go through the rows, check the status of the row and do the appropriate change in the code attached. I have a stored procedure that I send parameters to, when I go through the code, the first record is deleted, but as I go through the 2nd row to be deleted or any rows after that, it doesnt delete the other rows. When I look at the parameter values they do look correct, but the row doesnt get deleted nor do I get a error. Any suggestions would help. i have attached the vb code as well as the access procedure.
Access procedure, again the first record works the 2nd doesnt.
PARAMETERS [@WONumber] Text ( 255 ), [@ItemID] Long;
DELETE *
FROM InspectionsDetails
WHERE (((InspectionsDetails.WO_N umber)=[@W ONumber]) AND ((InspectionsDetails.ItemI D)=[@ItemI D]));
thanks
SaveInspectionDetails.txt
Access procedure, again the first record works the 2nd doesnt.
PARAMETERS [@WONumber] Text ( 255 ), [@ItemID] Long;
DELETE *
FROM InspectionsDetails
WHERE (((InspectionsDetails.WO_N
thanks
SaveInspectionDetails.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
ASKER
thanks