Home » Archimedes archive » Archimedes World » AW-1994-04-Disc2.adf » Disk2Apr94 » !AWApr94/Goodies/PowerBase/PBaseDoc/ScriptFile
!AWApr94/Goodies/PowerBase/PBaseDoc/ScriptFile
This website contains an archive of files for the Acorn Electron, BBC Micro, Acorn Archimedes, Commodore 16 and Commodore 64 computers, which Dominic Ford has rescued from his private collection of floppy disks and cassettes.
Some of these files were originally commercial releases in the 1980s and 1990s, but they are now widely available online. I assume that copyright over them is no longer being asserted. If you own the copyright and would like files to be removed, please contact me.
| Tape/disk: | Home » Archimedes archive » Archimedes World » AW-1994-04-Disc2.adf » Disk2Apr94 |
| Filename: | !AWApr94/Goodies/PowerBase/PBaseDoc/ScriptFile |
| Read OK: | ✔ |
| File size: | 220B bytes |
| Load address: | 0000 |
| Exec address: | 0000 |
File contents
Script Files
============
Powerbase incorporates a SCRIPT LANGUAGE which enables you to control some
of its features from a SCRIPT FILE. Using script files you can automate jobs
which need to be done frequently. Print jobs are the most obvious example,
and most of the script commands have to do with printing, but there are
others.
Script files are plain text files (created with !Edit) and are executed by
simply dragging them onto the main Powerbase window. All the commands in a
script file must be in upper-case letters, preceded by '!', and may be
followed by a parameter string, separated from the command by a single
space. Here is a full list of the commands followed by a description of
their functions:-
!SCRIPT POWERBASE,END,<filename>
!COMMENT
!SELECTION <filename>
!PRINTOPTS <filename>
!QUERY <search formula>
!EXPAND ON,OFF
!DATE ON,OFF
!UPPER ON,OFF
!UNDERLINE ON/OFF
!CASE ON/OFF
!INDEX ON/OFF
!FIRST ON/OFF
!SHRINK ON/OFF
!HEADINGS D,T
!PITCH 5,10,12,17
!TITLE <title>
!PAGE 70,66 etc
!LINESPACE 1,2 etc
!LMARGIN 1,5,10 etc
!TMARGIN 1,5,10 etc
!SPACER <spacer string>
!COLWIDTH 3,5,10 etc
!FORMAT HORIZONTAL,VERTICAL,LABEL,TABLExx
!DESTINATION WINDOW,FILE,PRINTER
!LABEL n,h,v,l,r,ON/OFF,ON/OFF
!DELETE <primary key>
!INSERT (followed by fields, each, inc. 1st, on its own line)
!IMPRESSION <'Impression' DDF string> [Not first]
!SCRIPT
=======
All script files must begin with the line !SCRIPT POWERBASE. This is how the
program distinguishes a Powerbase script from other text files. You should
make !SCRIPT END the last line of the file. Finally, the command can be used
to "chain" another script file by following it with the name of the new
file, i.e. by using the form !SCRIPT <filename>.
!COMMENT
========
Use to insert explanatory comments in a script file. The rest of the line
after the command is ignored.
!SELECTION <filename>
=====================
The parameter should be the name of a selection file in the PrintRes
directory. The command will install the selection just as though you had
dragged it from PrintRes to the Powerbase window yourself. If you issue the
command without a parameter the current selection will be cleared.
!PRINTOPTS <filename>
=====================
The parameter should be the name of a print options file in the PrintRes
directory. The options will be set just as if the the file had been dragged
from PrintRes to the Powerbase window. Issued without a parameter causes
the default options to be set.
!QUERY <search formula>
=======================
This command is used to print a list. It gives the same result as typing the
search formula into the Match window and clicking OK.
!EXPAND
=======
Like many of the commands which follow, this is used to select or deselect a
button in the print options window . !EXPAND ON selects the button which
causes fields to be expanded by reference to a linked validation table.
!EXPAND OFF (or just !EXPAND by itself) deselects the button.
!DATE
=====
Turns date and time stamping ON and OFF. It works in exactly the same way as
!EXPAND.
!UPPER
======
Forces upper-case printing when followed by ON, normal upper/lower case
printing otherwise.
!UNDERLINE
==========
Turns underlining ON and OFF when output is sent to the printer. You will not
see any underlining when the report is displayed in a window by Powerbase,
but underlining will occur when the windowed output is subsequently printed.
!CASE
=====
Turns the 'Case specific' button in the Match window ON and OFF.
!INDEX
======
Turns the 'Use index' button in the Match window ON and OFF.
!FIRST
======
Followed by ON this causes any header information, such as date-stamp or
title, to appear on the first page only of a report. When OFF the header is
printed on every page.
!SHRINK
=======
Followed by ON this removes surplus "white space" between the columns of
reports in Vertical format.
!HEADINGS D
===========
Causes descriptors to be used as field identifiers in a report. !HEADINGS T,
or without any parameter, causes tags to be used.
!PITCH <cpi>
============
The parameter should be 5, 10, 12 or 17, representing double-width, pica,
elite and condensed respectively.
!TITLE
======
Followed by a text string causes the string to be used as a title on
subsequently printed reports.
!PAGE <lines>
=============
Use to set the page length for reports. 70 is correct for A4, 66 for
American letter.
!LINESPACE <n>
==============
Sets the line-spacing to n lines. The default is 1, i.e. no blank lines
between lines of report.
!LMARGIN <n>
============
Sets the left margin to n character spaces
!TMARGIN <n>
============
Sets the top margin to n lines
!SPACER <string>
================
Specifies the string to be used to separate columns of printed data in
reports using 'Horizontal' or 'Table' format.
!COLWIDTH <n>
=============
Sets the width of the blank columns used in 'Table' format to n spaces.
!FORMAT
=======
Follow this command with HORIZONTAL, VERTICAL, LABEL or TABLE. In the last
case the number of columns required must be appended as a second parameter,
e.g. TABLE 8. If any other parameter is used, or !FORMAT is issued by
itself, the HORIZONTAL format is used.
!DESTINATION
============
Should be followed with WINDOW or FILE or PRINTER. The first causes reports
to be displayed in a window, from which they may be subsequently saved. FILE
causes output to be sent to a text file specified by the user. PRINTER
causes output to go directly to the printer without being previously
displayed or saved.
!LABEL
======
This is used to define a label specification to use with the LABEL format.
It requires 7 parameters, separated by commas:
(1) The number of labels across the page (1,2 or 3)
(2) The horizontal label pitch (i.e. left edge to left edge) in inches.
This is only meaningful when (1) is 2 or 3.
(3) The vertical label pitch in inches.
(4) The number of lines to be printed on each label.
(5) The line which is to be replaced, if blank, by the last field in
the selection. If nothing is entered here (2 commas together) then
no substitution is performed.
(6) If ON is entered the the primary key will appear on the label (in
brackets) as an identifier.
(7) If ON is entered blank fields will be skipped when printing.
!DELETE <key>
=============
This provides a way of deleting records from the database. The parameter
must be the primary key of the record. The benefits of this command may not
be at all obvious. Suppose you have a text file giving details of records
which must be deleted from the database. If such a job is going to occur at
all often it could be worthwhile to write a customised program to read the
text file and generate the primary key of each record, then output the
results as a Powerbase script file. The whole batch of records can then be
deleted by simply dragging the script into Powerbase. Not worthwhile for ten
records, perhaps, but could be for a hundred. Note that all 6 subfiles will
be searched for the records to be deleted.
!INSERT
=======
This is the counterpart of !DELETE and is useful in similar circumstances.
In this case the command must occupy a line by itself and be followed by the
record to insert, one field to a line. It is the user's responsibility to
ensure that the lines are not too long for the database fields into which
they are placed and that the number of lines following each !INSERT is the
same as the number of fields in the record. Don't forget to leave blank
lines for empty fields!
!IMPRESSION
===========
Used in conjunction with !QUERY to generate a report in text-file format,
this allows you to insert 'Impression' formatting commands at the start of
the text-file. A script may, for example, execute a series of !QUERY
commands and the resulting files are to be all selected together and dragged
into an 'Impression' document. To make each file go into a new frame you
need to make each begin with {nextframe}. This can be achieved by placing
the script command !IMPRESSION {nextframe} before the first !QUERY. You do
not, however, want {nextframe} to begin the first file created, or the
'Impression' document will have a blank frame on its first page. To suppress
the effect on the first file use the form: !IMPRESSION {nextframe} Not
first. There must be a space between the '}' and the 'N', but the 'Not
first' string isn't case sensitive.
00000000 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
*
00000020 53 63 72 69 70 74 20 46 69 6c 65 73 0a 20 20 20 |Script Files. |
00000030 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
00000040 20 20 20 20 20 20 20 20 20 20 20 20 20 3d 3d 3d | ===|
00000050 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 0a 50 6f 77 65 72 |=========..Power|
00000060 62 61 73 65 20 69 6e 63 6f 72 70 6f 72 61 74 65 |base incorporate|
00000070 73 20 61 20 53 43 52 49 50 54 20 4c 41 4e 47 55 |s a SCRIPT LANGU|
00000080 41 47 45 20 77 68 69 63 68 20 65 6e 61 62 6c 65 |AGE which enable|
00000090 73 20 79 6f 75 20 74 6f 20 63 6f 6e 74 72 6f 6c |s you to control|
000000a0 20 73 6f 6d 65 0a 6f 66 20 69 74 73 20 66 65 61 | some.of its fea|
000000b0 74 75 72 65 73 20 66 72 6f 6d 20 61 20 53 43 52 |tures from a SCR|
000000c0 49 50 54 20 46 49 4c 45 2e 20 55 73 69 6e 67 20 |IPT FILE. Using |
000000d0 73 63 72 69 70 74 20 66 69 6c 65 73 20 79 6f 75 |script files you|
000000e0 20 63 61 6e 20 61 75 74 6f 6d 61 74 65 20 6a 6f | can automate jo|
000000f0 62 73 0a 77 68 69 63 68 20 6e 65 65 64 20 74 6f |bs.which need to|
00000100 20 62 65 20 64 6f 6e 65 20 66 72 65 71 75 65 6e | be done frequen|
00000110 74 6c 79 2e 20 50 72 69 6e 74 20 6a 6f 62 73 20 |tly. Print jobs |
00000120 61 72 65 20 74 68 65 20 6d 6f 73 74 20 6f 62 76 |are the most obv|
00000130 69 6f 75 73 20 65 78 61 6d 70 6c 65 2c 0a 61 6e |ious example,.an|
00000140 64 20 6d 6f 73 74 20 6f 66 20 74 68 65 20 73 63 |d most of the sc|
00000150 72 69 70 74 20 63 6f 6d 6d 61 6e 64 73 20 68 61 |ript commands ha|
00000160 76 65 20 74 6f 20 64 6f 20 77 69 74 68 20 70 72 |ve to do with pr|
00000170 69 6e 74 69 6e 67 2c 20 62 75 74 20 74 68 65 72 |inting, but ther|
00000180 65 20 61 72 65 0a 6f 74 68 65 72 73 2e 0a 0a 53 |e are.others...S|
00000190 63 72 69 70 74 20 66 69 6c 65 73 20 61 72 65 20 |cript files are |
000001a0 70 6c 61 69 6e 20 74 65 78 74 20 66 69 6c 65 73 |plain text files|
000001b0 20 28 63 72 65 61 74 65 64 20 77 69 74 68 20 21 | (created with !|
000001c0 45 64 69 74 29 20 61 6e 64 20 61 72 65 20 65 78 |Edit) and are ex|
000001d0 65 63 75 74 65 64 20 62 79 0a 73 69 6d 70 6c 79 |ecuted by.simply|
000001e0 20 64 72 61 67 67 69 6e 67 20 74 68 65 6d 20 6f | dragging them o|
000001f0 6e 74 6f 20 74 68 65 20 6d 61 69 6e 20 50 6f 77 |nto the main Pow|
00000200 65 72 62 61 73 65 20 77 69 6e 64 6f 77 2e 20 41 |erbase window. A|
00000210 6c 6c 20 74 68 65 20 63 6f 6d 6d 61 6e 64 73 20 |ll the commands |
00000220 69 6e 20 61 0a 73 63 72 69 70 74 20 66 69 6c 65 |in a.script file|
00000230 20 6d 75 73 74 20 62 65 20 69 6e 20 75 70 70 65 | must be in uppe|
00000240 72 2d 63 61 73 65 20 6c 65 74 74 65 72 73 2c 20 |r-case letters, |
00000250 70 72 65 63 65 64 65 64 20 62 79 20 27 21 27 2c |preceded by '!',|
00000260 20 61 6e 64 20 6d 61 79 20 62 65 0a 66 6f 6c 6c | and may be.foll|
00000270 6f 77 65 64 20 62 79 20 61 20 70 61 72 61 6d 65 |owed by a parame|
00000280 74 65 72 20 73 74 72 69 6e 67 2c 20 73 65 70 61 |ter string, sepa|
00000290 72 61 74 65 64 20 66 72 6f 6d 20 74 68 65 20 63 |rated from the c|
000002a0 6f 6d 6d 61 6e 64 20 62 79 20 61 20 73 69 6e 67 |ommand by a sing|
000002b0 6c 65 0a 73 70 61 63 65 2e 20 48 65 72 65 20 69 |le.space. Here i|
000002c0 73 20 61 20 66 75 6c 6c 20 6c 69 73 74 20 6f 66 |s a full list of|
000002d0 20 74 68 65 20 63 6f 6d 6d 61 6e 64 73 20 66 6f | the commands fo|
000002e0 6c 6c 6f 77 65 64 20 62 79 20 61 20 64 65 73 63 |llowed by a desc|
000002f0 72 69 70 74 69 6f 6e 20 6f 66 0a 74 68 65 69 72 |ription of.their|
00000300 20 66 75 6e 63 74 69 6f 6e 73 3a 2d 0a 0a 20 20 | functions:-.. |
00000310 20 20 20 20 20 20 21 53 43 52 49 50 54 20 50 4f | !SCRIPT PO|
00000320 57 45 52 42 41 53 45 2c 45 4e 44 2c 3c 66 69 6c |WERBASE,END,<fil|
00000330 65 6e 61 6d 65 3e 0a 20 20 20 20 20 20 20 20 21 |ename>. !|
00000340 43 4f 4d 4d 45 4e 54 0a 20 20 20 20 20 20 20 20 |COMMENT. |
00000350 21 53 45 4c 45 43 54 49 4f 4e 20 3c 66 69 6c 65 |!SELECTION <file|
00000360 6e 61 6d 65 3e 0a 20 20 20 20 20 20 20 20 21 50 |name>. !P|
00000370 52 49 4e 54 4f 50 54 53 20 3c 66 69 6c 65 6e 61 |RINTOPTS <filena|
00000380 6d 65 3e 0a 20 20 20 20 20 20 20 20 21 51 55 45 |me>. !QUE|
00000390 52 59 20 3c 73 65 61 72 63 68 20 66 6f 72 6d 75 |RY <search formu|
000003a0 6c 61 3e 0a 20 20 20 20 20 20 20 20 21 45 58 50 |la>. !EXP|
000003b0 41 4e 44 20 4f 4e 2c 4f 46 46 0a 20 20 20 20 20 |AND ON,OFF. |
000003c0 20 20 20 21 44 41 54 45 20 4f 4e 2c 4f 46 46 0a | !DATE ON,OFF.|
000003d0 20 20 20 20 20 20 20 20 21 55 50 50 45 52 20 4f | !UPPER O|
000003e0 4e 2c 4f 46 46 0a 20 20 20 20 20 20 20 20 21 55 |N,OFF. !U|
000003f0 4e 44 45 52 4c 49 4e 45 20 4f 4e 2f 4f 46 46 0a |NDERLINE ON/OFF.|
00000400 20 20 20 20 20 20 20 20 21 43 41 53 45 20 4f 4e | !CASE ON|
00000410 2f 4f 46 46 0a 20 20 20 20 20 20 20 20 21 49 4e |/OFF. !IN|
00000420 44 45 58 20 4f 4e 2f 4f 46 46 0a 20 20 20 20 20 |DEX ON/OFF. |
00000430 20 20 20 21 46 49 52 53 54 20 4f 4e 2f 4f 46 46 | !FIRST ON/OFF|
00000440 0a 20 20 20 20 20 20 20 20 21 53 48 52 49 4e 4b |. !SHRINK|
00000450 20 4f 4e 2f 4f 46 46 0a 20 20 20 20 20 20 20 20 | ON/OFF. |
00000460 21 48 45 41 44 49 4e 47 53 20 44 2c 54 0a 20 20 |!HEADINGS D,T. |
00000470 20 20 20 20 20 20 21 50 49 54 43 48 20 35 2c 31 | !PITCH 5,1|
00000480 30 2c 31 32 2c 31 37 0a 20 20 20 20 20 20 20 20 |0,12,17. |
00000490 21 54 49 54 4c 45 20 3c 74 69 74 6c 65 3e 0a 20 |!TITLE <title>. |
000004a0 20 20 20 20 20 20 20 21 50 41 47 45 20 37 30 2c | !PAGE 70,|
000004b0 36 36 20 65 74 63 0a 20 20 20 20 20 20 20 20 21 |66 etc. !|
000004c0 4c 49 4e 45 53 50 41 43 45 20 31 2c 32 20 65 74 |LINESPACE 1,2 et|
000004d0 63 0a 20 20 20 20 20 20 20 20 21 4c 4d 41 52 47 |c. !LMARG|
000004e0 49 4e 20 31 2c 35 2c 31 30 20 65 74 63 0a 20 20 |IN 1,5,10 etc. |
000004f0 20 20 20 20 20 20 21 54 4d 41 52 47 49 4e 20 31 | !TMARGIN 1|
00000500 2c 35 2c 31 30 20 65 74 63 0a 20 20 20 20 20 20 |,5,10 etc. |
00000510 20 20 21 53 50 41 43 45 52 20 3c 73 70 61 63 65 | !SPACER <space|
00000520 72 20 73 74 72 69 6e 67 3e 0a 20 20 20 20 20 20 |r string>. |
00000530 20 20 21 43 4f 4c 57 49 44 54 48 20 33 2c 35 2c | !COLWIDTH 3,5,|
00000540 31 30 20 65 74 63 0a 20 20 20 20 20 20 20 20 21 |10 etc. !|
00000550 46 4f 52 4d 41 54 20 48 4f 52 49 5a 4f 4e 54 41 |FORMAT HORIZONTA|
00000560 4c 2c 56 45 52 54 49 43 41 4c 2c 4c 41 42 45 4c |L,VERTICAL,LABEL|
00000570 2c 54 41 42 4c 45 78 78 0a 20 20 20 20 20 20 20 |,TABLExx. |
00000580 20 21 44 45 53 54 49 4e 41 54 49 4f 4e 20 57 49 | !DESTINATION WI|
00000590 4e 44 4f 57 2c 46 49 4c 45 2c 50 52 49 4e 54 45 |NDOW,FILE,PRINTE|
000005a0 52 0a 20 20 20 20 20 20 20 20 21 4c 41 42 45 4c |R. !LABEL|
000005b0 20 6e 2c 68 2c 76 2c 6c 2c 72 2c 4f 4e 2f 4f 46 | n,h,v,l,r,ON/OF|
000005c0 46 2c 4f 4e 2f 4f 46 46 0a 20 20 20 20 20 20 20 |F,ON/OFF. |
000005d0 20 21 44 45 4c 45 54 45 20 3c 70 72 69 6d 61 72 | !DELETE <primar|
000005e0 79 20 6b 65 79 3e 0a 20 20 20 20 20 20 20 20 21 |y key>. !|
000005f0 49 4e 53 45 52 54 20 28 66 6f 6c 6c 6f 77 65 64 |INSERT (followed|
00000600 20 62 79 20 66 69 65 6c 64 73 2c 20 65 61 63 68 | by fields, each|
00000610 2c 20 69 6e 63 2e 20 31 73 74 2c 20 6f 6e 20 69 |, inc. 1st, on i|
00000620 74 73 20 6f 77 6e 20 6c 69 6e 65 29 0a 20 20 20 |ts own line). |
00000630 20 20 20 20 20 21 49 4d 50 52 45 53 53 49 4f 4e | !IMPRESSION|
00000640 20 3c 27 49 6d 70 72 65 73 73 69 6f 6e 27 20 44 | <'Impression' D|
00000650 44 46 20 73 74 72 69 6e 67 3e 20 5b 4e 6f 74 20 |DF string> [Not |
00000660 66 69 72 73 74 5d 0a 0a 21 53 43 52 49 50 54 0a |first]..!SCRIPT.|
00000670 3d 3d 3d 3d 3d 3d 3d 0a 41 6c 6c 20 73 63 72 69 |=======.All scri|
00000680 70 74 20 66 69 6c 65 73 20 6d 75 73 74 20 62 65 |pt files must be|
00000690 67 69 6e 20 77 69 74 68 20 74 68 65 20 6c 69 6e |gin with the lin|
000006a0 65 20 21 53 43 52 49 50 54 20 50 4f 57 45 52 42 |e !SCRIPT POWERB|
000006b0 41 53 45 2e 20 54 68 69 73 20 69 73 20 68 6f 77 |ASE. This is how|
000006c0 20 74 68 65 0a 70 72 6f 67 72 61 6d 20 64 69 73 | the.program dis|
000006d0 74 69 6e 67 75 69 73 68 65 73 20 61 20 50 6f 77 |tinguishes a Pow|
000006e0 65 72 62 61 73 65 20 73 63 72 69 70 74 20 66 72 |erbase script fr|
000006f0 6f 6d 20 6f 74 68 65 72 20 74 65 78 74 20 66 69 |om other text fi|
00000700 6c 65 73 2e 20 59 6f 75 20 73 68 6f 75 6c 64 0a |les. You should.|
00000710 6d 61 6b 65 20 21 53 43 52 49 50 54 20 45 4e 44 |make !SCRIPT END|
00000720 20 74 68 65 20 6c 61 73 74 20 6c 69 6e 65 20 6f | the last line o|
00000730 66 20 74 68 65 20 66 69 6c 65 2e 20 46 69 6e 61 |f the file. Fina|
00000740 6c 6c 79 2c 20 74 68 65 20 63 6f 6d 6d 61 6e 64 |lly, the command|
00000750 20 63 61 6e 20 62 65 20 75 73 65 64 0a 74 6f 20 | can be used.to |
00000760 22 63 68 61 69 6e 22 20 61 6e 6f 74 68 65 72 20 |"chain" another |
00000770 73 63 72 69 70 74 20 66 69 6c 65 20 62 79 20 66 |script file by f|
00000780 6f 6c 6c 6f 77 69 6e 67 20 69 74 20 77 69 74 68 |ollowing it with|
00000790 20 74 68 65 20 6e 61 6d 65 20 6f 66 20 74 68 65 | the name of the|
000007a0 20 6e 65 77 0a 66 69 6c 65 2c 20 69 2e 65 2e 20 | new.file, i.e. |
000007b0 62 79 20 75 73 69 6e 67 20 74 68 65 20 66 6f 72 |by using the for|
000007c0 6d 20 21 53 43 52 49 50 54 20 3c 66 69 6c 65 6e |m !SCRIPT <filen|
000007d0 61 6d 65 3e 2e 0a 0a 21 43 4f 4d 4d 45 4e 54 0a |ame>...!COMMENT.|
000007e0 3d 3d 3d 3d 3d 3d 3d 3d 0a 55 73 65 20 74 6f 20 |========.Use to |
000007f0 69 6e 73 65 72 74 20 65 78 70 6c 61 6e 61 74 6f |insert explanato|
00000800 72 79 20 63 6f 6d 6d 65 6e 74 73 20 69 6e 20 61 |ry comments in a|
00000810 20 73 63 72 69 70 74 20 66 69 6c 65 2e 20 54 68 | script file. Th|
00000820 65 20 72 65 73 74 20 6f 66 20 74 68 65 20 6c 69 |e rest of the li|
00000830 6e 65 0a 61 66 74 65 72 20 74 68 65 20 63 6f 6d |ne.after the com|
00000840 6d 61 6e 64 20 69 73 20 69 67 6e 6f 72 65 64 2e |mand is ignored.|
00000850 0a 0a 21 53 45 4c 45 43 54 49 4f 4e 20 3c 66 69 |..!SELECTION <fi|
00000860 6c 65 6e 61 6d 65 3e 0a 3d 3d 3d 3d 3d 3d 3d 3d |lename>.========|
00000870 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 54 68 |=============.Th|
00000880 65 20 70 61 72 61 6d 65 74 65 72 20 73 68 6f 75 |e parameter shou|
00000890 6c 64 20 62 65 20 74 68 65 20 6e 61 6d 65 20 6f |ld be the name o|
000008a0 66 20 61 20 73 65 6c 65 63 74 69 6f 6e 20 66 69 |f a selection fi|
000008b0 6c 65 20 69 6e 20 74 68 65 20 50 72 69 6e 74 52 |le in the PrintR|
000008c0 65 73 0a 64 69 72 65 63 74 6f 72 79 2e 20 54 68 |es.directory. Th|
000008d0 65 20 63 6f 6d 6d 61 6e 64 20 77 69 6c 6c 20 69 |e command will i|
000008e0 6e 73 74 61 6c 6c 20 74 68 65 20 73 65 6c 65 63 |nstall the selec|
000008f0 74 69 6f 6e 20 6a 75 73 74 20 61 73 20 74 68 6f |tion just as tho|
00000900 75 67 68 20 79 6f 75 20 68 61 64 0a 64 72 61 67 |ugh you had.drag|
00000910 67 65 64 20 69 74 20 66 72 6f 6d 20 50 72 69 6e |ged it from Prin|
00000920 74 52 65 73 20 74 6f 20 74 68 65 20 50 6f 77 65 |tRes to the Powe|
00000930 72 62 61 73 65 20 77 69 6e 64 6f 77 20 79 6f 75 |rbase window you|
00000940 72 73 65 6c 66 2e 20 49 66 20 79 6f 75 20 69 73 |rself. If you is|
00000950 73 75 65 20 74 68 65 0a 63 6f 6d 6d 61 6e 64 20 |sue the.command |
00000960 77 69 74 68 6f 75 74 20 61 20 70 61 72 61 6d 65 |without a parame|
00000970 74 65 72 20 74 68 65 20 63 75 72 72 65 6e 74 20 |ter the current |
00000980 73 65 6c 65 63 74 69 6f 6e 20 77 69 6c 6c 20 62 |selection will b|
00000990 65 20 63 6c 65 61 72 65 64 2e 0a 0a 21 50 52 49 |e cleared...!PRI|
000009a0 4e 54 4f 50 54 53 20 3c 66 69 6c 65 6e 61 6d 65 |NTOPTS <filename|
000009b0 3e 0a 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |>.==============|
000009c0 3d 3d 3d 3d 3d 3d 3d 0a 54 68 65 20 70 61 72 61 |=======.The para|
000009d0 6d 65 74 65 72 20 73 68 6f 75 6c 64 20 62 65 20 |meter should be |
000009e0 74 68 65 20 6e 61 6d 65 20 6f 66 20 61 20 70 72 |the name of a pr|
000009f0 69 6e 74 20 6f 70 74 69 6f 6e 73 20 66 69 6c 65 |int options file|
00000a00 20 69 6e 20 74 68 65 20 50 72 69 6e 74 52 65 73 | in the PrintRes|
00000a10 0a 64 69 72 65 63 74 6f 72 79 2e 20 54 68 65 20 |.directory. The |
00000a20 6f 70 74 69 6f 6e 73 20 77 69 6c 6c 20 62 65 20 |options will be |
00000a30 73 65 74 20 6a 75 73 74 20 61 73 20 69 66 20 74 |set just as if t|
00000a40 68 65 20 74 68 65 20 66 69 6c 65 20 68 61 64 20 |he the file had |
00000a50 62 65 65 6e 20 64 72 61 67 67 65 64 0a 66 72 6f |been dragged.fro|
00000a60 6d 20 50 72 69 6e 74 52 65 73 20 74 6f 20 74 68 |m PrintRes to th|
00000a70 65 20 50 6f 77 65 72 62 61 73 65 20 77 69 6e 64 |e Powerbase wind|
00000a80 6f 77 2e 20 20 49 73 73 75 65 64 20 77 69 74 68 |ow. Issued with|
00000a90 6f 75 74 20 61 20 70 61 72 61 6d 65 74 65 72 20 |out a parameter |
00000aa0 63 61 75 73 65 73 0a 74 68 65 20 64 65 66 61 75 |causes.the defau|
00000ab0 6c 74 20 6f 70 74 69 6f 6e 73 20 74 6f 20 62 65 |lt options to be|
00000ac0 20 73 65 74 2e 0a 0a 21 51 55 45 52 59 20 3c 73 | set...!QUERY <s|
00000ad0 65 61 72 63 68 20 66 6f 72 6d 75 6c 61 3e 0a 3d |earch formula>.=|
00000ae0 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |================|
00000af0 3d 3d 3d 3d 3d 3d 0a 54 68 69 73 20 63 6f 6d 6d |======.This comm|
00000b00 61 6e 64 20 69 73 20 75 73 65 64 20 74 6f 20 70 |and is used to p|
00000b10 72 69 6e 74 20 61 20 6c 69 73 74 2e 20 49 74 20 |rint a list. It |
00000b20 67 69 76 65 73 20 74 68 65 20 73 61 6d 65 20 72 |gives the same r|
00000b30 65 73 75 6c 74 20 61 73 20 74 79 70 69 6e 67 20 |esult as typing |
00000b40 74 68 65 0a 73 65 61 72 63 68 20 66 6f 72 6d 75 |the.search formu|
00000b50 6c 61 20 69 6e 74 6f 20 74 68 65 20 4d 61 74 63 |la into the Matc|
00000b60 68 20 77 69 6e 64 6f 77 20 61 6e 64 20 63 6c 69 |h window and cli|
00000b70 63 6b 69 6e 67 20 4f 4b 2e 0a 0a 21 45 58 50 41 |cking OK...!EXPA|
00000b80 4e 44 0a 3d 3d 3d 3d 3d 3d 3d 0a 4c 69 6b 65 20 |ND.=======.Like |
00000b90 6d 61 6e 79 20 6f 66 20 74 68 65 20 63 6f 6d 6d |many of the comm|
00000ba0 61 6e 64 73 20 77 68 69 63 68 20 66 6f 6c 6c 6f |ands which follo|
00000bb0 77 2c 20 74 68 69 73 20 69 73 20 75 73 65 64 20 |w, this is used |
00000bc0 74 6f 20 73 65 6c 65 63 74 20 6f 72 20 64 65 73 |to select or des|
00000bd0 65 6c 65 63 74 20 61 0a 62 75 74 74 6f 6e 20 69 |elect a.button i|
00000be0 6e 20 74 68 65 20 70 72 69 6e 74 20 6f 70 74 69 |n the print opti|
00000bf0 6f 6e 73 20 77 69 6e 64 6f 77 20 2e 20 21 45 58 |ons window . !EX|
00000c00 50 41 4e 44 20 4f 4e 20 73 65 6c 65 63 74 73 20 |PAND ON selects |
00000c10 74 68 65 20 62 75 74 74 6f 6e 20 77 68 69 63 68 |the button which|
00000c20 0a 63 61 75 73 65 73 20 66 69 65 6c 64 73 20 74 |.causes fields t|
00000c30 6f 20 62 65 20 65 78 70 61 6e 64 65 64 20 62 79 |o be expanded by|
00000c40 20 72 65 66 65 72 65 6e 63 65 20 74 6f 20 61 20 | reference to a |
00000c50 6c 69 6e 6b 65 64 20 76 61 6c 69 64 61 74 69 6f |linked validatio|
00000c60 6e 20 74 61 62 6c 65 2e 20 0a 21 45 58 50 41 4e |n table. .!EXPAN|
00000c70 44 20 4f 46 46 20 28 6f 72 20 6a 75 73 74 20 21 |D OFF (or just !|
00000c80 45 58 50 41 4e 44 20 62 79 20 69 74 73 65 6c 66 |EXPAND by itself|
00000c90 29 20 64 65 73 65 6c 65 63 74 73 20 74 68 65 20 |) deselects the |
00000ca0 62 75 74 74 6f 6e 2e 0a 0a 21 44 41 54 45 0a 3d |button...!DATE.=|
00000cb0 3d 3d 3d 3d 0a 54 75 72 6e 73 20 64 61 74 65 20 |====.Turns date |
00000cc0 61 6e 64 20 74 69 6d 65 20 73 74 61 6d 70 69 6e |and time stampin|
00000cd0 67 20 4f 4e 20 61 6e 64 20 4f 46 46 2e 20 49 74 |g ON and OFF. It|
00000ce0 20 77 6f 72 6b 73 20 69 6e 20 65 78 61 63 74 6c | works in exactl|
00000cf0 79 20 74 68 65 20 73 61 6d 65 20 77 61 79 20 61 |y the same way a|
00000d00 73 0a 21 45 58 50 41 4e 44 2e 0a 0a 21 55 50 50 |s.!EXPAND...!UPP|
00000d10 45 52 0a 3d 3d 3d 3d 3d 3d 0a 46 6f 72 63 65 73 |ER.======.Forces|
00000d20 20 75 70 70 65 72 2d 63 61 73 65 20 70 72 69 6e | upper-case prin|
00000d30 74 69 6e 67 20 77 68 65 6e 20 66 6f 6c 6c 6f 77 |ting when follow|
00000d40 65 64 20 62 79 20 4f 4e 2c 20 6e 6f 72 6d 61 6c |ed by ON, normal|
00000d50 20 75 70 70 65 72 2f 6c 6f 77 65 72 20 63 61 73 | upper/lower cas|
00000d60 65 0a 70 72 69 6e 74 69 6e 67 20 6f 74 68 65 72 |e.printing other|
00000d70 77 69 73 65 2e 0a 0a 21 55 4e 44 45 52 4c 49 4e |wise...!UNDERLIN|
00000d80 45 0a 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 54 75 72 |E.==========.Tur|
00000d90 6e 73 20 75 6e 64 65 72 6c 69 6e 69 6e 67 20 4f |ns underlining O|
00000da0 4e 20 61 6e 64 20 4f 46 46 20 77 68 65 6e 20 6f |N and OFF when o|
00000db0 75 74 70 75 74 20 69 73 20 73 65 6e 74 20 74 6f |utput is sent to|
00000dc0 20 74 68 65 20 70 72 69 6e 74 65 72 2e 20 59 6f | the printer. Yo|
00000dd0 75 20 77 69 6c 6c 20 6e 6f 74 0a 73 65 65 20 61 |u will not.see a|
00000de0 6e 79 20 75 6e 64 65 72 6c 69 6e 69 6e 67 20 77 |ny underlining w|
00000df0 68 65 6e 20 74 68 65 20 72 65 70 6f 72 74 20 69 |hen the report i|
00000e00 73 20 64 69 73 70 6c 61 79 65 64 20 69 6e 20 61 |s displayed in a|
00000e10 20 77 69 6e 64 6f 77 20 62 79 20 50 6f 77 65 72 | window by Power|
00000e20 62 61 73 65 2c 0a 62 75 74 20 75 6e 64 65 72 6c |base,.but underl|
00000e30 69 6e 69 6e 67 20 77 69 6c 6c 20 6f 63 63 75 72 |ining will occur|
00000e40 20 77 68 65 6e 20 74 68 65 20 77 69 6e 64 6f 77 | when the window|
00000e50 65 64 20 6f 75 74 70 75 74 20 69 73 20 73 75 62 |ed output is sub|
00000e60 73 65 71 75 65 6e 74 6c 79 20 70 72 69 6e 74 65 |sequently printe|
00000e70 64 2e 0a 0a 21 43 41 53 45 0a 3d 3d 3d 3d 3d 0a |d...!CASE.=====.|
00000e80 54 75 72 6e 73 20 74 68 65 20 27 43 61 73 65 20 |Turns the 'Case |
00000e90 73 70 65 63 69 66 69 63 27 20 62 75 74 74 6f 6e |specific' button|
00000ea0 20 69 6e 20 74 68 65 20 4d 61 74 63 68 20 77 69 | in the Match wi|
00000eb0 6e 64 6f 77 20 4f 4e 20 61 6e 64 20 4f 46 46 2e |ndow ON and OFF.|
00000ec0 0a 0a 21 49 4e 44 45 58 0a 3d 3d 3d 3d 3d 3d 0a |..!INDEX.======.|
00000ed0 54 75 72 6e 73 20 74 68 65 20 27 55 73 65 20 69 |Turns the 'Use i|
00000ee0 6e 64 65 78 27 20 62 75 74 74 6f 6e 20 69 6e 20 |ndex' button in |
00000ef0 74 68 65 20 4d 61 74 63 68 20 77 69 6e 64 6f 77 |the Match window|
00000f00 20 4f 4e 20 61 6e 64 20 4f 46 46 2e 0a 0a 21 46 | ON and OFF...!F|
00000f10 49 52 53 54 0a 3d 3d 3d 3d 3d 3d 0a 46 6f 6c 6c |IRST.======.Foll|
00000f20 6f 77 65 64 20 62 79 20 4f 4e 20 74 68 69 73 20 |owed by ON this |
00000f30 63 61 75 73 65 73 20 61 6e 79 20 68 65 61 64 65 |causes any heade|
00000f40 72 20 69 6e 66 6f 72 6d 61 74 69 6f 6e 2c 20 73 |r information, s|
00000f50 75 63 68 20 61 73 20 64 61 74 65 2d 73 74 61 6d |uch as date-stam|
00000f60 70 20 6f 72 0a 74 69 74 6c 65 2c 20 74 6f 20 61 |p or.title, to a|
00000f70 70 70 65 61 72 20 6f 6e 20 74 68 65 20 66 69 72 |ppear on the fir|
00000f80 73 74 20 70 61 67 65 20 6f 6e 6c 79 20 6f 66 20 |st page only of |
00000f90 61 20 72 65 70 6f 72 74 2e 20 57 68 65 6e 20 4f |a report. When O|
00000fa0 46 46 20 74 68 65 20 68 65 61 64 65 72 20 69 73 |FF the header is|
00000fb0 0a 70 72 69 6e 74 65 64 20 6f 6e 20 65 76 65 72 |.printed on ever|
00000fc0 79 20 70 61 67 65 2e 0a 0a 21 53 48 52 49 4e 4b |y page...!SHRINK|
00000fd0 0a 3d 3d 3d 3d 3d 3d 3d 0a 46 6f 6c 6c 6f 77 65 |.=======.Followe|
00000fe0 64 20 62 79 20 4f 4e 20 74 68 69 73 20 72 65 6d |d by ON this rem|
00000ff0 6f 76 65 73 20 73 75 72 70 6c 75 73 20 22 77 68 |oves surplus "wh|
00001000 69 74 65 20 73 70 61 63 65 22 20 62 65 74 77 65 |ite space" betwe|
00001010 65 6e 20 74 68 65 20 63 6f 6c 75 6d 6e 73 20 6f |en the columns o|
00001020 66 0a 72 65 70 6f 72 74 73 20 69 6e 20 56 65 72 |f.reports in Ver|
00001030 74 69 63 61 6c 20 66 6f 72 6d 61 74 2e 0a 0a 21 |tical format...!|
00001040 48 45 41 44 49 4e 47 53 20 44 0a 3d 3d 3d 3d 3d |HEADINGS D.=====|
00001050 3d 3d 3d 3d 3d 3d 0a 43 61 75 73 65 73 20 64 65 |======.Causes de|
00001060 73 63 72 69 70 74 6f 72 73 20 74 6f 20 62 65 20 |scriptors to be |
00001070 75 73 65 64 20 61 73 20 66 69 65 6c 64 20 69 64 |used as field id|
00001080 65 6e 74 69 66 69 65 72 73 20 69 6e 20 61 20 72 |entifiers in a r|
00001090 65 70 6f 72 74 2e 20 21 48 45 41 44 49 4e 47 53 |eport. !HEADINGS|
000010a0 20 54 2c 0a 6f 72 20 77 69 74 68 6f 75 74 20 61 | T,.or without a|
000010b0 6e 79 20 70 61 72 61 6d 65 74 65 72 2c 20 63 61 |ny parameter, ca|
000010c0 75 73 65 73 20 74 61 67 73 20 74 6f 20 62 65 20 |uses tags to be |
000010d0 75 73 65 64 2e 0a 0a 21 50 49 54 43 48 20 3c 63 |used...!PITCH <c|
000010e0 70 69 3e 0a 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |pi>.============|
000010f0 0a 54 68 65 20 70 61 72 61 6d 65 74 65 72 20 73 |.The parameter s|
00001100 68 6f 75 6c 64 20 62 65 20 35 2c 20 31 30 2c 20 |hould be 5, 10, |
00001110 31 32 20 6f 72 20 31 37 2c 20 72 65 70 72 65 73 |12 or 17, repres|
00001120 65 6e 74 69 6e 67 20 64 6f 75 62 6c 65 2d 77 69 |enting double-wi|
00001130 64 74 68 2c 20 70 69 63 61 2c 0a 65 6c 69 74 65 |dth, pica,.elite|
00001140 20 61 6e 64 20 63 6f 6e 64 65 6e 73 65 64 20 72 | and condensed r|
00001150 65 73 70 65 63 74 69 76 65 6c 79 2e 0a 20 0a 21 |espectively.. .!|
00001160 54 49 54 4c 45 0a 3d 3d 3d 3d 3d 3d 0a 46 6f 6c |TITLE.======.Fol|
00001170 6c 6f 77 65 64 20 62 79 20 61 20 74 65 78 74 20 |lowed by a text |
00001180 73 74 72 69 6e 67 20 63 61 75 73 65 73 20 74 68 |string causes th|
00001190 65 20 73 74 72 69 6e 67 20 74 6f 20 62 65 20 75 |e string to be u|
000011a0 73 65 64 20 61 73 20 61 20 74 69 74 6c 65 20 6f |sed as a title o|
000011b0 6e 0a 73 75 62 73 65 71 75 65 6e 74 6c 79 20 70 |n.subsequently p|
000011c0 72 69 6e 74 65 64 20 72 65 70 6f 72 74 73 2e 0a |rinted reports..|
000011d0 0a 21 50 41 47 45 20 3c 6c 69 6e 65 73 3e 0a 3d |.!PAGE <lines>.=|
000011e0 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 55 73 65 |============.Use|
000011f0 20 74 6f 20 73 65 74 20 74 68 65 20 70 61 67 65 | to set the page|
00001200 20 6c 65 6e 67 74 68 20 66 6f 72 20 72 65 70 6f | length for repo|
00001210 72 74 73 2e 20 37 30 20 69 73 20 63 6f 72 72 65 |rts. 70 is corre|
00001220 63 74 20 66 6f 72 20 41 34 2c 20 36 36 20 66 6f |ct for A4, 66 fo|
00001230 72 0a 41 6d 65 72 69 63 61 6e 20 6c 65 74 74 65 |r.American lette|
00001240 72 2e 0a 0a 21 4c 49 4e 45 53 50 41 43 45 20 3c |r...!LINESPACE <|
00001250 6e 3e 0a 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |n>.=============|
00001260 3d 0a 53 65 74 73 20 74 68 65 20 6c 69 6e 65 2d |=.Sets the line-|
00001270 73 70 61 63 69 6e 67 20 74 6f 20 6e 20 6c 69 6e |spacing to n lin|
00001280 65 73 2e 20 54 68 65 20 64 65 66 61 75 6c 74 20 |es. The default |
00001290 69 73 20 31 2c 20 69 2e 65 2e 20 6e 6f 20 62 6c |is 1, i.e. no bl|
000012a0 61 6e 6b 20 6c 69 6e 65 73 0a 62 65 74 77 65 65 |ank lines.betwee|
000012b0 6e 20 6c 69 6e 65 73 20 6f 66 20 72 65 70 6f 72 |n lines of repor|
000012c0 74 2e 0a 0a 21 4c 4d 41 52 47 49 4e 20 3c 6e 3e |t...!LMARGIN <n>|
000012d0 0a 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 53 65 |.============.Se|
000012e0 74 73 20 74 68 65 20 6c 65 66 74 20 6d 61 72 67 |ts the left marg|
000012f0 69 6e 20 74 6f 20 6e 20 63 68 61 72 61 63 74 65 |in to n characte|
00001300 72 20 73 70 61 63 65 73 0a 0a 21 54 4d 41 52 47 |r spaces..!TMARG|
00001310 49 4e 20 3c 6e 3e 0a 3d 3d 3d 3d 3d 3d 3d 3d 3d |IN <n>.=========|
00001320 3d 3d 3d 0a 53 65 74 73 20 74 68 65 20 74 6f 70 |===.Sets the top|
00001330 20 6d 61 72 67 69 6e 20 74 6f 20 6e 20 6c 69 6e | margin to n lin|
00001340 65 73 0a 0a 21 53 50 41 43 45 52 20 3c 73 74 72 |es..!SPACER <str|
00001350 69 6e 67 3e 0a 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |ing>.===========|
00001360 3d 3d 3d 3d 3d 0a 53 70 65 63 69 66 69 65 73 20 |=====.Specifies |
00001370 74 68 65 20 73 74 72 69 6e 67 20 74 6f 20 62 65 |the string to be|
00001380 20 75 73 65 64 20 74 6f 20 73 65 70 61 72 61 74 | used to separat|
00001390 65 20 63 6f 6c 75 6d 6e 73 20 6f 66 20 70 72 69 |e columns of pri|
000013a0 6e 74 65 64 20 64 61 74 61 20 69 6e 0a 72 65 70 |nted data in.rep|
000013b0 6f 72 74 73 20 75 73 69 6e 67 20 27 48 6f 72 69 |orts using 'Hori|
000013c0 7a 6f 6e 74 61 6c 27 20 6f 72 20 27 54 61 62 6c |zontal' or 'Tabl|
000013d0 65 27 20 66 6f 72 6d 61 74 2e 0a 0a 21 43 4f 4c |e' format...!COL|
000013e0 57 49 44 54 48 20 3c 6e 3e 0a 3d 3d 3d 3d 3d 3d |WIDTH <n>.======|
000013f0 3d 3d 3d 3d 3d 3d 3d 0a 53 65 74 73 20 74 68 65 |=======.Sets the|
00001400 20 77 69 64 74 68 20 6f 66 20 74 68 65 20 62 6c | width of the bl|
00001410 61 6e 6b 20 63 6f 6c 75 6d 6e 73 20 75 73 65 64 |ank columns used|
00001420 20 69 6e 20 27 54 61 62 6c 65 27 20 66 6f 72 6d | in 'Table' form|
00001430 61 74 20 74 6f 20 6e 20 73 70 61 63 65 73 2e 0a |at to n spaces..|
00001440 0a 21 46 4f 52 4d 41 54 0a 3d 3d 3d 3d 3d 3d 3d |.!FORMAT.=======|
00001450 0a 46 6f 6c 6c 6f 77 20 74 68 69 73 20 63 6f 6d |.Follow this com|
00001460 6d 61 6e 64 20 77 69 74 68 20 48 4f 52 49 5a 4f |mand with HORIZO|
00001470 4e 54 41 4c 2c 20 56 45 52 54 49 43 41 4c 2c 20 |NTAL, VERTICAL, |
00001480 4c 41 42 45 4c 20 6f 72 20 54 41 42 4c 45 2e 20 |LABEL or TABLE. |
00001490 49 6e 20 74 68 65 20 6c 61 73 74 0a 63 61 73 65 |In the last.case|
000014a0 20 74 68 65 20 6e 75 6d 62 65 72 20 6f 66 20 63 | the number of c|
000014b0 6f 6c 75 6d 6e 73 20 72 65 71 75 69 72 65 64 20 |olumns required |
000014c0 6d 75 73 74 20 62 65 20 61 70 70 65 6e 64 65 64 |must be appended|
000014d0 20 61 73 20 61 20 73 65 63 6f 6e 64 20 70 61 72 | as a second par|
000014e0 61 6d 65 74 65 72 2c 0a 65 2e 67 2e 20 54 41 42 |ameter,.e.g. TAB|
000014f0 4c 45 20 38 2e 20 20 49 66 20 61 6e 79 20 6f 74 |LE 8. If any ot|
00001500 68 65 72 20 70 61 72 61 6d 65 74 65 72 20 69 73 |her parameter is|
00001510 20 75 73 65 64 2c 20 6f 72 20 21 46 4f 52 4d 41 | used, or !FORMA|
00001520 54 20 69 73 20 69 73 73 75 65 64 20 62 79 0a 69 |T is issued by.i|
00001530 74 73 65 6c 66 2c 20 74 68 65 20 48 4f 52 49 5a |tself, the HORIZ|
00001540 4f 4e 54 41 4c 20 66 6f 72 6d 61 74 20 69 73 20 |ONTAL format is |
00001550 75 73 65 64 2e 0a 0a 21 44 45 53 54 49 4e 41 54 |used...!DESTINAT|
00001560 49 4f 4e 0a 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |ION.============|
00001570 0a 53 68 6f 75 6c 64 20 62 65 20 66 6f 6c 6c 6f |.Should be follo|
00001580 77 65 64 20 77 69 74 68 20 57 49 4e 44 4f 57 20 |wed with WINDOW |
00001590 6f 72 20 46 49 4c 45 20 6f 72 20 50 52 49 4e 54 |or FILE or PRINT|
000015a0 45 52 2e 20 54 68 65 20 66 69 72 73 74 20 63 61 |ER. The first ca|
000015b0 75 73 65 73 20 72 65 70 6f 72 74 73 0a 74 6f 20 |uses reports.to |
000015c0 62 65 20 64 69 73 70 6c 61 79 65 64 20 69 6e 20 |be displayed in |
000015d0 61 20 77 69 6e 64 6f 77 2c 20 66 72 6f 6d 20 77 |a window, from w|
000015e0 68 69 63 68 20 74 68 65 79 20 6d 61 79 20 62 65 |hich they may be|
000015f0 20 73 75 62 73 65 71 75 65 6e 74 6c 79 20 73 61 | subsequently sa|
00001600 76 65 64 2e 20 46 49 4c 45 0a 63 61 75 73 65 73 |ved. FILE.causes|
00001610 20 6f 75 74 70 75 74 20 74 6f 20 62 65 20 73 65 | output to be se|
00001620 6e 74 20 74 6f 20 61 20 74 65 78 74 20 66 69 6c |nt to a text fil|
00001630 65 20 73 70 65 63 69 66 69 65 64 20 62 79 20 74 |e specified by t|
00001640 68 65 20 75 73 65 72 2e 20 50 52 49 4e 54 45 52 |he user. PRINTER|
00001650 0a 63 61 75 73 65 73 20 6f 75 74 70 75 74 20 74 |.causes output t|
00001660 6f 20 67 6f 20 64 69 72 65 63 74 6c 79 20 74 6f |o go directly to|
00001670 20 74 68 65 20 70 72 69 6e 74 65 72 20 77 69 74 | the printer wit|
00001680 68 6f 75 74 20 62 65 69 6e 67 20 70 72 65 76 69 |hout being previ|
00001690 6f 75 73 6c 79 0a 64 69 73 70 6c 61 79 65 64 20 |ously.displayed |
000016a0 6f 72 20 73 61 76 65 64 2e 0a 0a 21 4c 41 42 45 |or saved...!LABE|
000016b0 4c 0a 3d 3d 3d 3d 3d 3d 0a 54 68 69 73 20 69 73 |L.======.This is|
000016c0 20 75 73 65 64 20 74 6f 20 64 65 66 69 6e 65 20 | used to define |
000016d0 61 20 6c 61 62 65 6c 20 73 70 65 63 69 66 69 63 |a label specific|
000016e0 61 74 69 6f 6e 20 74 6f 20 75 73 65 20 77 69 74 |ation to use wit|
000016f0 68 20 74 68 65 20 4c 41 42 45 4c 20 66 6f 72 6d |h the LABEL form|
00001700 61 74 2e 0a 49 74 20 72 65 71 75 69 72 65 73 20 |at..It requires |
00001710 37 20 70 61 72 61 6d 65 74 65 72 73 2c 20 73 65 |7 parameters, se|
00001720 70 61 72 61 74 65 64 20 62 79 20 63 6f 6d 6d 61 |parated by comma|
00001730 73 3a 0a 0a 20 20 20 20 28 31 29 20 54 68 65 20 |s:.. (1) The |
00001740 6e 75 6d 62 65 72 20 6f 66 20 6c 61 62 65 6c 73 |number of labels|
00001750 20 61 63 72 6f 73 73 20 74 68 65 20 70 61 67 65 | across the page|
00001760 20 28 31 2c 32 20 6f 72 20 33 29 0a 20 20 20 20 | (1,2 or 3). |
00001770 28 32 29 20 54 68 65 20 68 6f 72 69 7a 6f 6e 74 |(2) The horizont|
00001780 61 6c 20 6c 61 62 65 6c 20 70 69 74 63 68 20 28 |al label pitch (|
00001790 69 2e 65 2e 20 6c 65 66 74 20 65 64 67 65 20 74 |i.e. left edge t|
000017a0 6f 20 6c 65 66 74 20 65 64 67 65 29 20 69 6e 20 |o left edge) in |
000017b0 69 6e 63 68 65 73 2e 0a 20 20 20 20 20 20 20 20 |inches.. |
000017c0 54 68 69 73 20 69 73 20 6f 6e 6c 79 20 6d 65 61 |This is only mea|
000017d0 6e 69 6e 67 66 75 6c 20 77 68 65 6e 20 28 31 29 |ningful when (1)|
000017e0 20 69 73 20 32 20 6f 72 20 33 2e 0a 20 20 20 20 | is 2 or 3.. |
000017f0 28 33 29 20 54 68 65 20 76 65 72 74 69 63 61 6c |(3) The vertical|
00001800 20 6c 61 62 65 6c 20 70 69 74 63 68 20 69 6e 20 | label pitch in |
00001810 69 6e 63 68 65 73 2e 0a 20 20 20 20 28 34 29 20 |inches.. (4) |
00001820 54 68 65 20 6e 75 6d 62 65 72 20 6f 66 20 6c 69 |The number of li|
00001830 6e 65 73 20 74 6f 20 62 65 20 70 72 69 6e 74 65 |nes to be printe|
00001840 64 20 6f 6e 20 65 61 63 68 20 6c 61 62 65 6c 2e |d on each label.|
00001850 0a 20 20 20 20 28 35 29 20 54 68 65 20 6c 69 6e |. (5) The lin|
00001860 65 20 77 68 69 63 68 20 69 73 20 74 6f 20 62 65 |e which is to be|
00001870 20 72 65 70 6c 61 63 65 64 2c 20 69 66 20 62 6c | replaced, if bl|
00001880 61 6e 6b 2c 20 62 79 20 74 68 65 20 6c 61 73 74 |ank, by the last|
00001890 20 66 69 65 6c 64 20 69 6e 0a 20 20 20 20 20 20 | field in. |
000018a0 20 20 74 68 65 20 73 65 6c 65 63 74 69 6f 6e 2e | the selection.|
000018b0 20 49 66 20 6e 6f 74 68 69 6e 67 20 69 73 20 65 | If nothing is e|
000018c0 6e 74 65 72 65 64 20 68 65 72 65 20 28 32 20 63 |ntered here (2 c|
000018d0 6f 6d 6d 61 73 20 74 6f 67 65 74 68 65 72 29 20 |ommas together) |
000018e0 74 68 65 6e 0a 20 20 20 20 20 20 20 20 6e 6f 20 |then. no |
000018f0 73 75 62 73 74 69 74 75 74 69 6f 6e 20 69 73 20 |substitution is |
00001900 70 65 72 66 6f 72 6d 65 64 2e 0a 20 20 20 20 28 |performed.. (|
00001910 36 29 20 49 66 20 4f 4e 20 69 73 20 65 6e 74 65 |6) If ON is ente|
00001920 72 65 64 20 74 68 65 20 74 68 65 20 70 72 69 6d |red the the prim|
00001930 61 72 79 20 6b 65 79 20 77 69 6c 6c 20 61 70 70 |ary key will app|
00001940 65 61 72 20 6f 6e 20 74 68 65 20 6c 61 62 65 6c |ear on the label|
00001950 20 28 69 6e 0a 20 20 20 20 20 20 20 20 62 72 61 | (in. bra|
00001960 63 6b 65 74 73 29 20 61 73 20 61 6e 20 69 64 65 |ckets) as an ide|
00001970 6e 74 69 66 69 65 72 2e 0a 20 20 20 20 28 37 29 |ntifier.. (7)|
00001980 20 49 66 20 4f 4e 20 69 73 20 65 6e 74 65 72 65 | If ON is entere|
00001990 64 20 62 6c 61 6e 6b 20 66 69 65 6c 64 73 20 77 |d blank fields w|
000019a0 69 6c 6c 20 62 65 20 73 6b 69 70 70 65 64 20 77 |ill be skipped w|
000019b0 68 65 6e 20 70 72 69 6e 74 69 6e 67 2e 0a 0a 21 |hen printing...!|
000019c0 44 45 4c 45 54 45 20 3c 6b 65 79 3e 0a 3d 3d 3d |DELETE <key>.===|
000019d0 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 54 68 69 73 20 |==========.This |
000019e0 70 72 6f 76 69 64 65 73 20 61 20 77 61 79 20 6f |provides a way o|
000019f0 66 20 64 65 6c 65 74 69 6e 67 20 72 65 63 6f 72 |f deleting recor|
00001a00 64 73 20 66 72 6f 6d 20 74 68 65 20 64 61 74 61 |ds from the data|
00001a10 62 61 73 65 2e 20 54 68 65 20 70 61 72 61 6d 65 |base. The parame|
00001a20 74 65 72 0a 6d 75 73 74 20 62 65 20 74 68 65 20 |ter.must be the |
00001a30 70 72 69 6d 61 72 79 20 6b 65 79 20 6f 66 20 74 |primary key of t|
00001a40 68 65 20 72 65 63 6f 72 64 2e 20 54 68 65 20 62 |he record. The b|
00001a50 65 6e 65 66 69 74 73 20 6f 66 20 74 68 69 73 20 |enefits of this |
00001a60 63 6f 6d 6d 61 6e 64 20 6d 61 79 20 6e 6f 74 0a |command may not.|
00001a70 62 65 20 61 74 20 61 6c 6c 20 6f 62 76 69 6f 75 |be at all obviou|
00001a80 73 2e 20 53 75 70 70 6f 73 65 20 79 6f 75 20 68 |s. Suppose you h|
00001a90 61 76 65 20 61 20 74 65 78 74 20 66 69 6c 65 20 |ave a text file |
00001aa0 67 69 76 69 6e 67 20 64 65 74 61 69 6c 73 20 6f |giving details o|
00001ab0 66 20 72 65 63 6f 72 64 73 0a 77 68 69 63 68 20 |f records.which |
00001ac0 6d 75 73 74 20 62 65 20 64 65 6c 65 74 65 64 20 |must be deleted |
00001ad0 66 72 6f 6d 20 74 68 65 20 64 61 74 61 62 61 73 |from the databas|
00001ae0 65 2e 20 49 66 20 73 75 63 68 20 61 20 6a 6f 62 |e. If such a job|
00001af0 20 69 73 20 67 6f 69 6e 67 20 74 6f 20 6f 63 63 | is going to occ|
00001b00 75 72 20 61 74 0a 61 6c 6c 20 6f 66 74 65 6e 20 |ur at.all often |
00001b10 69 74 20 63 6f 75 6c 64 20 62 65 20 77 6f 72 74 |it could be wort|
00001b20 68 77 68 69 6c 65 20 74 6f 20 77 72 69 74 65 20 |hwhile to write |
00001b30 61 20 63 75 73 74 6f 6d 69 73 65 64 20 70 72 6f |a customised pro|
00001b40 67 72 61 6d 20 74 6f 20 72 65 61 64 20 74 68 65 |gram to read the|
00001b50 0a 74 65 78 74 20 66 69 6c 65 20 61 6e 64 20 67 |.text file and g|
00001b60 65 6e 65 72 61 74 65 20 74 68 65 20 70 72 69 6d |enerate the prim|
00001b70 61 72 79 20 6b 65 79 20 6f 66 20 65 61 63 68 20 |ary key of each |
00001b80 72 65 63 6f 72 64 2c 20 74 68 65 6e 20 6f 75 74 |record, then out|
00001b90 70 75 74 20 74 68 65 0a 72 65 73 75 6c 74 73 20 |put the.results |
00001ba0 61 73 20 61 20 50 6f 77 65 72 62 61 73 65 20 73 |as a Powerbase s|
00001bb0 63 72 69 70 74 20 66 69 6c 65 2e 20 54 68 65 20 |cript file. The |
00001bc0 77 68 6f 6c 65 20 62 61 74 63 68 20 6f 66 20 72 |whole batch of r|
00001bd0 65 63 6f 72 64 73 20 63 61 6e 20 74 68 65 6e 20 |ecords can then |
00001be0 62 65 0a 64 65 6c 65 74 65 64 20 62 79 20 73 69 |be.deleted by si|
00001bf0 6d 70 6c 79 20 64 72 61 67 67 69 6e 67 20 74 68 |mply dragging th|
00001c00 65 20 73 63 72 69 70 74 20 69 6e 74 6f 20 50 6f |e script into Po|
00001c10 77 65 72 62 61 73 65 2e 20 4e 6f 74 20 77 6f 72 |werbase. Not wor|
00001c20 74 68 77 68 69 6c 65 20 66 6f 72 20 74 65 6e 0a |thwhile for ten.|
00001c30 72 65 63 6f 72 64 73 2c 20 70 65 72 68 61 70 73 |records, perhaps|
00001c40 2c 20 62 75 74 20 63 6f 75 6c 64 20 62 65 20 66 |, but could be f|
00001c50 6f 72 20 61 20 68 75 6e 64 72 65 64 2e 20 4e 6f |or a hundred. No|
00001c60 74 65 20 74 68 61 74 20 61 6c 6c 20 36 20 73 75 |te that all 6 su|
00001c70 62 66 69 6c 65 73 20 77 69 6c 6c 0a 62 65 20 73 |bfiles will.be s|
00001c80 65 61 72 63 68 65 64 20 66 6f 72 20 74 68 65 20 |earched for the |
00001c90 72 65 63 6f 72 64 73 20 74 6f 20 62 65 20 64 65 |records to be de|
00001ca0 6c 65 74 65 64 2e 0a 0a 21 49 4e 53 45 52 54 0a |leted...!INSERT.|
00001cb0 3d 3d 3d 3d 3d 3d 3d 0a 54 68 69 73 20 69 73 20 |=======.This is |
00001cc0 74 68 65 20 63 6f 75 6e 74 65 72 70 61 72 74 20 |the counterpart |
00001cd0 6f 66 20 21 44 45 4c 45 54 45 20 61 6e 64 20 69 |of !DELETE and i|
00001ce0 73 20 75 73 65 66 75 6c 20 69 6e 20 73 69 6d 69 |s useful in simi|
00001cf0 6c 61 72 20 63 69 72 63 75 6d 73 74 61 6e 63 65 |lar circumstance|
00001d00 73 2e 0a 49 6e 20 74 68 69 73 20 63 61 73 65 20 |s..In this case |
00001d10 74 68 65 20 63 6f 6d 6d 61 6e 64 20 6d 75 73 74 |the command must|
00001d20 20 6f 63 63 75 70 79 20 61 20 6c 69 6e 65 20 62 | occupy a line b|
00001d30 79 20 69 74 73 65 6c 66 20 61 6e 64 20 62 65 20 |y itself and be |
00001d40 66 6f 6c 6c 6f 77 65 64 20 62 79 20 74 68 65 0a |followed by the.|
00001d50 72 65 63 6f 72 64 20 74 6f 20 69 6e 73 65 72 74 |record to insert|
00001d60 2c 20 6f 6e 65 20 66 69 65 6c 64 20 74 6f 20 61 |, one field to a|
00001d70 20 6c 69 6e 65 2e 20 49 74 20 69 73 20 74 68 65 | line. It is the|
00001d80 20 75 73 65 72 27 73 20 72 65 73 70 6f 6e 73 69 | user's responsi|
00001d90 62 69 6c 69 74 79 20 74 6f 0a 65 6e 73 75 72 65 |bility to.ensure|
00001da0 20 74 68 61 74 20 74 68 65 20 6c 69 6e 65 73 20 | that the lines |
00001db0 61 72 65 20 6e 6f 74 20 74 6f 6f 20 6c 6f 6e 67 |are not too long|
00001dc0 20 66 6f 72 20 74 68 65 20 64 61 74 61 62 61 73 | for the databas|
00001dd0 65 20 66 69 65 6c 64 73 20 69 6e 74 6f 20 77 68 |e fields into wh|
00001de0 69 63 68 0a 74 68 65 79 20 61 72 65 20 70 6c 61 |ich.they are pla|
00001df0 63 65 64 20 61 6e 64 20 74 68 61 74 20 74 68 65 |ced and that the|
00001e00 20 6e 75 6d 62 65 72 20 6f 66 20 6c 69 6e 65 73 | number of lines|
00001e10 20 66 6f 6c 6c 6f 77 69 6e 67 20 65 61 63 68 20 | following each |
00001e20 21 49 4e 53 45 52 54 20 69 73 20 74 68 65 0a 73 |!INSERT is the.s|
00001e30 61 6d 65 20 61 73 20 74 68 65 20 6e 75 6d 62 65 |ame as the numbe|
00001e40 72 20 6f 66 20 66 69 65 6c 64 73 20 69 6e 20 74 |r of fields in t|
00001e50 68 65 20 72 65 63 6f 72 64 2e 20 44 6f 6e 27 74 |he record. Don't|
00001e60 20 66 6f 72 67 65 74 20 74 6f 20 6c 65 61 76 65 | forget to leave|
00001e70 20 62 6c 61 6e 6b 0a 6c 69 6e 65 73 20 66 6f 72 | blank.lines for|
00001e80 20 65 6d 70 74 79 20 66 69 65 6c 64 73 21 20 20 | empty fields! |
00001e90 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
00001ea0 20 0a 0a 21 49 4d 50 52 45 53 53 49 4f 4e 0a 3d | ..!IMPRESSION.=|
00001eb0 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 55 73 65 64 20 |==========.Used |
00001ec0 69 6e 20 63 6f 6e 6a 75 6e 63 74 69 6f 6e 20 77 |in conjunction w|
00001ed0 69 74 68 20 21 51 55 45 52 59 20 74 6f 20 67 65 |ith !QUERY to ge|
00001ee0 6e 65 72 61 74 65 20 61 20 72 65 70 6f 72 74 20 |nerate a report |
00001ef0 69 6e 20 74 65 78 74 2d 66 69 6c 65 20 66 6f 72 |in text-file for|
00001f00 6d 61 74 2c 0a 74 68 69 73 20 61 6c 6c 6f 77 73 |mat,.this allows|
00001f10 20 79 6f 75 20 74 6f 20 69 6e 73 65 72 74 20 27 | you to insert '|
00001f20 49 6d 70 72 65 73 73 69 6f 6e 27 20 66 6f 72 6d |Impression' form|
00001f30 61 74 74 69 6e 67 20 63 6f 6d 6d 61 6e 64 73 20 |atting commands |
00001f40 61 74 20 74 68 65 20 73 74 61 72 74 20 6f 66 0a |at the start of.|
00001f50 74 68 65 20 74 65 78 74 2d 66 69 6c 65 2e 20 41 |the text-file. A|
00001f60 20 73 63 72 69 70 74 20 6d 61 79 2c 20 66 6f 72 | script may, for|
00001f70 20 65 78 61 6d 70 6c 65 2c 20 65 78 65 63 75 74 | example, execut|
00001f80 65 20 61 20 73 65 72 69 65 73 20 6f 66 20 21 51 |e a series of !Q|
00001f90 55 45 52 59 0a 63 6f 6d 6d 61 6e 64 73 20 61 6e |UERY.commands an|
00001fa0 64 20 74 68 65 20 72 65 73 75 6c 74 69 6e 67 20 |d the resulting |
00001fb0 66 69 6c 65 73 20 61 72 65 20 74 6f 20 62 65 20 |files are to be |
00001fc0 61 6c 6c 20 73 65 6c 65 63 74 65 64 20 74 6f 67 |all selected tog|
00001fd0 65 74 68 65 72 20 61 6e 64 20 64 72 61 67 67 65 |ether and dragge|
00001fe0 64 0a 69 6e 74 6f 20 61 6e 20 27 49 6d 70 72 65 |d.into an 'Impre|
00001ff0 73 73 69 6f 6e 27 20 64 6f 63 75 6d 65 6e 74 2e |ssion' document.|
00002000 20 54 6f 20 6d 61 6b 65 20 65 61 63 68 20 66 69 | To make each fi|
00002010 6c 65 20 67 6f 20 69 6e 74 6f 20 61 20 6e 65 77 |le go into a new|
00002020 20 66 72 61 6d 65 20 79 6f 75 0a 6e 65 65 64 20 | frame you.need |
00002030 74 6f 20 6d 61 6b 65 20 65 61 63 68 20 62 65 67 |to make each beg|
00002040 69 6e 20 77 69 74 68 20 7b 6e 65 78 74 66 72 61 |in with {nextfra|
00002050 6d 65 7d 2e 20 54 68 69 73 20 63 61 6e 20 62 65 |me}. This can be|
00002060 20 61 63 68 69 65 76 65 64 20 62 79 20 70 6c 61 | achieved by pla|
00002070 63 69 6e 67 0a 74 68 65 20 73 63 72 69 70 74 20 |cing.the script |
00002080 63 6f 6d 6d 61 6e 64 20 21 49 4d 50 52 45 53 53 |command !IMPRESS|
00002090 49 4f 4e 20 7b 6e 65 78 74 66 72 61 6d 65 7d 20 |ION {nextframe} |
000020a0 62 65 66 6f 72 65 20 74 68 65 20 66 69 72 73 74 |before the first|
000020b0 20 21 51 55 45 52 59 2e 20 59 6f 75 20 64 6f 0a | !QUERY. You do.|
000020c0 6e 6f 74 2c 20 68 6f 77 65 76 65 72 2c 20 77 61 |not, however, wa|
000020d0 6e 74 20 7b 6e 65 78 74 66 72 61 6d 65 7d 20 74 |nt {nextframe} t|
000020e0 6f 20 62 65 67 69 6e 20 74 68 65 20 66 69 72 73 |o begin the firs|
000020f0 74 20 66 69 6c 65 20 63 72 65 61 74 65 64 2c 20 |t file created, |
00002100 6f 72 20 74 68 65 0a 27 49 6d 70 72 65 73 73 69 |or the.'Impressi|
00002110 6f 6e 27 20 64 6f 63 75 6d 65 6e 74 20 77 69 6c |on' document wil|
00002120 6c 20 68 61 76 65 20 61 20 62 6c 61 6e 6b 20 66 |l have a blank f|
00002130 72 61 6d 65 20 6f 6e 20 69 74 73 20 66 69 72 73 |rame on its firs|
00002140 74 20 70 61 67 65 2e 20 54 6f 20 73 75 70 70 72 |t page. To suppr|
00002150 65 73 73 0a 74 68 65 20 65 66 66 65 63 74 20 6f |ess.the effect o|
00002160 6e 20 74 68 65 20 66 69 72 73 74 20 66 69 6c 65 |n the first file|
00002170 20 75 73 65 20 74 68 65 20 66 6f 72 6d 3a 20 21 | use the form: !|
00002180 49 4d 50 52 45 53 53 49 4f 4e 20 7b 6e 65 78 74 |IMPRESSION {next|
00002190 66 72 61 6d 65 7d 20 4e 6f 74 0a 66 69 72 73 74 |frame} Not.first|
000021a0 2e 20 54 68 65 72 65 20 6d 75 73 74 20 62 65 20 |. There must be |
000021b0 61 20 73 70 61 63 65 20 62 65 74 77 65 65 6e 20 |a space between |
000021c0 74 68 65 20 27 7d 27 20 61 6e 64 20 74 68 65 20 |the '}' and the |
000021d0 27 4e 27 2c 20 62 75 74 20 74 68 65 20 27 4e 6f |'N', but the 'No|
000021e0 74 0a 66 69 72 73 74 27 20 73 74 72 69 6e 67 20 |t.first' string |
000021f0 69 73 6e 27 74 20 63 61 73 65 20 73 65 6e 73 69 |isn't case sensi|
00002200 74 69 76 65 2e 0a 0a 0a 20 0a 0a |tive.... ..|
0000220b 
.