Small company logo:
   History
 
Advertising banner:
 
 Statement.MakeList
Home • Help • Customization Tools • FCAS • Language Reference • Statement.MakeList
 
Purpose
Creates a list suitable for use as a static or editable List attribute from a column in a database.
The MakeList statement method generates a list of all the items contained in the statement by concatenating the results and separating the list with semicolons.
Syntax
DBStatement.MakeList (StringColumn [, NumericColumn])


StringColumn
The text name of the column of data to be used to generate the list content.
NumericColumn
Adds numeric values to the items in the list.

Example
...
Dim stmt As DBStatement
stmt.OpenStatement (MyConnection)
stmt.ExecuteSQL ("SELECT NAME ID FROM NAMES WHERE ID < 40")
1stNames.List=stmt.MakeList ("NAME", "ID")
stmt.CloseStatement
...