Databases Reference
In-Depth Information
BOF and EOF
As with DAO, these Boolean properties indicate whether the current record
pointer lies before the first record (BOF is
True
) or after the last record (EOF is
True
). In either case, there is no current record.
Bookmark
Each record in an ADO recordset has a bookmark associated with it. (A bookmark
has Variant data type.) We can retrieve this bookmark and store it in a variable
with code such as:
bk = rs.Bookmark
We can then return to this record at any time by writing:
rs.Bookmark = bk
CacheSize
This specifies the number of records that will be placed in the client-side memory
buffer at one time. Put another way, it is the number of records that are fetched
from the data store at one time.
CursorLocation
As discussed earlier, this property specifies the location of the cursor: client-side
or server-side.
CursorType
As discussed earlier, this property specifies the type of cursor: dynamic, keyset,
static, or forward-only.
EditMode
Like DAO, ADO uses a temporary editing buffer for the current record. The
EditMode property indicates the current status of the data in this buffer. Its
possible values are:
adEditNone
Indicates that no editing operation is in progress.
adEditInProgress
