in a stored procedure with access i have this instruction delete * from table 1 where idfield in (@parameter) idfield is a field counter if i want to delete multiple records, how do ?
This really depends on the way you choose to create the list of idfields..... you would need to create some sort of array, and then iterate through them, and run/execute the query over and over, one by one, until they all were deleted.
abmcr
Member
165 Points
33 Posts
Stored procedure
Sep 10, 2003 09:34 AM|LINK
augustwind
All-Star
35860 Points
4900 Posts
ASPInsiders
Moderator
Re: Stored procedure
Sep 10, 2003 04:45 PM|LINK
All Things Dot Net
Stored Procs and Code in a Flash!
ASP.Net Sitemap Creator