SET HEADING

From Recital Documentation Wiki
Revision as of 10:00, 16 April 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

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

AVERAGE, DISPLAY, LIST, SET DESCRIPTIONS, SET PAGELENGTH, SET PAGEWIDTH, SUM


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 DESCRIPTIONs, 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