...
Validation (Rich UI Only)
Please visit the Validation and Error Messages page.
Field Binding Dialog (Rich UI Only)
...
Choices database file - Enter the database file to use to populate 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.
...
This will produce an SQL statement like this:
| Code Block |
|---|
SELECT DISTINCT CNAME, CATID FROM CATEGP WHERE CNAME = ?
|
...
These are values returned from an auto-complete select box in a successful response from the external program:
| Code Block |
|---|
{
"success":true,
"response":[
new Option("Dishes and Cups","18"),
new Option("Soaps","14")
]
}
|
...
This example is JSON information returned when the script encounters an error with an database driven auto-complete.
| Code Block |
|---|
{
success:false,
"errorId":"-204",
"errorText":"CATEG in *LIBL type *FILE not found.",
"errorText2":"SQLPrepare()"
}
|
...