MOVELAST Fail after deleting the last record in a ADO recordset 
Author Message
 MOVELAST Fail after deleting the last record in a ADO recordset

When deleting the last record in a ADO recordset (Im executing in versions
1.5 and 2.0) the MoveLast method I found this error:
BOF or EOF or I`m in a deleted record.
This is true when Im in the deleted record but if I make the next samples i
found again the error:

therecordset.MoveFirst
therecordset.MoveLast => ERROR

or
therecordset.bookmark=<valid bookmark>
therecordset.MoveLast => ERROR

One solution is make therecordset.Requery, but I need this method because I
need working with the same recordset.

Thanks in advance.




Sat, 17 Feb 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. ADO Recordset - delete last record then ????

2. ADO recordset MoveLast fails

3. ADO recordset moveLast fails

4. Can't do MoveLast in ADO when record is deleted

5. ADO Recorset - delete last record then ?????

6. Deleting Record in Recordset fails

7. MS Datagrid - Delete Fails with SQL ADO recordset

8. ADO 2.0 MoveLast fails Suggestions?

9. Can't do MoveLast when record is deleted

10. Deleting a record in a ADO recordset

11. Deleting a record in a ADO recordset

12. Q ADO-Recordset:how to find deleted records

 

 
Powered by phpBB® Forum Software