Difference between revisions of "SET HEADING"
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (7 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Determine the display of column titles above the output of certain commands | Determine the display of column titles above the output of certain commands | ||
| Line 12: | Line 5: | ||
==Syntax== | ==Syntax== | ||
SET HEADING ON | OFF | (<expL>) | SET HEADING ON | OFF | (<expL>) | ||
| + | |||
SET HEADING TO SINGLE | DOUBLE | NONE | SET HEADING TO SINGLE | DOUBLE | NONE | ||
==See Also== | ==See Also== | ||
| − | SET DESCRIPTIONS, | + | [[AVERAGE]], [[DISPLAY]], [[LIST]], [[SET DESCRIPTIONS]], [[SET PAGELENGTH]], [[SET PAGEWIDTH]], [[SUM]] |
| Line 22: | Line 16: | ||
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. | 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 | + | 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== | ==Example== | ||
| − | < | + | <code lang="recital"> |
use patrons index events | use patrons index events | ||
list first 2 event, name off | list first 2 event, name off | ||
| Line 32: | Line 26: | ||
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 44: | Line 38: | ||
use demo | use demo | ||
list fields acc_prefix, acc_no, ord_value, name; | list fields acc_prefix, acc_no, ord_value, name; | ||
| − | to file accounts.txt; | + | to file accounts.txt; |
| − | for ord_date = ("01/05/2000")</ | + | for ord_date = ("01/05/2000")</code> |
| − | + | ||
| − | + | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
| − | [[Category:Set_Commands]] | + | [[Category:Set_Commands|HEADING]] |
| + | [[Category:Input Output]] | ||
| + | [[Category:Input Output Set Commands]] | ||
Latest revision as of 15:57, 23 November 2009
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 Server, Recital
