IBM Datacap, Version 8.1

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:
DotEdit Taskmaster Web (VeriFine.aspx)	Taskmaster Web (aindex.aspx)

Support this variable:

Do not support this variable:

DotEdit

Taskmaster Web (VeriFine.aspx)

Taskmaster Web (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).

Feedback