>Thanks,
>the main problem are the deleted records,
>cause i can´t read the values from adDelete marked records.
You can "recall" deleted records with CancelBatch() to access their data. For example:
If myRs.Status = adRecDeleted Then
myRs.CancelBatch(adAffectCurrent)
Endif
Use CancelUpdate() if you have not moved to another record or called the Update() method to apply a deletion operation.
>another question:
>if i receive recordsets from an ms sqlserver 7 i can´t get the cursortyp
>adOpenDynamic,it is always adOpenStatic.
>
>Do you know if this is an restriction from the sqlserver ?
>
>achim
SQL7 supports dynamic cursors. Just don't change the default cursor location for the connection or the recordset of adUseServer and this should return a dynamic rs:
myRs.open("Select * From myTable", myConn, adOpenDynamic)
HTH