SELECT

Applies to

Applies Does Not Apply
Setup DCO Runtime DCO

Verification panels that support this variable

Support this variable: Do not support this variable:

Datacap Desktop

Datacap Navigator

Datacap Web Client (VeriFine.aspx)

Datacap Web Client (aindex.aspx)

Description

Specifies a database lookup statement that converts an edit field in a verification panel into a drop-down list with values from a database. A list of matching entries from the database that is specified by the dns attribute is displayed. The selected entry is used to populate the fields that are specified in the flist attribute.

Example

This sample Lookup value retrieves a list of car types from the lookup database that is specified in the application configuration (.app) file. This sample then populates the list in the Car_Type field.
<SQL flist='Car_Type' dsn="*/lookupdb:cs">SELECT Car_Type FROM Car_Types</SQL>
Note that you can populate multiple fields simultaneously (see the Lookup variable for an example).

If you also configure the DICT variable, DICT variable values are displayed in the drop-down list at runtime in Datacap Navigator.