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
Whether you're new to XML or already an advanced user,
the user-friendly views and powerful entry helpers,
wizards, and debuggers in XMLSpy are designed to meet your XML
and Web development needs from start to finish.
New features in Version 2010!
- XML editor
- Graphical XML Schema / DTD editors
- XSLT 1.0/2.0 editor, debugger, profiler
- XQuery editor, debugger, profiler
- XBRL validator, taxonomy editor, taxonomy wizard
- Support for Office Open XML (OOXML)
- Graphical WSDL 1.1/2.0 editor & SOAP debugger
- JSON editing & conversion
- Java, C#, C++ code generation
- And much more!
Download a free trial today!
|
|
|
|
