Forum Discussion

Alice's avatar
Alice
Occasional Contributor
10 years ago

ADO RecordSet is not working

  I got the error when go to MoveFirst : Operation is not allowed when the object is closed. However , if I use a simple query like "Select * from location" , it's working fine. Below is code. Any...
  • Alice's avatar
    Alice
    10 years ago

    haha, I think I just remove that USE command!!! Thanks all the same ;-)

    Have a great day.:smileyhappy:

     

    Alice

NisHera's avatar
NisHera
Valued Contributor
10 years ago

Usually this message gets if you try to handle “recset” after object get closed. Are you returning RecSet to another function/procedure and trying to manipulate it at there? If so try doing same within same function.  Also evaluate AConnection.State when you using RecSet, connection state should be not equal to 0(zero)

Connection should be closed after finishing everything.

  • Alice's avatar
    Alice
    Occasional Contributor
    10 years ago

    The state is 1. And I just verify these codes, recset is not used anywhere else.

     

    Thanks for your help ;-)