Closing a recordset

Results 1 to 2 of 2

Thread: Closing a recordset

  1. #1
    Join Date
    Dec 1969

    Default Closing a recordset

    I seem to be getting an error when I try to close a recordset. When I use the good old "objRS.Close" command at the end of certain pages, I get an error that says I can't do that when the object is closed. I get this only when using the UPDATE command in my SQL statement. When using the SELECT command, the objRS.Close works fine. Is it because I'm being specific as to which exact record is being updated when using the UPDATE statement?

  2. #2
    Join Date
    Dec 1969

    Default just to be sure use this:

    IF objRS.State = 1 THEN objRS.Close &#039;1 = open 0 = closed<BR>

Posting Permissions

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