Prompt Property (Remote Data)

       

Returns or sets a value that specifies if the ODBC driver manager should prompt for missing connect string arguments.

Syntax

object.Prompt [= value]

The Prompt property syntax has these parts:

Part Description
object An object expression that evaluates to an object in the Applies To list.
value A constant or Integer as described in Settings.

Settings

The settings for the Prompt property are:

Constant Value Description
rdDriverPrompt 0 The driver manager displays the ODBC Data Sources dialog box. The connection string used to establish the connection is constructed from the data source name (DSN) selected and completed by the user via the dialog boxes. Or, if no DSN is chosen and the DataSourceName property is empty, the default DSN is used.
rdDriverNoPrompt 1 The driver manager uses the connection string provided in connect. If sufficient information is not provided, the OpenConnection method returns a trappable error.
rdDriverComplete 2 If the connection string provided includes the DSN keyword, the driver manager uses the string as provided in connect, otherwise it behaves as it does when rdDriverPrompt is specified.
rdDriverCompleteRequired 3 (Default) Behaves like rdDriverComplete except the driver disables the controls for any information not required to complete the connection.

Remarks

When RDO opens a connection based on the parameters of the RemoteData control, the Connect property is expected to contain sufficient information to establish the connection. If information like the data source name, user name, or password are not provided, the ODBC driver manager exposes one or more dialog boxes to gather this information from the user. If you do not want these dialog boxes to appear, set the Prompt property accordingly to disable this feature.

The constants shown above are also used to set the ODBC prompt behavior for the EstablishConnection method.