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. |