TableLookup(QueryName[, paramN])
Executes an SQL Query with the supplied parameters. This function is available to all scripts (workflows, copy methods, equations). It is not only for analysis equations.
Arguments
| Parameter | Description |
|---|---|
QueryName |
Name of the query in
FSQUERY to be executed. |
| param | Optional. The parameters can be in the form of an array or a comma-delimited string of the individual arguments of the query. |
Return Value
Returns the value from the first row and column of an array.
TableLookup example
Used for
Dim rv As Object = TableLookup("MyCustomQueryCode", arg1, arg2, arg3...)
or
Dim argArray As Object = array(arg1, arg2, arg3)
Dim rv As Object = TableLookup("MyCustomQueryCode", argArray)