Gets value list from Query.
Syntax 1
|
Gets value list from Query. |
|
QueryToList(queryName, valueColumnName, displayColumnName) |
|
Arguments: |
|
|
queryName |
DataElement - The SQL Query to use. |
|
|
valueColumnName |
String - Name of the value column. |
|
|
displayColumnName |
String - Name of the display column. |
Syntax 2
|
Gets value list from Query. |
|
QueryToList(queryName, valueColumnName, displayColumnName, passThruArgs) |
|
Arguments: |
|
|
queryName |
DataElement - The SQL Query to use. |
|
|
valueColumnName |
String - Name of the value column. |
|
|
displayColumnName |
String - Name of the display column. |
|
|
passThruArgs |
Expression - One or more passThru expressions. |
Remarks
- Example: QueryToList(AQueryValueList, "ID", "Descr") returns value-list:{{1, "a"}, {2, "b"}, {3, "c"}}.
Comments
0 comments
Article is closed for comments.