<< Click to Display Table of Contents >>
Opens an existing Record object, or creates a new item represented by the Record (such as a file or directory).
METHOD Open ( uSource AS USUAL, uActiveConnection AS USUAL, liMode AS USUAL,
liCreateOptions AS USUAL, liOptions AS USUAL, cUsername AS USUAL,
cPassword AS USUAL ) AS VOID
uSource USUAL(Optional) the source for this Record object. See below
uActiveConnection USUAL (Optional) the connect string or open Connection object
liMode LONG (Optional)A ConnectModeEnum value, whose default value is adModeUnknown
liCreateOptions LONG (Optional)A RecordCreateOptionsEnum value, whose default value is adFailIfNotExists
liOptions LONG (Optional)A RecordOpenOptionsEnum value, whose default value is adOpenRecordUnspecified
cUserName STRING (Optional)the user ID that, if needed, authorizes access to Source.
cPassWord STRING (Optional)the password that, if needed, verifies UserName.
uSource may be:
•A URL. If the protocol for the URL is http, then the Internet Provider will be invoked by default. If the URL points to a node that contains an executable script (such as an .ASP page), then a Record containing the source rather than the executed contents is opened by default. Use the Options argument to modify this behavior.
•A Record object. A Record object opened from another Record will clone the original Record object.
•A Command object. The opened Record object represents the single row returned by executing the Command. If the results contain more than a single row, the contents of the first row are placed in the record and an error may be added to the Errors collection.
•A SQL SELECT statement. The opened Record object represents the single row returned by executing the contents of the string. If the results contain more than a single row, the contents of the first row are placed in the record and an error may be added to the Errors collection.
•A table name.
AdoRecord, AdoRecord:Cancel(), AdoConnectModeEnum, AdoRecordCreateOptionsEnum, AdoRecordOpenOptionsEnum