Lookup actions

Use the Lookup actions to validate field values by using database lookups and populate fields with lookup results.

The Lookup actions opens a connection to the Lookup database and populates the current field with a value returned by the previous ExecuteSQL or LookupReturnValue action.

ClearLookupResults
Clears the results that are returned by the previous Lookup action.
CloseConnection
Closes an open connection to the Lookup database.
ExecuteSQL
Runs a SQL statement on the Lookup database. If a SELECT statement returns one or more values, these values are stored in an internal data record that you can access by using the PopulateWithResult action.
ExecuteSQLEx
Executes the SQL statement you enter in the first parameter.
OpenConnection
Uses a data source name or connection string to open a connection to a Lookup database.
PopulateWithResult
Populates the current field with a value returned by the previous ExecuteSQL or LookupReturnValue action. If the previous action returned multiple values, you can specify the value that you want to use.
SmartSQL
Runs a SQL statement that supports smart parameters.
SmartSQLEx
Executes the SQL statement you enter in the first parameter.

Parent topic: Global actions