How to release row handles?
Posted on 2003-11-04
I'm using adodb recordset(SQLOLEDB) in my application. On my form, I use some text fields(bound to the data using bindingcollection) to display the records. There are command buttons to move through the records (first,previous,next & last) for which I use movefirst,moveprevious, movenext & movelast methods of the recordset.
I also have 'add' and 'update' buttons to add a new record(addnew method) and save the record(update method).
When I try to move through the records using the above four buttons, immediately after adding a record and updating, I get an error message like this.
'You should release all the row handles before getting a new one.'
Please tell me how to release the row handles.