Static lists are based on a comma-separated list of choices.
A dynamic list is based on the evaluation of an expression from a specified table.
Here the list is based on the current values of the lastname field from the employees table.
SQL Select List
A SQL Select list is generated by the resultset from a SQL Select statement.
Here the list is based on the ordered current values of the lastname field from the employees table.
Choices: select lastname from employees order by lastname
Note: to display a blank value at the top of the choice list, prefix the SQL Select statement with a ‘+’.
Choices: +select lastname from employees order by lastname
User Defined Function
The list can be based on the return value from a user defined function or procedure (Lianja/VFP scripting).
The return value should be a comma-separated list. Here the list is based on the return value from the ‘getempname’ procedure defined in the App’s custom library.
As in the other examples, it returns the lastname field values from the employees table.
proc getempname() sqlvalues("select lastname from employees order by lastname") creturn = astring(_sqlvalues) return creturn endproc