FOOTING Modifier

FOOTING is an output modifier that defines a footing for the bottom of each page of a report.

Format

FOOTING "[text] ['options'] [text] ['options']..."

Parameter(s)

text

Text that appears in the footing.

options

Can be interspersed anywhere within the text in order to modify those parts of the text. They must be enclosed in single quotes.

B [n]

(Break) Inserts the value of the attribute causing a control break. It must be used in conjunction with the B option of the BREAK-ON modifier. n inserts the control-break value left-justified in a field of n blanks.

C

(Center) C centers text.

D

(Date) Inserts the current date in the format dd mmm yyyy.

F [n]

(File) Inserts the file name. n inserts the file name left-justified in a field of n blanks.

I [n]

(Item) Inserts the item-ID. n inserts the item-ID left-justified in a field of n blanks.

L

(Line-feed) Inserts a carriage return and a line-feed.

P [N]

(Page) Inserts the page number. N inserts the page number left-justified.

T

(Time) Inserts the current time and date in the format hh:mm:ss dd mmm yyyy. The time appears in 24-hour format.

''

Prints a single quote in the footing text.

Description

Text and options can appear in any order. FOOTING displays the information in the order specified. Spaces can be used anywhere in the footing text to make it more legible. The entire string of text and options must be enclosed in double quotes.

Example

This example produces a report from the BOOK-CATALOG file that includes a four-line footing, and incorporates the C, L, P, F, and I options:

>SORT BOOK-CATALOG BY PRICE TITLE PRICE HDR-SUPP ID-SUPP FOOTING "Current Titles and Prices'CL'========================================================='CLL'P AGE:'P'                                              FILE: 'F' ITEM:

'I'"

 

 

TITLE................................

PRICE.......................

 

 

DATABASE MANAGEMENT SYSTEMS

$9.00

OPERATING SYSTEM CONCEPTS

$20.00

WRITING COMMERCIAL APPLICATIONS

$20.00

WORD PROCESSING

$20.00

 

 

 

 

 

 

 

 

 

 

 

Current Titles and Prices

================================================================

 

 

PAGE: 1                          FILE: BOOK-CATALOG    ITEM: QR02

See Also

Using INFO/ACCESS Connectives, Modifiers and Options

Connectives

Relational Operators

Modifiers

Options

Connectives, Modifiers and Options Summary