Creating a dictionary of valid car types

The Datacap Desktop and Datacap Web Client verification interfaces enable the population of a drop-down list directly from the database by using an SQL statement that is embedded in the SELECT variable of the field. You need to create the variable in Datacap Studio by first unlocking the document hierarchy, right-clicking the Car_Type field, and choosing Manage Variables. You can then add the SELECT variable and set it to the following value.

<SQL flist='Car_Type' dsn="*/lookupdb:cs">SELECT Car_Type FROM Car_Types</SQL>

An SQL query (SELECT <column> FROM <table>) gets the list of valid car types from the application's lookup database (dsn="*/lookupdb:cs"). It then creates a drop-down list in the specified field (flist='<field>') that contains the returned values.

Another variable, Lookup, is functionally similar, except that it displays the list of available choices in a window instead of a drop-down list.

To create a selection list that works for all verification interfaces, you can create a dictionary that contains the same valid car types (Compact, Standard, Full size, SUV, and Other). You can then attach the library to the Car_Type field.