Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

2. Database-Driven Auto-Complete - See Database-Driven Auto-Complete section below.

Database-Driven

...

Selection

This section allows choices/choice values to be retrieved from a database file. Image Removed Image Removed

Image Added
 
Choices database file - Enter the database file to use to populate your options/values. When setting your database file it's not required to qualify with library name, although you can. if the library is omitted, the application job's library list will be used.

Choice options field - Select the field (s) you wish to use to search. If there are multiple fields specified in the choice options field this will allow you to return multiple values in the auto-complete search. However, only the first value in the field will be used to search, any other selected fields are for display only as additional columns.

Choice values field - Select the field to return a value to your application.

In the example, records will be loaded from file CATEGP. The records options will be searched on populated by field CNAME and CATID, with field CATID displaying in a second column (see below). The value in field CATID in the selected record will be returned to the program.