Databases Reference
In-Depth Information
where
Fields
is an optional single field name or an array of field names and the
optional
Values
is the corresponding value (for a single field) or value array (for
a field array) to assign to the fields in the new record. For instance, the code:
rs.AddNew Array(LastName, FirstName), Array("Einstein", "Albert")
adds a new record with values
LastName
=
"Einstein"
and
FirstName
=
"Albert"
.
Clone
Creates a new
Recordset
object that is a duplicate of the
Recordset
object to
which it is applied. It is important to note, however, that a cloned
Recordset
object is not entirely independent of its parent. Here is what the documentation
says about cloned recordsets:
Changes made to one
Recordset
object are visible in all of its clones regardless of
cursor type. However, after you execute
Requery
on the original
Recordset
, the
clones will no longer be synchronized to the original.
Closing the original
Recordset
does not close its copies; closing a copy does not
close the original or any of the other copies.
You can only clone a
Recordset
object that supports bookmarks. Bookmark
values are interchangeable; that is, a bookmark reference from one
Recordset
object refers to the same record in any of its clones.
Close
Closes the recordset.
Delete
Deletes one or more records. Its syntax is:
rs.Delete AffectRecords
where
AffectRecords
is one of the following constants:
adAffectCurrent
Deletes the current record.
adAffectGroup
Causes all records that match the current filter only to be deleted.
