E
Eugene Anthony
ASP code to delete a record:
openDB()
Set rs = Server.CreateObject("ADODB.Recordset")
objConn.usp_deleteOptions OptionID,rs
closeRS()
closeDB()
MS SQL Stored Procedure:
create procedure usp_deleteOptions
@OptionID int
AS SET NOCOUNT ON
DELETE FROM Options WHERE OptionID=@OptionID
Return
GO
Problem:
When I try to delete a record I get this error:
Error Type:
ADODB.Recordset (0x800A0E78)
Operation is not allowed when the object is closed.
How do I solve the problem.
Your help is kindly appreciated.
Eugene Anthony
openDB()
Set rs = Server.CreateObject("ADODB.Recordset")
objConn.usp_deleteOptions OptionID,rs
closeRS()
closeDB()
MS SQL Stored Procedure:
create procedure usp_deleteOptions
@OptionID int
AS SET NOCOUNT ON
DELETE FROM Options WHERE OptionID=@OptionID
Return
GO
Problem:
When I try to delete a record I get this error:
Error Type:
ADODB.Recordset (0x800A0E78)
Operation is not allowed when the object is closed.
How do I solve the problem.
Your help is kindly appreciated.
Eugene Anthony