Difference between revisions of "SET HEADING"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) (→Example) |
||
| Line 32: | Line 32: | ||
event name | event name | ||
------ ------ | ------ ------ | ||
| − | BALLET | + | BALLET Webber |
| − | BALLET | + | BALLET Collins |
set heading off | set heading off | ||
list first 2 event, name off | list first 2 event, name off | ||
| − | BALLET | + | BALLET Webber |
| − | BALLET | + | BALLET Collins |
set pagelength to 60 | set pagelength to 60 | ||
| Line 46: | Line 46: | ||
to file accounts.txt; | to file accounts.txt; | ||
for ord_date = ("01/05/2000")</pre> | for ord_date = ("01/05/2000")</pre> | ||
| − | |||
| − | |||
==Products== | ==Products== | ||
Revision as of 15:59, 10 March 2009
Contents
SET HEADING
Class
Input/Output
Purpose
Determine the display of column titles above the output of certain commands
Syntax
SET HEADING ON | OFF | (<expL>) SET HEADING TO SINGLE | DOUBLE | NONE
See Also
SET DESCRIPTIONS, LIST, DISPLAY, SUM, AVERAGE
Description
If SET HEADING is ON, then column titles will be displayed for the DISPLAY, LIST, SUM and AVERAGE commands. If SET HEADING is OFF, then no column titles will be displayed. If SET DESCRIPTIONS is ON, then the field description is displayed as the column title in place of the field name. By default, HEADING is ON.
The SET HEADING TO command controls the underlining of column headings in output files. The SINGLE or DOUBLE options will generate SINGLE or DOUBLE underlining on column headings. If NONE is specified then no underlining is generated for the column headings. When used in conjunction with the LIST | DISPLAY ... TO FILE, SET DESCRIPTION, SET PAGEWIDTH and SET PAGELENGTH commands, SET HEADING provides the ability to produce ad-hoc reports. The default for SET HEADING is NONE.
Example
use patrons index events
list first 2 event, name off
event name
------ ------
BALLET Webber
BALLET Collins
set heading off
list first 2 event, name off
BALLET Webber
BALLET Collins
set pagelength to 60
set heading to single
use demo
list fields acc_prefix, acc_no, ord_value, name;
to file accounts.txt;
for ord_date = ("01/05/2000")
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
