CodeCharge Studio

DLookup

You can use this action to retrieve the value of a single database field or expression. The retrieved database value is then used to set the value of a target variable.

Property Description

Expression The field or expression to be used in the SELECT clause of the SQL statement to be executed.

Domain The table or view name to be used in the FROM clause of the SQL statement to be executed.

Criteria The criteria to be used in the WHERE clause of the SQL statement to be executed.

Connection The connection from which the database value will be retrieved.

Convert result to The data type to which the retrieved value should be converted. The type specified must comply with the nature of the value to be retrieved i.e. a string cannot be converted to an integer. The possible data types are Text, Integer, Float, Date, Boolean and Memo .

Type Of Target The type of variable which will receive the retrieved database value. [Control, variable, expression, session, application, cookie]

Target The name of the variable which will receive the retrieved database value.

Property	Description
Expression	The field or expression to be used in the SELECT clause of the SQL statement to be executed.
Domain	The table or view name to be used in the FROM clause of the SQL statement to be executed.
Criteria	The criteria to be used in the WHERE clause of the SQL statement to be executed.
Connection	The connection from which the database value will be retrieved.
Convert result to	The data type to which the retrieved value should be converted. The type specified must comply with the nature of the value to be retrieved i.e. a string cannot be converted to an integer. The possible data types are Text, Integer, Float, Date, Boolean and Memo .
Type Of Target	The type of variable which will receive the retrieved database value. [Control, variable, expression, session, application, cookie]
Target	The name of the variable which will receive the retrieved database value.

On-line, printable versions and updates