DevGuru ADO Record Object



			OBJECT: Record Implemented in version 2.5 Record The ADO Record object can contain a row from a Recordset object, or a directory or file from a file system. Prior to the introduction of the Record object, only structured databases could be accessed by ADO. In a structured database, each table has the exact same number of columns (fields) in each row (record), and each column is composed of the same data type. In other words, the structure of every row in the database is the same. The Record object expands the usefulness of ADO by allowing access to sets of data where the number of columns and/or the data type can vary from row to row. For example, it can handle sets of data that are in a tree-like structure composed of a root with nodes and leaves. The fields associated with the Record object can be viewed by using the Fields Collection. PROPERTIES ActiveConnection Property Sets or returns a variant value defining the Connection object to which the Record object belongs (or a string value if there is no connection). Syntax: recordobject. ActiveConnection Mode Property Sets or returns the provider access permission (the ConnectModeEnum value) for a Record object. Syntax: recordobject. Mode ParentURL Property Returns a string value that is the absolute URL of the record in the Record object. Syntax: recordobject. ParentURL RecordType Property Returns a RecordTypeEnum that is the type of the Record object. Syntax: recordobject. RecordType Source Property Returns a variant value that is the source parameter of the Open method of the Record object. Syntax: recordobject. Source State Property Returns a long value describing if the Record object is open or closed. Syntax: recordobject. State COLLECTIONS Fields Collection A collection containing all of the Field objects associated with a Record object. Properties Collection A collection of Property objects. Each Property object contains a provider-specific property. METHODS Cancel Method Cancels the execution of a pending CopyRecord, DeleteRecord, MoveRecord, or Open call. Syntax: recordobject. Cancel Close Method Closes a Record object. Syntax: recordobject. Close CopyRecord Method Copies a file, or a directory and its contents, to a specified location. Syntax: recordobject. CopyRecord Source, Destination, UserName, Password, Options, Async DeleteRecord Method Deletes a file, or a directory and all of its contents. After such a delete, you need to close the Record object. Syntax: recordobject. DeleteRecord Source, Async GetChildren Method Returns a Recordset object where each row represents a file or directory. Syntax: recordobject. GetChildren MoveRecord Method Moves a file, or a directory and its contents, to a specified location. Syntax: recordobject. MoveRecord Source, Destination, UserName, Password, Options, Async Open Method Used to open an existing Record object, or to create a new file or directory. Syntax: recordobject. Open Source, ActiveConnection, Mode, CreateOptions, Options, UserName, Password