Databases Reference
In-Depth Information
Indicates that the data in the current record buffer has been modified but has not
yet been saved.
adEditAdd
Indicates that the
AddNew
method has been invoked and the new data in the
current record buffer has not yet been saved.
adEditDelete
Indicates that the current record has been deleted.
Fields
This returns the
Fields
collection for the given recordset. We will discuss
Field
objects later in the chapter.
Filter
Filters the current recordset by restricting the records that are visible. Thus, for
instance, after executing the code:
rs.Filter = "Lastname = 'Smith' OR FirstName Like 'A*'"
the recordset referenced by
rs
is filtered so that we have access only to those
records that meet the filter condition. We can release the filter by writing:
rs.Filter = ""
Note that after setting a filter, the current record pointer is moved to the first
record that fits the filter criteria. Note also that Microsoft warns that it is
preferable to define and open a new recordset on the data source than to make
extensive use of filters.
LockType
This property, discussed earlier, indicates the type of lock that is placed on the
records during editing.
MaxRecords
This limits the number of records returned by a query. The default value of
0
indicates that all matching records should be returned. This property is read-only
for an open recordset.
