History  | 
MakeList (database statements) 
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 
... 
 | ||||||