Record Object | (Versions 2.5, 2.6) |
The Record object represents either a single row within a Recordset object or a resource in a semistructured data source, such as a file directory. |
Record.ActiveConnection Property | (Versions 2.5, 2.6) |
Record.ActiveConnection = ConnectionString Set Record.ActiveConnection = ConnectionObject | |
The ActiveConnection property indicates to which Connection object the current Record object belongs. |
|
Datatype | |
String or Variant (containing the current Connection object) |
|
Description | |
The ActiveConnection property of the Record object is both read- and write-enabled while the Record object is closed and read-only once it is opened. This property can be set to either a connection string or a Connection object and returns a Connection object when it is read. If the Record object was opened from an existing Record object or a Recordset object, then the Record object gains its Connection object from this object. If the Record object is opened by using a URL, a Connection object is automatically created for the Record object and is accessible from the ActiveConnection property. |
|
See Also | |
Record.Open Method |
|
Record.Cancel Method | (Versions 2.5, 2.6) |
record.Cancel | |
The Cancel method cancels an asynchronous operation for the Record object. |
|
Description | |
The Cancel method can be called to cancel an asynchronous operation of the Record object invoked by the CopyRecord, DeleteRecord, MoveRecord, and Open methods. |
|
See Also | |
Record.CopyRecord Method, Record.DeleteRecord Method, Record.MoveRecord Method, Record.Open Method |
|
Record.Close Method | (Versions 2.5, 2.6) |
record.Close | |
The Close method closes an opened Record object. |
|
Description | |
The Close method can be called only on an open Record object. After calling the Close method, the Open method can be called again to reopen the Record object. Calling the Close method releases any resources allocated to the Record object. |
|
Record.CopyRecord Method | (Versions 2.5, 2.6) |
record.CopyRecord (Source, _ Destination, _ UserName, _ Password, _ Options, _ Async) As String | |
The CancelBatch is a member method of the Recordset object that cancels the currently pending batch update. |
|
Arguments | |
|
|
Returns | |
String |
|
Description | |
By default, the CopyRecord method will not overwrite a resource that already exists. To force the replacement of the destination resource, use the adCopyOverWrite option. By default, the CopyRecord method will copy all subdirectories and files beneath the source resource unless the adCopyNonRecursive option is specified. If the source and the destination resources are identical, an error will occur. If the destination resource is a child of the source resource, the operation will never complete. The return value, although provider-specific, is usually the name of the destination resource. |
|
See Also | |
CopyRecordOptionsEnum Enumeration |
|
Record.DeleteRecord Method | (Versions 2.5, 2.6) |
record.DeleteRecord Source, Async | |
The DeleteRecord method deletes the resource represented by the current Record object, or another if specified. |
|
Arguments | |
|
|
Description | |
The DeleteRecord method deletes all children resources of the current resource as well. The Record object should be closed immediately after calling the DeleteRecord method because its behavior would be unpredictable. At the very least, an error will occur when trying to work with a Record object that represents a deleted resource. If the Record object was created from a Recordset object, you should either close and reopen the Recordset object or call Resync or Requery for the resource to be removed from it. |
|
See Also | |
Recordset.Open Method, Recordset.Requery Method, Recordset.Resync Method |
|
Record.Fields Collection | (Versions 2.5, 2.6) |
record.Fields | |
The Fields collection contains individual Field objects for the current Record object. |
|
Datatype | |
Fields (Collection object) |
|
Description | |
The Fields collection contains multiple Field objects for the current Record object. There are two special Field objects, adDefaultStream and adRecordURL,that can be accessed by specifying the FieldEnum enumeration. One returns the default string for the current Record object, and the other returns the URL. Field objects can be added to the collection either by calling the Field.Append method or by referencing a Field by name that is not already part of the collection. Calling the Field.Update method will add the field to the collection, if possible, within the data source. Until this moment, the Field.Status property will return adFieldPendingInsert. |
|
See Also | |
Field.Append Method, Field.Update Method, FieldEnum Enumeration |
|
Record.GetChildren Method | (Versions 2.5, 2.6) |
Set recordset = record.GetChildrean | |
The GetChildren method returns the children of a collection Record object in the form of a Recordset object. |
|
Returns | |
Recordset object |
|
Description | |
The GetChildren method returns a Recordset object containing children of the current Record object. Each record within the returned Recordset object represents a single resource that is a child of the resource represented by the associated Record object. |
|
Record.Mode Property | (Versions 2.5, 2.6) |
record.Mode = ConnectModeEnum | |
The Mode property indicates the permissions for modifying data within a Record object. |
|
Datatype | |
ConnectModeEnum |
|
Description | |
The default value for the Mode property of a Record object is adModeRead. The Mode property is read- and write-enabled while the Record object is closed, but read-only once it is opened. |
|
See Also | |
ConnectModeEnum Enumeration |
|
Record.MoveRecord Method | (Versions 2.5, 2.6) |
record.MoveRecord (Source, _ Destination, _ UserName, _ Password, _ Options, _ Async) As String | |
The MoveRecord method moves a resource to another location. |
|
Arguments | |
|
|
Returns | |
String |
|
Description | |
By default, the MoveRecord method does not overwrite a resource that already exists. To force the replacement of the destination resource, use the adCopyOverWrite option. All hypertext links in the file are automatically updated unless otherwise specified in the Options argument. If the source and the destination resources are identical, an error will occur. If the Record object was created from a Recordset object, you should close and reopen the Recordset object or call Resync or Requery for the resource to be removed from the recordset. Not all properties of the Record object will be automatically repopulated -- to do this, close and reopen the Record object. The return value, although provider-specific, is usually the name of the destination resource. |
|
See Also | |
MoveRecordOptionsEnum Enumeration, Record.Close Method, Record.Open Method, Recordset.Open Method, Recordset.Requery Method, Recordset.Resync Method |
|
Record.Open Method | (Versions 2.5, 2.6) |
record.Open (Source, _ ActiveConnection, _ Mode, _ CreateOptions, _ Options, _ UserName, _ Password) | |
The Open method opens an individual record in a recordset or a resource within a data source. |
|
Arguments | |
|
|
Description | |
If the Record object represents a resource that cannot be represented by a URL, then the ParentURL property and the adRecordURL default field both return Null. |
|
See Also | |
ConnectModeEnum Enumeration, RecordCreateOptionsEnum Enumeration, RecordOpenOptionsEnum Enumeration |
|
Record.ParentURL Property | (Versions 2.5, 2.6) |
record.ParentURL = ParentURL | |
The ParentURL is used to indicate the parent record of the current Record object by means of an absolute URL. |
|
Datatype | |
String |
|
Description | |
The ParentURL property indicates the parent resource of the current resource represented by the Record object. This property is read-only. The ParentURL can be Null if there is no parent for the current resource represented by the Record object or if the resource cannot be expressed in terms of a URL. |
|
Record.Properties Collection | (Versions 2.5, 2.6) |
record.Properties | |
The Properties collection contains characteristics specific to the Record object for the currently used provider. |
|
Datatype | |
Properties (Collection object) |
|
Description | |
The Properties collection class contains a Property class instance for each property specific to the Record object for the data provider. |
|
Record.RecordType Property | (Versions 2.5, 2.6) |
record.RecordType = RecordTypeEnum | |
The RecordType property indicates the type of the current record. |
|
Datatype | |
RecordTypeEnum |
|
Description | |
The RecordType property is read-only; it indicates the type of the current Record object. |
|
See Also | |
RecordTypeEnum Enumeration |
|
Record.Source Property | (Versions 2.5, 2.6) |
Set record.Source = object | |
The Source property indicates from which object the Record object is created. |
|
Datatype | |
Variant |
|
Description | |
The Source property is read-only when the Record object is open, but read- and write-enabled while it is closed. The Source property can be set to a Recordset or Command object. If the Source property is set to a Recordset object, the Record object will be opened based upon the current record of the Recordset object. If the Source property is set to a Command object, the Command object must return a single row. If the ActiveConnection property is also set, then the Source property must be set to an object that is within the connection's scope. The Source property returns the Source argument of the Record.Open method. |
|
See Also | |
Record.ActiveConnection Property, Record.Open Method |
|
Record.State Property | (Versions 2.5, 2.6) |
state = record.State | |
The State property indicates the current state of the Record object. |
|
Datatype | |
Long (ObjectStateEnum) |
|
Description | |
The read-only State property returns a Long value that can be evaluated as an ObjectStateEnum enumeration value. The default value for the Record object is closed (adStateClosed). For the Record object, the State property can return multiple values when the object is executing an operation asynchronously (i.e., adStateOpen and adStateExecuting). |
|
See Also | |
ObjectStateEnum Enumeration |
|