ADO AbsolutePage and AbsolutePosition Property
 Complete Recordset Object Reference
AbsolutePage
The AbsolutePage property sets or returns a long value that specifies the page
number in the Recordset object. It sets or returns a value from 1 to the number
of pages in the Recordset, or it returns a PositionEnum value.
The value is 1 when the current record is the first record in the Recordset.
Tip: To get the total number of pages in the Recordset, use the PageCount
property.
Tip: To divide the Recordset into a series of pages, use the PageSize property.
Note: This property can only be used if the AbsolutePage, PageCount, and PageSize
properties are supported by the provider.
AbsolutePosition
The AbsolutePosition property sets or returns a long value that specifies the
ordinal (numeric) position of the current record in the Recordset object. It
sets or returns a value from 1 to the number of records in the Recordset, or it
returns a PositionEnum value. The value is 1 when
the current record is the first record in the Recordset.
When you set this property to a number, you will be moved to the record at the
numeric position.
Tip: To get the total number of records in the Recordset, use the
RecordCount property.
Note: Do not use this property to uniquely identify a record!
Syntax
objRecordset.AbsolutePage
objRecordset.AbsolutePosition
|
PositionEnum Values
| Constant |
Value |
Description |
| adPosUnknown |
-1 |
Indicates that the Recordset is empty, the current position is
unknown, or the provider does not support the AbsolutePage or
AbsolutePosition property |
| adPosBOF |
-2 |
Indicates that the current record pointer is before the first record (BOF) |
| adPosEOF |
-3 |
Indicates that the current record pointer is after the last record (EOF) |
Complete Recordset Object Reference
Click here to design a Stunning Flash Website for Free
Wix is a revolutionary web design tool that provides anyone with the possibility to create professional and beautiful websites for free.
With e-commerce features, search engine visibility and many more professional tools, Wix is the ultimate solution for creating a spectacular site while saving tons of money.
| 
