<< Click to Display Table of Contents >> Navigation:  Ado Classes > AdoRecord Class > AdoRecord:Open()

Purpose

Opens an existing Record object, or creates a new item represented by the Record (such as a file or directory).

 

Prototype

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  

Argument(s)

 

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.

 

 

Description

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.

 

 

See Also

AdoRecord, AdoRecord:Cancel(), AdoConnectModeEnum, AdoRecordCreateOptionsEnum, AdoRecordOpenOptionsEnum