Operation is not allowed
Jeg får fejlmeddelelsen:Operation is not allowed when the object is closed.
/workstatistics/index.asp, line 521
Linje 521 er der hvor jeg bruger update metoden, her er min kode:
If Request("WhatWasChosen") = "DeleteData" Then
Set objConn = Server.Createobject("ADODB.Connection")
strConnString = "Provider=SQLOLEDB;" & _
"Persist Security Info=FALSE;" & _
"User ID=sa;" & _
"Password=pb16950;" & _
"Initial Catalog=WorkStatistics;" & _
"Initial File Name = C:\Programmer\Microsoft SQL Server\MSSQL\" & _
"DATA\WorkStatistics_Data.mdf;"
objConn.Open strConnString
intPrimaryKey = Request.Form("PrimaryKey")
strSQL = "DELETE FROM WorkProjects_T WHERE Primary_Key_BI = '" & intPrimaryKey & "'"
Set objRS = Server.Createobject("ADODB.Recordset")
objRS.Open strSQL, objConn, adOpenDynamic, adLockPessimistic, adCmdText
objRS.Update
objRS.close
Set objRS = Nothing
objConn.close
Set objConn = Nothing
Response.Write "<B>Postsættet med primær nøglen " & intPrimaryKey & " blev slettet.</B>"
End If
Hvad er der galt?
P.s. Den sletter postsættet alligevel!
