Home » Personal collection » Acorn ADFS disks » Electron_User_Group » EUG_28.ADF » F/+Hint3
F/+Hint3
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 » Personal collection » Acorn ADFS disks » Electron_User_Group » EUG_28.ADF |
| Filename: | F/+Hint3 |
| Read OK: | ✔ |
| File size: | 10E2 bytes |
| Load address: | 2B206576 |
| Exec address: | 746E6948 |
File contents
3 Entering records
On Viewstore 1.0 it is good practice when entering record to frequently
force Viewstore to write the records to disc. This can be done by pressing
CTRL and DOWN ARROW. This will write all of the new records safely to disc
and reduce data corruption problems.
4 REPORT format file prefix
On Viewstore 1.0 different prefixes are required at different times when
using report format files. When editing report format files the format file
is treated as a database and uses the Data prefix. However, when using the
report format file in the report utility it is treated as a format file and
so uses the Format prefix.
5 Running out of room in REPORT
Report format files can grow very large which can cause memory problems when
using them in utility report. Their size can be significantly reduced by
running them through utility Convert after editing them. In convert reply
as follows:
Use select file (N,Y)? N
Field 1? * RETURN
Field 2? RETURN
Record size? +20
New filename: r.newfilename
6 Minimal space after setup
In Viewstore 1.0 it is occasionally possible for the Space field at the top
of the database display to be a small number eg 11 rather than the several
thousand bytes which it should be. This can be rectified by making an entry
eg +30 in the record size field in the database header.
7 Indexes on entering data
Remember to index by entry when entering new data. This gives faster
response tines and reduces the likelihood of index corruption on an
unexpected error like disc fault.
8 Database drive
Remember not to leave any files after the data file on the data drive. This
reduces Can't extend problems on DFS.
9 F.REPORT
Remember to copy the special format file F.REPORT from the utilities onto
your format file disc before editing report format files.
10 Selecting on blank fields
When using Select you can match a blank field by giving the criterion field
=""
11 Importing corrupt databases
If a database is corrupted for any reason, for example if you lose the end
marker or get 'Bad File' you can generally recover all or almost all of your
data by importing the database into another file. This is often much
quicker than retyping although you can, of course, refer to your backup.
12 When using ADFS with Viewstore
The error COMPACTION REQUIRED ON CHANNEL 57 can be encountered.
ADFS, if extending a file must keep the file contiguous. For example, if
there is no space after the file, it copies the file into an area where
there is more space. The free space on the disc must be larger than the
file being expanded.
SOLUTION
Copy the large file onto a blank disc. Delete the file from the main disc.
Compact the disc. Copy the file back. It should now expand OK - BUT in an
application such as this it is very sensible if largest files kept on a disc
on their own.
13 SELECT syntax
Remember to use brackets and delimiters in select criteria. For example:
rrp/VAT=number and =10000
is unlikely to have the desired effect. You should enter:
("rrp/VAT"=number) and (""=10000)
to be completely ambiguous.
14 Sort memory
Before running utility select to sort a file on the Model B remember to
enter mode 6 or mode 7 to give the greatest available memory for the sort.
15 Highlighting part lines in REPORT headers
To highlight part of a line in a report header do the following. Type the
header line into the report and insert a single @ character at each point
you want the highlighting to vary. Then in the field list enter a comment
specifier for each @ and succeed the comment specifier with the highlight
codes. For example:
Type Half1 Field list
H Ordinary@Bold@Ordinary 333,@1,333,@1
C Press RETURN
When Viewstore reaches the first @ it sends the first three highlight 3s to
the printer driver which will switch on emboldening. It then replaces the
first @ by comment 1. The user is prompted to press RETURN for the first
comment which will fill the comment with spaces (one in this case). The
word underlined will then be printed in bold before the emboldening is
switched off and another blank comment is printed.
00000000 0d 33 20 20 45 6e 74 65 72 69 6e 67 20 72 65 63 |.3 Entering rec|
00000010 6f 72 64 73 0d 0d 4f 6e 20 56 69 65 77 73 74 6f |ords..On Viewsto|
00000020 72 65 20 31 2e 30 20 69 74 20 69 73 20 67 6f 6f |re 1.0 it is goo|
00000030 64 20 70 72 61 63 74 69 63 65 20 77 68 65 6e 20 |d practice when |
00000040 65 6e 74 65 72 69 6e 67 20 72 65 63 6f 72 64 20 |entering record |
00000050 74 6f 20 66 72 65 71 75 65 6e 74 6c 79 0d 66 6f |to frequently.fo|
00000060 72 63 65 20 56 69 65 77 73 74 6f 72 65 20 74 6f |rce Viewstore to|
00000070 20 77 72 69 74 65 20 74 68 65 20 72 65 63 6f 72 | write the recor|
00000080 64 73 20 74 6f 20 64 69 73 63 2e 20 20 54 68 69 |ds to disc. Thi|
00000090 73 20 63 61 6e 20 62 65 20 64 6f 6e 65 20 62 79 |s can be done by|
000000a0 20 70 72 65 73 73 69 6e 67 0d 43 54 52 4c 20 61 | pressing.CTRL a|
000000b0 6e 64 20 44 4f 57 4e 20 41 52 52 4f 57 2e 20 20 |nd DOWN ARROW. |
000000c0 54 68 69 73 20 77 69 6c 6c 20 77 72 69 74 65 20 |This will write |
000000d0 61 6c 6c 20 6f 66 20 74 68 65 20 6e 65 77 20 72 |all of the new r|
000000e0 65 63 6f 72 64 73 20 73 61 66 65 6c 79 20 74 6f |ecords safely to|
000000f0 20 64 69 73 63 0d 61 6e 64 20 72 65 64 75 63 65 | disc.and reduce|
00000100 20 64 61 74 61 20 63 6f 72 72 75 70 74 69 6f 6e | data corruption|
00000110 20 70 72 6f 62 6c 65 6d 73 2e 0d 0d 0d 34 20 20 | problems....4 |
00000120 52 45 50 4f 52 54 20 66 6f 72 6d 61 74 20 66 69 |REPORT format fi|
00000130 6c 65 20 70 72 65 66 69 78 0d 0d 4f 6e 20 56 69 |le prefix..On Vi|
00000140 65 77 73 74 6f 72 65 20 31 2e 30 20 64 69 66 66 |ewstore 1.0 diff|
00000150 65 72 65 6e 74 20 70 72 65 66 69 78 65 73 20 61 |erent prefixes a|
00000160 72 65 20 72 65 71 75 69 72 65 64 20 61 74 20 64 |re required at d|
00000170 69 66 66 65 72 65 6e 74 20 74 69 6d 65 73 20 77 |ifferent times w|
00000180 68 65 6e 0d 75 73 69 6e 67 20 72 65 70 6f 72 74 |hen.using report|
00000190 20 66 6f 72 6d 61 74 20 66 69 6c 65 73 2e 20 20 | format files. |
000001a0 57 68 65 6e 20 65 64 69 74 69 6e 67 20 72 65 70 |When editing rep|
000001b0 6f 72 74 20 66 6f 72 6d 61 74 20 66 69 6c 65 73 |ort format files|
000001c0 20 74 68 65 20 66 6f 72 6d 61 74 20 66 69 6c 65 | the format file|
000001d0 0d 69 73 20 74 72 65 61 74 65 64 20 61 73 20 61 |.is treated as a|
000001e0 20 64 61 74 61 62 61 73 65 20 61 6e 64 20 75 73 | database and us|
000001f0 65 73 20 74 68 65 20 44 61 74 61 20 70 72 65 66 |es the Data pref|
00000200 69 78 2e 20 20 48 6f 77 65 76 65 72 2c 20 77 68 |ix. However, wh|
00000210 65 6e 20 75 73 69 6e 67 20 74 68 65 0d 72 65 70 |en using the.rep|
00000220 6f 72 74 20 66 6f 72 6d 61 74 20 66 69 6c 65 20 |ort format file |
00000230 69 6e 20 74 68 65 20 72 65 70 6f 72 74 20 75 74 |in the report ut|
00000240 69 6c 69 74 79 20 69 74 20 69 73 20 74 72 65 61 |ility it is trea|
00000250 74 65 64 20 61 73 20 61 20 66 6f 72 6d 61 74 20 |ted as a format |
00000260 66 69 6c 65 20 61 6e 64 0d 73 6f 20 75 73 65 73 |file and.so uses|
00000270 20 74 68 65 20 46 6f 72 6d 61 74 20 70 72 65 66 | the Format pref|
00000280 69 78 2e 0d 20 20 20 20 20 20 20 20 20 20 20 20 |ix.. |
00000290 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
000002a0 20 0d 0d 35 20 20 52 75 6e 6e 69 6e 67 20 6f 75 | ..5 Running ou|
000002b0 74 20 6f 66 20 72 6f 6f 6d 20 69 6e 20 52 45 50 |t of room in REP|
000002c0 4f 52 54 0d 0d 52 65 70 6f 72 74 20 66 6f 72 6d |ORT..Report form|
000002d0 61 74 20 66 69 6c 65 73 20 63 61 6e 20 67 72 6f |at files can gro|
000002e0 77 20 76 65 72 79 20 6c 61 72 67 65 20 77 68 69 |w very large whi|
000002f0 63 68 20 63 61 6e 20 63 61 75 73 65 20 6d 65 6d |ch can cause mem|
00000300 6f 72 79 20 70 72 6f 62 6c 65 6d 73 20 77 68 65 |ory problems whe|
00000310 6e 0d 75 73 69 6e 67 20 74 68 65 6d 20 69 6e 20 |n.using them in |
00000320 75 74 69 6c 69 74 79 20 72 65 70 6f 72 74 2e 20 |utility report. |
00000330 20 54 68 65 69 72 20 73 69 7a 65 20 63 61 6e 20 | Their size can |
00000340 62 65 20 73 69 67 6e 69 66 69 63 61 6e 74 6c 79 |be significantly|
00000350 20 72 65 64 75 63 65 64 20 62 79 0d 72 75 6e 6e | reduced by.runn|
00000360 69 6e 67 20 74 68 65 6d 20 74 68 72 6f 75 67 68 |ing them through|
00000370 20 75 74 69 6c 69 74 79 20 43 6f 6e 76 65 72 74 | utility Convert|
00000380 20 61 66 74 65 72 20 65 64 69 74 69 6e 67 20 74 | after editing t|
00000390 68 65 6d 2e 20 20 49 6e 20 63 6f 6e 76 65 72 74 |hem. In convert|
000003a0 20 72 65 70 6c 79 0d 61 73 20 66 6f 6c 6c 6f 77 | reply.as follow|
000003b0 73 3a 0d 0d 20 20 20 20 20 20 20 20 55 73 65 20 |s:.. Use |
000003c0 73 65 6c 65 63 74 20 66 69 6c 65 20 28 4e 2c 59 |select file (N,Y|
000003d0 29 3f 20 20 4e 0d 20 20 20 20 20 20 20 20 46 69 |)? N. Fi|
000003e0 65 6c 64 20 31 3f 20 20 2a 20 52 45 54 55 52 4e |eld 1? * RETURN|
000003f0 0d 20 20 20 20 20 20 20 20 46 69 65 6c 64 20 32 |. Field 2|
00000400 3f 20 20 52 45 54 55 52 4e 0d 20 20 20 20 20 20 |? RETURN. |
00000410 20 20 52 65 63 6f 72 64 20 73 69 7a 65 3f 20 20 | Record size? |
00000420 2b 32 30 0d 20 20 20 20 20 20 20 20 4e 65 77 20 |+20. New |
00000430 66 69 6c 65 6e 61 6d 65 3a 20 20 72 2e 6e 65 77 |filename: r.new|
00000440 66 69 6c 65 6e 61 6d 65 0d 0d 0d 36 20 20 4d 69 |filename...6 Mi|
00000450 6e 69 6d 61 6c 20 73 70 61 63 65 20 61 66 74 65 |nimal space afte|
00000460 72 20 73 65 74 75 70 0d 0d 49 6e 20 56 69 65 77 |r setup..In View|
00000470 73 74 6f 72 65 20 31 2e 30 20 69 74 20 69 73 20 |store 1.0 it is |
00000480 6f 63 63 61 73 69 6f 6e 61 6c 6c 79 20 70 6f 73 |occasionally pos|
00000490 73 69 62 6c 65 20 66 6f 72 20 74 68 65 20 53 70 |sible for the Sp|
000004a0 61 63 65 20 66 69 65 6c 64 20 61 74 20 74 68 65 |ace field at the|
000004b0 20 74 6f 70 0d 6f 66 20 74 68 65 20 64 61 74 61 | top.of the data|
000004c0 62 61 73 65 20 64 69 73 70 6c 61 79 20 74 6f 20 |base display to |
000004d0 62 65 20 61 20 73 6d 61 6c 6c 20 6e 75 6d 62 65 |be a small numbe|
000004e0 72 20 65 67 20 31 31 20 72 61 74 68 65 72 20 74 |r eg 11 rather t|
000004f0 68 61 6e 20 74 68 65 20 73 65 76 65 72 61 6c 0d |han the several.|
00000500 74 68 6f 75 73 61 6e 64 20 62 79 74 65 73 20 77 |thousand bytes w|
00000510 68 69 63 68 20 69 74 20 73 68 6f 75 6c 64 20 62 |hich it should b|
00000520 65 2e 20 20 54 68 69 73 20 63 61 6e 20 62 65 20 |e. This can be |
00000530 72 65 63 74 69 66 69 65 64 20 62 79 20 6d 61 6b |rectified by mak|
00000540 69 6e 67 20 61 6e 20 65 6e 74 72 79 0d 65 67 20 |ing an entry.eg |
00000550 2b 33 30 20 69 6e 20 74 68 65 20 72 65 63 6f 72 |+30 in the recor|
00000560 64 20 73 69 7a 65 20 66 69 65 6c 64 20 69 6e 20 |d size field in |
00000570 74 68 65 20 64 61 74 61 62 61 73 65 20 68 65 61 |the database hea|
00000580 64 65 72 2e 0d 0d 0d 37 20 20 49 6e 64 65 78 65 |der....7 Indexe|
00000590 73 20 6f 6e 20 65 6e 74 65 72 69 6e 67 20 64 61 |s on entering da|
000005a0 74 61 0d 0d 52 65 6d 65 6d 62 65 72 20 74 6f 20 |ta..Remember to |
000005b0 69 6e 64 65 78 20 62 79 20 65 6e 74 72 79 20 77 |index by entry w|
000005c0 68 65 6e 20 65 6e 74 65 72 69 6e 67 20 6e 65 77 |hen entering new|
000005d0 20 64 61 74 61 2e 20 20 54 68 69 73 20 67 69 76 | data. This giv|
000005e0 65 73 20 66 61 73 74 65 72 0d 72 65 73 70 6f 6e |es faster.respon|
000005f0 73 65 20 74 69 6e 65 73 20 61 6e 64 20 72 65 64 |se tines and red|
00000600 75 63 65 73 20 74 68 65 20 6c 69 6b 65 6c 69 68 |uces the likelih|
00000610 6f 6f 64 20 6f 66 20 69 6e 64 65 78 20 63 6f 72 |ood of index cor|
00000620 72 75 70 74 69 6f 6e 20 6f 6e 20 61 6e 0d 75 6e |ruption on an.un|
00000630 65 78 70 65 63 74 65 64 20 65 72 72 6f 72 20 6c |expected error l|
00000640 69 6b 65 20 64 69 73 63 20 66 61 75 6c 74 2e 0d |ike disc fault..|
00000650 0d 0d 38 20 20 44 61 74 61 62 61 73 65 20 64 72 |..8 Database dr|
00000660 69 76 65 0d 0d 52 65 6d 65 6d 62 65 72 20 6e 6f |ive..Remember no|
00000670 74 20 74 6f 20 6c 65 61 76 65 20 61 6e 79 20 66 |t to leave any f|
00000680 69 6c 65 73 20 61 66 74 65 72 20 74 68 65 20 64 |iles after the d|
00000690 61 74 61 20 66 69 6c 65 20 6f 6e 20 74 68 65 20 |ata file on the |
000006a0 64 61 74 61 20 64 72 69 76 65 2e 20 20 54 68 69 |data drive. Thi|
000006b0 73 0d 72 65 64 75 63 65 73 20 43 61 6e 27 74 20 |s.reduces Can't |
000006c0 65 78 74 65 6e 64 20 70 72 6f 62 6c 65 6d 73 20 |extend problems |
000006d0 6f 6e 20 44 46 53 2e 0d 0d 0d 39 20 20 46 2e 52 |on DFS....9 F.R|
000006e0 45 50 4f 52 54 0d 0d 52 65 6d 65 6d 62 65 72 20 |EPORT..Remember |
000006f0 74 6f 20 63 6f 70 79 20 74 68 65 20 73 70 65 63 |to copy the spec|
00000700 69 61 6c 20 66 6f 72 6d 61 74 20 66 69 6c 65 20 |ial format file |
00000710 46 2e 52 45 50 4f 52 54 20 66 72 6f 6d 20 74 68 |F.REPORT from th|
00000720 65 20 75 74 69 6c 69 74 69 65 73 20 6f 6e 74 6f |e utilities onto|
00000730 0d 79 6f 75 72 20 66 6f 72 6d 61 74 20 66 69 6c |.your format fil|
00000740 65 20 64 69 73 63 20 62 65 66 6f 72 65 20 65 64 |e disc before ed|
00000750 69 74 69 6e 67 20 72 65 70 6f 72 74 20 66 6f 72 |iting report for|
00000760 6d 61 74 20 66 69 6c 65 73 2e 0d 0d 0d 31 30 20 |mat files....10 |
00000770 20 53 65 6c 65 63 74 69 6e 67 20 6f 6e 20 62 6c | Selecting on bl|
00000780 61 6e 6b 20 66 69 65 6c 64 73 0d 0d 57 68 65 6e |ank fields..When|
00000790 20 75 73 69 6e 67 20 53 65 6c 65 63 74 20 79 6f | using Select yo|
000007a0 75 20 63 61 6e 20 6d 61 74 63 68 20 61 20 62 6c |u can match a bl|
000007b0 61 6e 6b 20 66 69 65 6c 64 20 62 79 20 67 69 76 |ank field by giv|
000007c0 69 6e 67 20 74 68 65 20 63 72 69 74 65 72 69 6f |ing the criterio|
000007d0 6e 20 66 69 65 6c 64 0d 3d 22 22 0d 0d 0d 31 31 |n field.=""...11|
000007e0 20 20 49 6d 70 6f 72 74 69 6e 67 20 63 6f 72 72 | Importing corr|
000007f0 75 70 74 20 64 61 74 61 62 61 73 65 73 0d 0d 49 |upt databases..I|
00000800 66 20 61 20 64 61 74 61 62 61 73 65 20 69 73 20 |f a database is |
00000810 63 6f 72 72 75 70 74 65 64 20 66 6f 72 20 61 6e |corrupted for an|
00000820 79 20 72 65 61 73 6f 6e 2c 20 66 6f 72 20 65 78 |y reason, for ex|
00000830 61 6d 70 6c 65 20 69 66 20 79 6f 75 20 6c 6f 73 |ample if you los|
00000840 65 20 74 68 65 20 65 6e 64 0d 6d 61 72 6b 65 72 |e the end.marker|
00000850 20 6f 72 20 67 65 74 20 27 42 61 64 20 46 69 6c | or get 'Bad Fil|
00000860 65 27 20 79 6f 75 20 63 61 6e 20 67 65 6e 65 72 |e' you can gener|
00000870 61 6c 6c 79 20 72 65 63 6f 76 65 72 20 61 6c 6c |ally recover all|
00000880 20 6f 72 20 61 6c 6d 6f 73 74 20 61 6c 6c 20 6f | or almost all o|
00000890 66 20 79 6f 75 72 0d 64 61 74 61 20 62 79 20 69 |f your.data by i|
000008a0 6d 70 6f 72 74 69 6e 67 20 74 68 65 20 64 61 74 |mporting the dat|
000008b0 61 62 61 73 65 20 69 6e 74 6f 20 61 6e 6f 74 68 |abase into anoth|
000008c0 65 72 20 66 69 6c 65 2e 20 20 54 68 69 73 20 69 |er file. This i|
000008d0 73 20 6f 66 74 65 6e 20 6d 75 63 68 0d 71 75 69 |s often much.qui|
000008e0 63 6b 65 72 20 74 68 61 6e 20 72 65 74 79 70 69 |cker than retypi|
000008f0 6e 67 20 61 6c 74 68 6f 75 67 68 20 79 6f 75 20 |ng although you |
00000900 63 61 6e 2c 20 6f 66 20 63 6f 75 72 73 65 2c 20 |can, of course, |
00000910 72 65 66 65 72 20 74 6f 20 79 6f 75 72 20 62 61 |refer to your ba|
00000920 63 6b 75 70 2e 0d 0d 0d 31 32 20 20 57 68 65 6e |ckup....12 When|
00000930 20 75 73 69 6e 67 20 41 44 46 53 20 77 69 74 68 | using ADFS with|
00000940 20 56 69 65 77 73 74 6f 72 65 0d 0d 54 68 65 20 | Viewstore..The |
00000950 65 72 72 6f 72 20 43 4f 4d 50 41 43 54 49 4f 4e |error COMPACTION|
00000960 20 52 45 51 55 49 52 45 44 20 4f 4e 20 43 48 41 | REQUIRED ON CHA|
00000970 4e 4e 45 4c 20 35 37 20 63 61 6e 20 62 65 20 65 |NNEL 57 can be e|
00000980 6e 63 6f 75 6e 74 65 72 65 64 2e 0d 0d 41 44 46 |ncountered...ADF|
00000990 53 2c 20 69 66 20 65 78 74 65 6e 64 69 6e 67 20 |S, if extending |
000009a0 61 20 66 69 6c 65 20 6d 75 73 74 20 6b 65 65 70 |a file must keep|
000009b0 20 74 68 65 20 66 69 6c 65 20 63 6f 6e 74 69 67 | the file contig|
000009c0 75 6f 75 73 2e 20 20 46 6f 72 20 65 78 61 6d 70 |uous. For examp|
000009d0 6c 65 2c 20 69 66 0d 74 68 65 72 65 20 69 73 20 |le, if.there is |
000009e0 6e 6f 20 73 70 61 63 65 20 61 66 74 65 72 20 74 |no space after t|
000009f0 68 65 20 66 69 6c 65 2c 20 69 74 20 63 6f 70 69 |he file, it copi|
00000a00 65 73 20 74 68 65 20 66 69 6c 65 20 69 6e 74 6f |es the file into|
00000a10 20 61 6e 20 61 72 65 61 20 77 68 65 72 65 0d 74 | an area where.t|
00000a20 68 65 72 65 20 69 73 20 6d 6f 72 65 20 73 70 61 |here is more spa|
00000a30 63 65 2e 20 20 54 68 65 20 66 72 65 65 20 73 70 |ce. The free sp|
00000a40 61 63 65 20 6f 6e 20 74 68 65 20 64 69 73 63 20 |ace on the disc |
00000a50 6d 75 73 74 20 62 65 20 6c 61 72 67 65 72 20 74 |must be larger t|
00000a60 68 61 6e 20 74 68 65 0d 66 69 6c 65 20 62 65 69 |han the.file bei|
00000a70 6e 67 20 65 78 70 61 6e 64 65 64 2e 0d 0d 53 4f |ng expanded...SO|
00000a80 4c 55 54 49 4f 4e 0d 0d 43 6f 70 79 20 74 68 65 |LUTION..Copy the|
00000a90 20 6c 61 72 67 65 20 66 69 6c 65 20 6f 6e 74 6f | large file onto|
00000aa0 20 61 20 62 6c 61 6e 6b 20 64 69 73 63 2e 20 20 | a blank disc. |
00000ab0 44 65 6c 65 74 65 20 74 68 65 20 66 69 6c 65 20 |Delete the file |
00000ac0 66 72 6f 6d 20 74 68 65 20 6d 61 69 6e 20 64 69 |from the main di|
00000ad0 73 63 2e 20 0d 43 6f 6d 70 61 63 74 20 74 68 65 |sc. .Compact the|
00000ae0 20 64 69 73 63 2e 20 20 43 6f 70 79 20 74 68 65 | disc. Copy the|
00000af0 20 66 69 6c 65 20 62 61 63 6b 2e 20 20 49 74 20 | file back. It |
00000b00 73 68 6f 75 6c 64 20 6e 6f 77 20 65 78 70 61 6e |should now expan|
00000b10 64 20 4f 4b 20 2d 20 42 55 54 20 69 6e 20 61 6e |d OK - BUT in an|
00000b20 0d 61 70 70 6c 69 63 61 74 69 6f 6e 20 73 75 63 |.application suc|
00000b30 68 20 61 73 20 74 68 69 73 20 69 74 20 69 73 20 |h as this it is |
00000b40 76 65 72 79 20 73 65 6e 73 69 62 6c 65 20 69 66 |very sensible if|
00000b50 20 6c 61 72 67 65 73 74 20 66 69 6c 65 73 20 6b | largest files k|
00000b60 65 70 74 20 6f 6e 20 61 20 64 69 73 63 0d 6f 6e |ept on a disc.on|
00000b70 20 74 68 65 69 72 20 6f 77 6e 2e 20 0d 0d 0d 31 | their own. ...1|
00000b80 33 20 20 53 45 4c 45 43 54 20 73 79 6e 74 61 78 |3 SELECT syntax|
00000b90 0d 0d 52 65 6d 65 6d 62 65 72 20 74 6f 20 75 73 |..Remember to us|
00000ba0 65 20 62 72 61 63 6b 65 74 73 20 61 6e 64 20 64 |e brackets and d|
00000bb0 65 6c 69 6d 69 74 65 72 73 20 69 6e 20 73 65 6c |elimiters in sel|
00000bc0 65 63 74 20 63 72 69 74 65 72 69 61 2e 20 20 46 |ect criteria. F|
00000bd0 6f 72 20 65 78 61 6d 70 6c 65 3a 0d 0d 20 20 20 |or example:.. |
00000be0 20 20 20 20 20 72 72 70 2f 56 41 54 3d 6e 75 6d | rrp/VAT=num|
00000bf0 62 65 72 20 61 6e 64 20 3d 31 30 30 30 30 0d 0d |ber and =10000..|
00000c00 69 73 20 75 6e 6c 69 6b 65 6c 79 20 74 6f 20 68 |is unlikely to h|
00000c10 61 76 65 20 74 68 65 20 64 65 73 69 72 65 64 20 |ave the desired |
00000c20 65 66 66 65 63 74 2e 20 20 59 6f 75 20 73 68 6f |effect. You sho|
00000c30 75 6c 64 20 65 6e 74 65 72 3a 0d 0d 20 20 20 20 |uld enter:.. |
00000c40 20 20 20 20 28 22 72 72 70 2f 56 41 54 22 3d 6e | ("rrp/VAT"=n|
00000c50 75 6d 62 65 72 29 20 61 6e 64 20 28 22 22 3d 31 |umber) and (""=1|
00000c60 30 30 30 30 29 0d 0d 74 6f 20 62 65 20 63 6f 6d |0000)..to be com|
00000c70 70 6c 65 74 65 6c 79 20 61 6d 62 69 67 75 6f 75 |pletely ambiguou|
00000c80 73 2e 0d 0d 0d 31 34 20 20 53 6f 72 74 20 6d 65 |s....14 Sort me|
00000c90 6d 6f 72 79 0d 0d 42 65 66 6f 72 65 20 72 75 6e |mory..Before run|
00000ca0 6e 69 6e 67 20 75 74 69 6c 69 74 79 20 73 65 6c |ning utility sel|
00000cb0 65 63 74 20 74 6f 20 73 6f 72 74 20 61 20 66 69 |ect to sort a fi|
00000cc0 6c 65 20 6f 6e 20 74 68 65 20 4d 6f 64 65 6c 20 |le on the Model |
00000cd0 42 20 72 65 6d 65 6d 62 65 72 20 74 6f 0d 65 6e |B remember to.en|
00000ce0 74 65 72 20 6d 6f 64 65 20 36 20 6f 72 20 6d 6f |ter mode 6 or mo|
00000cf0 64 65 20 37 20 74 6f 20 67 69 76 65 20 74 68 65 |de 7 to give the|
00000d00 20 67 72 65 61 74 65 73 74 20 61 76 61 69 6c 61 | greatest availa|
00000d10 62 6c 65 20 6d 65 6d 6f 72 79 20 66 6f 72 20 74 |ble memory for t|
00000d20 68 65 20 73 6f 72 74 2e 0d 0d 0d 31 35 20 20 48 |he sort....15 H|
00000d30 69 67 68 6c 69 67 68 74 69 6e 67 20 70 61 72 74 |ighlighting part|
00000d40 20 6c 69 6e 65 73 20 69 6e 20 52 45 50 4f 52 54 | lines in REPORT|
00000d50 20 68 65 61 64 65 72 73 0d 0d 54 6f 20 68 69 67 | headers..To hig|
00000d60 68 6c 69 67 68 74 20 70 61 72 74 20 6f 66 20 61 |hlight part of a|
00000d70 20 6c 69 6e 65 20 69 6e 20 61 20 72 65 70 6f 72 | line in a repor|
00000d80 74 20 68 65 61 64 65 72 20 64 6f 20 74 68 65 20 |t header do the |
00000d90 66 6f 6c 6c 6f 77 69 6e 67 2e 20 20 54 79 70 65 |following. Type|
00000da0 20 74 68 65 0d 68 65 61 64 65 72 20 6c 69 6e 65 | the.header line|
00000db0 20 69 6e 74 6f 20 74 68 65 20 72 65 70 6f 72 74 | into the report|
00000dc0 20 61 6e 64 20 69 6e 73 65 72 74 20 61 20 73 69 | and insert a si|
00000dd0 6e 67 6c 65 20 40 20 63 68 61 72 61 63 74 65 72 |ngle @ character|
00000de0 20 61 74 20 65 61 63 68 20 70 6f 69 6e 74 0d 79 | at each point.y|
00000df0 6f 75 20 77 61 6e 74 20 74 68 65 20 68 69 67 68 |ou want the high|
00000e00 6c 69 67 68 74 69 6e 67 20 74 6f 20 76 61 72 79 |lighting to vary|
00000e10 2e 20 20 54 68 65 6e 20 69 6e 20 74 68 65 20 66 |. Then in the f|
00000e20 69 65 6c 64 20 6c 69 73 74 20 65 6e 74 65 72 20 |ield list enter |
00000e30 61 20 63 6f 6d 6d 65 6e 74 0d 73 70 65 63 69 66 |a comment.specif|
00000e40 69 65 72 20 66 6f 72 20 65 61 63 68 20 40 20 61 |ier for each @ a|
00000e50 6e 64 20 73 75 63 63 65 65 64 20 74 68 65 20 63 |nd succeed the c|
00000e60 6f 6d 6d 65 6e 74 20 73 70 65 63 69 66 69 65 72 |omment specifier|
00000e70 20 77 69 74 68 20 74 68 65 20 68 69 67 68 6c 69 | with the highli|
00000e80 67 68 74 0d 63 6f 64 65 73 2e 20 20 46 6f 72 20 |ght.codes. For |
00000e90 65 78 61 6d 70 6c 65 3a 0d 0d 20 20 20 20 20 20 |example:.. |
00000ea0 20 20 54 79 70 65 20 20 20 20 20 20 20 20 20 20 | Type |
00000eb0 20 20 48 61 6c 66 31 20 20 20 20 20 20 20 20 20 | Half1 |
00000ec0 20 20 20 20 20 20 20 20 20 20 46 69 65 6c 64 20 | Field |
00000ed0 6c 69 73 74 0d 20 20 20 20 20 20 20 20 48 20 20 |list. H |
00000ee0 20 20 20 20 20 20 20 20 20 20 20 20 20 4f 72 64 | Ord|
00000ef0 69 6e 61 72 79 40 42 6f 6c 64 40 4f 72 64 69 6e |inary@Bold@Ordin|
00000f00 61 72 79 20 20 33 33 33 2c 40 31 2c 33 33 33 2c |ary 333,@1,333,|
00000f10 40 31 0d 20 20 20 20 20 20 20 20 43 20 20 20 20 |@1. C |
00000f20 20 20 20 20 20 20 20 20 20 20 20 50 72 65 73 73 | Press|
00000f30 20 52 45 54 55 52 4e 20 20 20 20 0d 0d 57 68 65 | RETURN ..Whe|
00000f40 6e 20 56 69 65 77 73 74 6f 72 65 20 72 65 61 63 |n Viewstore reac|
00000f50 68 65 73 20 74 68 65 20 66 69 72 73 74 20 40 20 |hes the first @ |
00000f60 69 74 20 73 65 6e 64 73 20 74 68 65 20 66 69 72 |it sends the fir|
00000f70 73 74 20 74 68 72 65 65 20 68 69 67 68 6c 69 67 |st three highlig|
00000f80 68 74 20 33 73 20 74 6f 0d 74 68 65 20 70 72 69 |ht 3s to.the pri|
00000f90 6e 74 65 72 20 64 72 69 76 65 72 20 77 68 69 63 |nter driver whic|
00000fa0 68 20 77 69 6c 6c 20 73 77 69 74 63 68 20 6f 6e |h will switch on|
00000fb0 20 65 6d 62 6f 6c 64 65 6e 69 6e 67 2e 20 20 49 | emboldening. I|
00000fc0 74 20 74 68 65 6e 20 72 65 70 6c 61 63 65 73 20 |t then replaces |
00000fd0 74 68 65 0d 66 69 72 73 74 20 40 20 62 79 20 63 |the.first @ by c|
00000fe0 6f 6d 6d 65 6e 74 20 31 2e 20 20 54 68 65 20 75 |omment 1. The u|
00000ff0 73 65 72 20 69 73 20 70 72 6f 6d 70 74 65 64 20 |ser is prompted |
00001000 74 6f 20 70 72 65 73 73 20 52 45 54 55 52 4e 20 |to press RETURN |
00001010 66 6f 72 20 74 68 65 20 66 69 72 73 74 0d 63 6f |for the first.co|
00001020 6d 6d 65 6e 74 20 77 68 69 63 68 20 77 69 6c 6c |mment which will|
00001030 20 66 69 6c 6c 20 74 68 65 20 63 6f 6d 6d 65 6e | fill the commen|
00001040 74 20 77 69 74 68 20 73 70 61 63 65 73 20 28 6f |t with spaces (o|
00001050 6e 65 20 69 6e 20 74 68 69 73 20 63 61 73 65 29 |ne in this case)|
00001060 2e 20 20 54 68 65 0d 77 6f 72 64 20 75 6e 64 65 |. The.word unde|
00001070 72 6c 69 6e 65 64 20 77 69 6c 6c 20 74 68 65 6e |rlined will then|
00001080 20 62 65 20 70 72 69 6e 74 65 64 20 69 6e 20 62 | be printed in b|
00001090 6f 6c 64 20 62 65 66 6f 72 65 20 74 68 65 20 65 |old before the e|
000010a0 6d 62 6f 6c 64 65 6e 69 6e 67 20 69 73 0d 73 77 |mboldening is.sw|
000010b0 69 74 63 68 65 64 20 6f 66 66 20 61 6e 64 20 61 |itched off and a|
000010c0 6e 6f 74 68 65 72 20 62 6c 61 6e 6b 20 63 6f 6d |nother blank com|
000010d0 6d 65 6e 74 20 69 73 20 70 72 69 6e 74 65 64 2e |ment is printed.|
000010e0 0d 0d |..|
000010e2 
F/+Hint3.m0
F/+Hint3.m1
F/+Hint3.m2
F/+Hint3.m4
F/+Hint3.m5
.