List_Dict routine [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== List_Dict routine    ======


 
==== 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 ====
 
[[create_index|Create_Index]]
 
==== Example ====
 
<code>
run List_Dict "CAR_PARTS"
 
**
**
</code>