$Table function allows you to use a list of value from a database table. There are two usages of the $Table function. The first uses the default connection. The second allows you to use a custom ODBC data source name. Both have the following parameters:
Optionally, three additional parameters are available:
1 - use JDBC driver name for Java edition of the engine.
2 - use connect string for Java edition of the engine.
* - the multiplatform edition of the pattern engine does not support 'where' clause. Please use $Query instead.
** - you should use 32 or 64 bit version of the administrator depend on application version.
Function returns NULL value for empty table
$Table(Orders,OrderID) uses values from 'OrderID' column in the 'Orders' table.
$Table(Orders,OrderID,1,OrderID>100) uses sequentially values greater 100 from 'OrderID' column in the 'Orders' table.
$Table(Orders,OrderID,,,MyDsn,Admin,Password) uses 'MyDsn' data source with user name 'Admin' and password 'Password'.