This method has been deprecated and should not be used in Profile versions v6.4 and above.
|
|
This method has been deprecated and should not be used in Profile versions v6.4 and above. |
Class: Db
Description
This method executes during the compilation of a PSL element. The method returns a literal string of data from a table (i.e., representing data items from a table). This literal string is then used in subsequent PSL command to retrieve data.
Syntax
Db.getList(String col,String table,String query,
String keyVal,Boolean pos)
Parameters
|
col |
A single column that must exist in the "table" schema definition. |
|
table |
The table name associated with the column in the col parameter. |
|
query |
An SQL-like query used to control data retrieved from the table. |
|
keyVal |
Variable(s) used in the query parameter at compile time. |
|
pos |
An option that indicates whether data is returned in an ordered list. |
Returns
A list of columns from a table.
When Became Available
v7.0
Example
s zlist = Db.getList("DI","DBTBL1D","FID=:ZID
AND NOD='BCHNUM'","ZID=""QUEUEB""",1)
type ResultSet rs = Db.select(ZLIST,"QUEUEB","BCHNUM=:BCHNUM")