Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
getting the current position of a recordset
- Thread starter zoomby
- Start date
Not an expert on recordsets and stuff but if your using DAO recordsets then I think the AbsolutePosition property only returns the correct position for dynaset or snapshot recordsets.
If your recordset has no records in it it will return -1. So check your recordsets to ensure that you have records within your recordset.
If your recordset has no records in it it will return -1. So check your recordsets to ensure that you have records within your recordset.
- Thread starter
- #3
Hi,
As Taslin said, open your recordset as a dynaset and check if it has any records for the specified criteria. And I believe the position of the record would be Absolute Position + 1 ( zero based positioning of recordset, I believe ) Hope it helps. Let me know what happens.
With regards,
PGK
As Taslin said, open your recordset as a dynaset and check if it has any records for the specified criteria. And I believe the position of the record would be Absolute Position + 1 ( zero based positioning of recordset, I believe ) Hope it helps. Let me know what happens.
With regards,
PGK
- Thread starter
- #5
I'm not really sure how these recordsets work either, but it seems to be depend on the property settings for the Recordset and Command objects before you open the RS - for instance opening a Client-side Keyset recordset with Optimistic locking always seems to allow me to get the correct Recordcount and AbsolutePosition property values (i.e. not -1)
Dunno if this helps, just thought I'd chuck me oar in.
Dunno if this helps, just thought I'd chuck me oar in.
- Thread starter
- #8
- Status
