6. Functions : Core Library Functions : StdList Function
 
Share this page                  
StdList Function
The StdList function is a 4GL procedure that builds and returns a ChoiceList of month names, weekday names, state names, or values from a column in a database table.
This function has the following syntax:
ChoiceList = StdList(Type  = 'type',   /* Type of list requested */
        TblName  = 'name',     /* Optional table name */
        ColName  = 'name')     /* Optional column name */
Arguments
Data Type
Description
Type
Varchar(65)
Specifies one of the following:
months—Specifies a list of month names (1–12, January to December)
weekdays—Specifies a list of weekday names (1–7, Sunday to Saturday)
states—Specifies a list of state names (1–50, Alabama to Wyoming)
query—Specifies a list of values from table TblName, column ColName
TblName
Varchar(65)
Parameter that contains the name of the table to be used when Type='query'
ColName
Varchar(65)
Parameter that contains the name of a column to be used when Type='query'
This function returns:
ChoiceList—the list of requested strings