X
HOME HTML CSS JAVASCRIPT SQL PHP JQUERY ANGULAR XML ASP.NET MORE...
REFERENCES | EXAMPLES | FORUM | ABOUT

ADO AbsolutePage and AbsolutePosition Property


Recordset Object Reference 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)


Recordset Object Reference Complete Recordset Object Reference

Your suggestion:

Close [X]

Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

WEB HOSTING

UK Reseller Hosting

WEB BUILDING

Download XML Editor FREE Website BUILDER Free HTML5 Templates FREE Website Templates Free HTML Templates

SHARE THIS PAGE

facebook