TableLookupEx(QueryName, DataTableName[, 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. |
DataTableName
|
Optional. The name of the returned ADO.NET data table. The default is “TableLookup”. |
| 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 an ADO.NET data table object that is filled
with columns and rows from the query.
TableLookupEx example
Used for
Dim rv As DataTable = TableLookupEx("MyCustomQueryCode", arg1, arg2, arg3...)
or
Dim argArray as Object = array(arg1, arg2, arg3)
Dim rv As DataTable = TableLookupEx("MyCustomQueryCode", argArray)