I can't get the record number in ADO recordset [RESOLVED]

**Jethro Tull** · May 26th, 2005, 03:54 PM

I've tried with .AbsolutePosition but it gets -2 or something like this

Can somebody help me, please?

Thanks in advance.

**Jethro Tull** · May 26th, 2005, 05:09 PM

My mistake, the value was -3 (what means EOF), I believe I was in the first record....

**Pradeep1210** · May 27th, 2005, 02:26 AM

Originally Posted by Jethro Tull

I've tried with .AbsolutePosition but it gets -2 or something like this

Can somebody help me, please?

Thanks in advance.

The AbsolutePosition is not correct if u are using a Server Side cursor.
Before opening the recordset, make it a Client side cursor

VB Code:

rs.CursorLocation = adUseClient

Then the absolute position should return correct value

Thread: I can't get the record number in ADO recordset [RESOLVED]