Appendix A: OpenList Keyword Reference
This chapter contains reference information for keywords used in OpenList, OpenInsight's retrieval and reporting language.
OpenList commands include options to find a subset of rows in a table (filtering), to arrange returned rows into a particular order, and to choose particular columns to include in output. OpenList also offers various options to control line spacing, inclusion and suppression of titles, printer output, and the generation of BASIC+ source code. Most importantly, you can include keywords with OpenList commands to filter the data used in the OpenList operation. If you are using OpenList from the System Editor command line, the entire OpenList statement is enclosed in quotes and follows the Run command and the RList stored procedure, as in the following example:
Run RList "Select CAR_ORDERS With SUPP_NO < '3' "
For additional information on OpenList, refer to RList routine.
Note
The key column (@ID) of a table is always displayed in a report unless you use the format modifier keyword ID-SUPP.
If the sum of the length of all the display columns in the report is wider than the screen, the View window will allow you to pan to see the text that isn't visible. If you have disabled the View window, the text will wrap. On a printer, text that's too wide for the page will wrap. Screen and printer width is set using the commands SET-CRT and SET-LPTR.
Override Keywords
If specified, these keywords will override the display specifications for a column (as defined in the dictionary). The format override keywords are:
| Format Override Keyword | Description |
|---|---|
| JustLen | Override the justification and display length of a column. |
| OConv | Override the conversion (output format) of a column. |
| ColHead | Specify a new column heading for a column. |
Each of these keywords is documented later in this chapter.
Format Keywords
A keyword in format adds formatting features to a report or form. Possible keywords are:
| Format Keyword | Description |
|---|---|
| Footing | Display text at the bottom of each page of the report. |
| Heading | Display text at the top of each page of the report. |
| Grand-Total | Specify text that accompanies a grand total. |
| Modifier | Use a value for modifier to alter the default format or output specifications. Format modifier keywords are discussed in detail under the following topic, "Format modifier keywords." |
| Options | The additional display or output options that you may include vary according to the command specified. For example, the option "(P)" sends output to a printer. |
OpenList Command Format
OpenList Format Modifier Keywords
OpenList Format Override Keywords
OpenList Keywords
The rest of this chapter is an alphabetical listing of the keywords used in OpenList commands. Each keyword entry includes a description, a diagram of the proper syntax for the keyword, and examples of the correct use of the word.