The Recordset object provides a very flexible method of accessing your data. This object depends on the understanding of the Connection object.
ADO Recordset Properties
|
Property Name |
Description |
|
AbsolutePage |
Returns the current page which the Recordset pointer is on. |
|
AbsolutePosition |
Used to move to a record based on its ordinal position. |
|
ActiveConnection |
Specifies which connection the Recordset will use. |
|
BOF |
Returns a Boolean that specifies if current position is in front of the first record. |
|
Bookmark |
Returns a bookmark that uniquely identifies the current record. |
|
CacheSize |
Specifies the number of records that will be cached into local memory. |
|
CursorLocation |
Specifies where the Recordset cursor will reside. |
|
CursorType |
Specifies the cursor type to use in the Recordset. |
|
EOF |
Specifies that the Recordset pointer is at the end of the Recordset. |
|
EditMode |
Specifies the editing mode of the current record. |
|
Filter |
Indicates a filter for the data in the Recordset. |
|
Locktype |
Specifies the cursor lock type to use on the Recordset. |
|
MarshalOptions |
Indicates which records are marshaled back to the web server. |
|
MaxRecords |
Specifies the maximum number of records to return. |
|
PageCount |
Returns the number of pages in the Recordset object. |
|
PageSize |
Indicates how many records are contained inside one page. |
|
RecordCount |
Returns the number of records contained in the Recordset. |
|
Source |
Specifies the source of the data inside the Recordset object. |
|
State |
Describes the current state of the Recordset Object. |
|
Status |
Describes the current record state in reference to batch operations. |