Databases Reference
In-Depth Information
Key1...
Saves changes initiated by the Edit or AddNew
methods
Update
Sub
3.0/3.5
A.15.3 Properties
Property
Type
Version
Description
AbsolutePosition
Long
3
.0/3.5
Returns or sets the relative record number of the current record
Indicates the number of rows having collisions in the last batch
update
BatchCollisionCount Long
3.5
BatchCollisions
Variant 3.5
Indicates which rows had collisions in the last batch update
BatchSize
Long
3
.5
Determines how many updates to include in a batch
Indicates whether the current record position is before the first
record
BOF
Boolean 3.0/3.5
Bookmark As
Byte
3.0/3.5 Uniquely identifies a particular record in a Recordset
Bookmarkable
Boolean
3
.0/3.5
Indicates whether a Recordset supports bookmarks
Indicates the number of records from an ODBC data source to be
cached locally
CacheSize
Long
3.0/3.5
Bookmarks the first record to be cached from an ODBC data
source
CacheStart As
Byte
3.0/3.5
Indicates the date and time when the underlying base table was
created
DateCreated
Variant 3.0/3.5
EditMode
Integer 3.0/3.5 Indicates the state of editing for the current record
EOF
Boolean
3
.0/3.5 Indicates whether the current record position is after the last record
Filter
String
3
.0/3.5 Defines a filter to apply to a Recordset
Indicates the name of the current Index object (table-type Recordset
only)
Index
String
3.0/3.5
LastModified As
Byte
3
.0/3.5 Bookmarks indicating the most recently added or changed record
Indicates the date and time of the most recent change to the
underlying base table
LastUpdated
Variant 3.0/3.5
Indicates the type of locking (optimistic or pessimistic) in effect
during editing
LockEdits
Boolean 3.0/3.5
Name
String
3.0/3.5 Indicates the name of the Recordset object
Indicates whether the Seek or Find methods succeeded in finding a
record
NoMatch
Boolean 3.0/3.5
PercentPosition
Single
3
.0/3.5 Indicates or changes the approximate location of the current record
RecordCount
Long
3
.0/3.5 Indicates the number of records in the Recordset object
RecordStatus
Integer
3
.5
Indicates the batch-update status of the current record
Restartable
Boolean 3.0/3.5 Indicates whether the Recordset supports the Requery method
Sort
String
3
.0/3.5 Defines the sort order for records in a Recordset
StillExecuting
Boolean 3.5
Indicates whether an asynchronous method call is still executing
Transactions
Boolean
3
.0/3.5 Indicates whether the Recordset supports transactions
Type
Integer
3
.0/3.5 Indicates the object's data type
Updatable
Boolean
3
.0/3.5 Indicates whether records in the Recordset can be updated
UpdateOptions
Long
3
.5
Determines how a batch update query will be constructed
ValidationRule
String
3.0/3.5 Contains an expression that must evaluate True for a successful
