It works, but it doesn't work

Results 1 to 2 of 2

Thread: It works, but it doesn't work

  1. #1
    Join Date
    Dec 1969

    Default It works, but it doesn't work

    I&#039;m trying to use an SQL statement to update a column in my database. The statement successfully updates the DB, however, I get an error message that stops the page from being displayed.<BR><BR>Error:<BR>ADODB.Recordset (0x800A0E78)<BR>Operation is not allowed when the object is closed.<BR><BR>Code:<BR>strSQLInsertBillingDate = "UPDATE tblTrafficTransaction SET BillingDate = &#039;" & strBillingDate & "&#039; WHERE TransDate &#060;= &#039;" & strBillingDate & "&#039; AND tblTrafficCustomer$CustNum = &#039;" & intCustNum & "&#039;"<BR>set objRS = objConn.Execute(strSQLInsertBillingDate)<BR><BR><B R>objRS.Close <BR>set objRS = Nothing <BR><BR><BR>The line objRS.Close is where the error occurs.<BR>Can anyone give me clue as to what the problem is.<BR><BR>Thanks so much<BR>BCH

  2. #2
    Join Date
    Dec 1969

    Default UPDATE statements do NOT return..

    .. recordset.<BR><BR>Just do:<BR>objConn.Execute strSQLInsertBillingDate<BR><BR>And get rid of the the lines:<BR>objRS.close<BR>set objrs = nothing<BR><BR>-Doug

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts