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
...
|