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;
ONumber]) AND ((InspectionsDetails.ItemI