CodeCharge Studio

DLookup

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 Field or expression to be used in the SELECT clause of the SQL statement to be executed.
Domain Table or view name to be used in the FROM clause of the SQL statement to be executed.
Criteria Criteria to be used in the WHERE clause of the SQL statement to be executed.
Connection Connection from which the database value will be retrieved.
Convert result to 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 Type of variable which will receive the retrieved database value [Control, variable, expression, session, application, cookie].
Target Name of the variable which will receive the retrieved database value.


On-line, printable versions and updates