Description
Returns the column definitions for a specified dictionary.
Syntax
List_Dict (tablename, returncolumnlist, sortlist, booleanflaglist)
Parameters
The List_Dict routine has the following parameters.
| Parameter | Description |
|---|---|
| tablename | Specifies the name of the dictionary table for which to return information. |
| Returncolumnlist | Specifies a column or list of columns to return. The column COLUMN_NAME is returned by default. Available column names in the SYSDICT table are: COLUMN_NAME (default) COLUMN_TYPE COLUMN_POS COLUMN_JUST COLUMN_DISPLAY_LEN COLUMN_DATA_TYPE COLUMN_FOREIGN_TYPE COLUMN_FOREIGN_NAME COLUMN_MASTER Dictionary control columns (column names preceded by %) are not included. See booleanflaglist. |
| sortlist | Specifies a column name or list of column names to sort by. By default, no sorting takes place. |
| booleanflaglist | If true (1), then control columns (column names preceded by %) are returned. |
See also
Example
run List_Dict "CAR_PARTS"
