DEFINEFILE

From CometWiki

Revision as of 09:07, 6 June 2009 by Badge (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

DEFINEFILE

Syntax: DEFINEFILE dictionary-file-name
Placement: Place the DEFINEFILE command before the REPORT command.
It can be useful when your PRINTER command directs your report's output to a data file and you wish to report on the data in that file.
This command was introduced in version 8.00.
Discussion: DEFINEFILE defines the file and all of its fields in your #CFILES dictionary. For example:

ERASE wrkfile,tmp
MARGIN 0,79
PRINTER wrkfile,tmp
DEFINEFILE my.work.file
INPUT customer
LINES 0
NOHEADINGS
SPACES 0
INDENT 0
REPORT
USING cust.to.hist
PRINT cust.number;cust.name;ar.activity;previous.ytd

When this report is run, a new file called wrkfile will be created in the TMP folder.
It will contain all the records generated by the report.
A new entry in the #CFILES Data Dictionary will be generated which describes that file.
Its Reporter name will be my.work.file.
The field names will be the same as the ones in the original files.

Personal tools