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