MakeList
This command returns a dynamic array string containing the results of a SQL statement that was executed on the server from a mobile device. For this command to be successful the server must be in wireless range for a connection to be established.
Group: Server Extensions
Syntax: [bOK =] Server.MakeList(sSQL, sList, [bRtnAllCols], [bNormalize])
bOK (Boolean) Optional – is a return value; a value of True means the SQL statement processed normally.
sSQL (String) is the SQL 'SELECT' statement to be sent to the database.
sList (String) is the list to be returned for display (i.e., set RSP = Value to display the list on the Client device.)
bRtnAllCols (Boolean) Optional – when set to True will return all the columns as the potential key, not just the first column. Default is False.
bNormalize (Boolean) Optional – when set to True will trim the spaces from the data so that it will display consistently. Default is False.
Example:
Dim sSQL As String
Dim sMyList As String
sSQL = "select PartNo from ItemMaster"
sMyList = Server.MakeList(sSQL, True, True)
Rsp = App.ShowList(sMyList)
Or
Rsp = App.ShowList(Server.MakeList(sSQL, True, True))