Outputting Reports to a Text File
You can output reports to an ASCII text file by including the clause TO FILE
filename in a SELECT command. The name you use must be a valid DOS filename
of up to eight characters. The three-character extension .TXT is automatically
added to the specified filename. The file is placed in the same sub-directory
on your hard disk where the Contract Collector system data files are located
(usually CW\DATA). Example:
SELECT CMP_ID, CMP_NAME FROM CMP TO FILE NAMES ORDER BY CMP_NAME
This command would create an ASCII text file named NAMES.TXT and place it in
your CW\DATA sub-directory. You can then open the file with a word processor and
format the data any way you want.
The results of a SELECT command can be appended to the contents of a text file
that already exists by including the word ADDITIVE directly after the name of
the file. Example:
SELECT ADDR1, ADDR2, ADDR3 FROM CMP TO FILE NAMES ADDITIVE ORDER BY ADDR3