ADO Record Object
Record Objects (ADO version 2.5)
ADO Record object is used to hold the record set a row, or a file system or a directory.
ADO version prior to 2.5 only have access to a structured database. In a structured database, each table in each row have the exact same number of columns, and each column by the same data types.
Record object allows access between the number of columns and rows and rows / or data of different types of data sets.
grammar
objectname.property
objectname.method
objectname.method
Attributes
| Attributes | description |
|---|---|
| ActiveConnection | Sets or returns a Connection object Record object currently belongs. |
| Mode | Sets or returns a valid permission to modify data in a Record object. |
| ParentURL | Returns the absolute URL of the parent Record. |
| RecordType | Record the return type of the object. |
| Source | src parameter setting or return Record object's Open method. |
| State | Back Record object's state. |
method
| method | description |
|---|---|
| Cancel | Cancel the first performance CopyRecord, DeleteRecord, MoveRecord or Open call. |
| Close | Close a Record object. |
| CopyRecord | Copy the file or directory to another location. |
| DeleteRecord | To delete a file or directory. |
| GetChildren | Returns a Recordset object where each row represents files in a directory or subdirectory. |
| MoveRecord | The file or directory to another location. |
| Open | Open an existing Record object or creates a new file or directory. |
set
| set | description |
|---|---|
| Properties | Provider-specific properties of a collection. |
| Fields | Record object contains all the Field objects. |
Property Fields collection
| Attributes | description |
|---|---|
| Count | Returns the number of items in the collection of fields. Start value is 0. example: countfields = rec.Fields.Count |
| Item (named_item / number) | Returns fields in the collection of a specified item. example: itemfields = rec.Fields.Item(1) 或者 itemfields = rec.Fields.Item("Name") |