![]() |
![]() |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Fields |
All the stored Field objects of a Recordset object. |
Properties |
All the Property objects for a specific instance of a Recordset object. This collection is not currently supported on UNIX. |
Methods
AddNew |
Creates a new record for an updateable Recordset object. |
CancelBatch |
Cancels a pending batch update. This method is not currently supported on UNIX. |
CancelUpdate |
Cancels any changes made to the current record prior to calling the Update method. |
Clone |
Creates a new Recordset object from an existing Recordset object. This method is not currently supported on UNIX. |
Close |
Closes an open Recordset object and any dependent objects. |
Delete |
Deletes the current record or group of records from a Recordset object. |
GetRows |
Retrieves multiple rows from a Recordset object into an array. |
Move |
Moves the position of the current record in a Recordset object. |
MoveFirst |
Moves to the first record in a Recordset object and makes that record the current record. |
MoveLast |
Moves to the last record in a Recordset object and makes that record the current record. |
MoveNext |
Moves to the next record in a Recordset object and makes that record the current record. |
MovePrevious |
Moves to the previous record in a Recordset object and makes that record the current record. |
NextRecordset |
Clears the current Recordset object and returns the next recordset by advancing through a series of commands. This method is not currently supported on UNIX. |
Open |
Opens a cursor. |
Requery |
Updates the data in a Recordset by re-executing the query on which the object is based. |
Resync |
Refreshes the data in the Recordset object from the underlying database. |
Supports |
Determines whether a specified Recordset object supports a particular type of functionality. |
Update |
Saves any changes you make to the current record of a Recordset object. |
UpdateBatch |
Writes all pending batch updates. This method is not currently supported on UNIX. |
Properties
AbsolutePage |
The page in which the current record resides. |
AbsolutePosition |
The ordinal position of a Recordset object's current position. |
ActiveConnection |
The Connection object to which the Recordset object currently belongs. |
BOF |
If True, the current record position is before the first record in a Recordset object. |
Bookmark |
A value that uniquely identifies the current record in a Recordset object. Setting the Bookmark property to a valid bookmark changes the current record. |
CacheSize |
The number of records from a Recordset object that are cached locally in memory. This property is not currently supported on UNIX. |
CursorLocation |
The location of the cursor engine. |
CursorType |
The type of cursor used in a Recordset object. |
EditMode |
The editing status of the current record. |
EOF |
True if the record position is after the last record in a Recordset object. |
Filter |
A filter for data in a Recordset object. |
LockType |
The type of locks placed on records during editing. |
MarshalOptions |
Which records are to be marshaled back to the server. |
MaxRecords |
The maximum number of records to return to a Recordset object from a query. |
PageCount |
The number of pages of data the Recordset object contains. |
PageSize |
The number of records that make up one page in the Recordset object. |
RecordCount |
The current number of records in a Recordset object. |
Source |
The source for the data in a Recordset object. |
State |
Describes the current state of the Recordset object. |
Status |
The status of the current record with respect to batch updates or other bulk operations. |
Remarks
Use Recordset objects to manipulate data from a provider. In ADO data is almost entirely manipulated using Recordset objects. All Recordset objects are constructed using records (rows) and fields (columns). Depending on the functionality supported by the provider, some Recordset methods or properties may not be available.
Cursor | Description |
Dynamic |
Allows you to view additions, changes and deletions by other users, and allows all types of movement through the Recordset that don't rely on bookmarks; allows bookmarks if the provider supports them. |
Keyset |
Behaves like a dynamic cursor, except that it prevents you from seeing records that other users add, and prevents access to records that other users delete. Data change by other users will still be visible. It always supports bookmarks and therefore allows all types of movement through the Recordset. |
Static |
Provides a static copy of a set of records for you to use to find data or generate reports. Always allows bookmarks and therefore allows all types of movement through the Recordset. Additions, changes, or deletions by other users will not be visible. This is the only type of cursor allowed when you open a client-side (ADOR) Recordset object. |
Forward-only |
Behaves identically to a dynamic cursor except that it allows you to scroll only forward through records. This improves performance in situations where you need to make only a single pass through a Recordset. |
Note:
To execute a query without using a Command object, pass a query string to the Open method of a Recordset object. However, a Command object is required when you want to retain the command text and re-execute it, or use query parameters.
Copyright © 2000 Chili!Soft