Home » Personal collection » Acorn ADFS disks » Electron_User_Group » EUG_28.ADF » F/+hint4
F/+hint4
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/+hint4 |
| Read OK: | ✔ |
| File size: | 1433 bytes |
| Load address: | 2B206576 |
| Exec address: | 746E6968 |
File contents
16 Editing REPORT format files
Report format files can be edited in the View word processor. Read the
report format file into View and insert a ruler at the top of the file which
has no right margin and tab stops set wide enough to align the field in
columns. Now edit the file. Be careful to keep the fields separated by the
correct number of tabs and make sure that the lines do not exceed 132
characters. Before saving the file delete the ruler at the top. Finally
import the file back as a database, field separator being 9 and record
separator being 13.
17 Final REPORT editing
Reports can be edited by spooling the report to disc, reading into the View
word processor, editing and printing from View.
18 Case sensitivity in Watford DFS
Some versions of Watford DFS do not allow a mixture of cases in
directory names. It is necessary to ensure all filenames specifications are
in the correct case. In particular utilities should be renamed from
directory "u" to "U".
19 Filesizes and Utilities
The Viewstore utilities all assume maximum filesizes of 65536 when
performing calculations on filesizes. In particular giving a size n of more
than 65536 bytes to reserve in the setup utility caused Viewstore to reserve
n modulo 65536 bytes. So specifying 70000 bytes will actually reserve 4464
bytes. This does not limit either the size of your database file or the
sizes of your index files.
20 Bytes to reserve - Load time tradeoff
On loading a database Viewstore quickly loads the format file, opens up the
data file and reads it from the end of the file backwards to the end of the
data marker. If there is a lot of space at the end of the file this may
take a little time. Consequently unless you need space reserved at the end
of the data file (if you are using a single DFS surface) it is best to
reserve 0 bytes when setting up the database.
21 Writing utilities
It is possible to write extra utilities for use with Viewstore.
However, this should only be attempted by experienced 6502 programmers who
either require a utility for special use or who are planning to exploit the
utilities commercially. Acorn have no copyright restrictions on others
selling their own Viewstore utilities.
22 Copyright
All of the code and documentation supplied with Viewstore is subject to
English copyright law. You are not allowed to copy the Viewstore EPROM
without explicit permission from Acorn. You may copy the Viewstore utility
disc for your own use.
23 This is a BASIC utility that enables you to append one database to
another in Viewstore
The simple format of Viewstore database files enables simple manipulation by
programs written in BBC BASIC. For example, the following program appends
one database file to another.
NOTE: the field order within records of both databases should be the same
for sensible results.
10 INPUT "File 1",file1$
20 INPUT "File 2",file2$
30 one=OPENUP(file1$) :REM BASIC 1 users should use OPENIN
40 two=OPENIN(file2$)
50 REPEAT UNTIL BGET#one=1
60 PTR#1=PTR#One-1
70 REPEAT
80 byte=BGET#two
90 BPUT#one,byte
100 UNTIL byte=1
110 CLOSE#one
120 CLOSE#2
24 Obtaining Reports from a database (This is an example)
Whether or not you have prepared a Select File when running the SELECT
utility, you can produce a simple report on screen of the first 80
characters of each record, or if you choose the printer option, you can
specify the width of the paper, page length and whether or not single sheets
are required. The simple report will give all the records or a selection,
depending on whether a Select File is used. If you follow the Report
Utility routine through without using a Report Format File (answer N to the
prompt "User report format file N,Y?") you will see that this 'simple'
report is not particularly suited to the chosen layout of your data in th
name and address file. The key factor here is that the records are shown in
the spreadsheet format, and are thus limited to the width of the screen
(usually a max of 80 characters), or the specified paper width if you choose
the printer option, so once again you are not going to see all the data from
the database, there are some sorts of database for which this type of
report is perfect (such as accounting applications) where you might use a
spreadsheet style display for the database and limit the width to 80
characters anyway, in which case this form of reporting is perfectly
satisfactory.
The above is suggested as a guideline and we hope that this will enable you
to setup a report specifically for your printing requirements.
25 Printing labels from a Viewstore database using label utility
The Label Utility enables you to extract information from a database for
printing labels. First load the database from which you want to print the
labels and ensure that the computer has been prepared for printing. You
will notice on the screen after loading the database:
Editing D.(database filename)
Format F.(format filename)
Then type: UTILITY LABEL (press return)
00000000 0d 31 36 20 20 45 64 69 74 69 6e 67 20 52 45 50 |.16 Editing REP| 00000010 4f 52 54 20 66 6f 72 6d 61 74 20 66 69 6c 65 73 |ORT format files| 00000020 0d 0d 52 65 70 6f 72 74 20 66 6f 72 6d 61 74 20 |..Report format | 00000030 66 69 6c 65 73 20 63 61 6e 20 62 65 20 65 64 69 |files can be edi| 00000040 74 65 64 20 69 6e 20 74 68 65 20 56 69 65 77 20 |ted in the View | 00000050 77 6f 72 64 20 70 72 6f 63 65 73 73 6f 72 2e 20 |word processor. | 00000060 20 52 65 61 64 20 74 68 65 0d 72 65 70 6f 72 74 | Read the.report| 00000070 20 66 6f 72 6d 61 74 20 66 69 6c 65 20 69 6e 74 | format file int| 00000080 6f 20 56 69 65 77 20 61 6e 64 20 69 6e 73 65 72 |o View and inser| 00000090 74 20 61 20 72 75 6c 65 72 20 61 74 20 74 68 65 |t a ruler at the| 000000a0 20 74 6f 70 20 6f 66 20 74 68 65 20 66 69 6c 65 | top of the file| 000000b0 20 77 68 69 63 68 0d 68 61 73 20 6e 6f 20 72 69 | which.has no ri| 000000c0 67 68 74 20 6d 61 72 67 69 6e 20 61 6e 64 20 74 |ght margin and t| 000000d0 61 62 20 73 74 6f 70 73 20 73 65 74 20 77 69 64 |ab stops set wid| 000000e0 65 20 65 6e 6f 75 67 68 20 74 6f 20 61 6c 69 67 |e enough to alig| 000000f0 6e 20 74 68 65 20 66 69 65 6c 64 20 69 6e 0d 63 |n the field in.c| 00000100 6f 6c 75 6d 6e 73 2e 20 20 4e 6f 77 20 65 64 69 |olumns. Now edi| 00000110 74 20 74 68 65 20 66 69 6c 65 2e 20 20 42 65 20 |t the file. Be | 00000120 63 61 72 65 66 75 6c 20 74 6f 20 6b 65 65 70 20 |careful to keep | 00000130 74 68 65 20 66 69 65 6c 64 73 20 73 65 70 61 72 |the fields separ| 00000140 61 74 65 64 20 62 79 20 74 68 65 0d 63 6f 72 72 |ated by the.corr| 00000150 65 63 74 20 6e 75 6d 62 65 72 20 6f 66 20 74 61 |ect number of ta| 00000160 62 73 20 61 6e 64 20 6d 61 6b 65 20 73 75 72 65 |bs and make sure| 00000170 20 74 68 61 74 20 74 68 65 20 6c 69 6e 65 73 20 | that the lines | 00000180 64 6f 20 6e 6f 74 20 65 78 63 65 65 64 20 31 33 |do not exceed 13| 00000190 32 0d 63 68 61 72 61 63 74 65 72 73 2e 20 20 42 |2.characters. B| 000001a0 65 66 6f 72 65 20 73 61 76 69 6e 67 20 74 68 65 |efore saving the| 000001b0 20 66 69 6c 65 20 64 65 6c 65 74 65 20 74 68 65 | file delete the| 000001c0 20 72 75 6c 65 72 20 61 74 20 74 68 65 20 74 6f | ruler at the to| 000001d0 70 2e 20 20 46 69 6e 61 6c 6c 79 0d 69 6d 70 6f |p. Finally.impo| 000001e0 72 74 20 74 68 65 20 66 69 6c 65 20 62 61 63 6b |rt the file back| 000001f0 20 61 73 20 61 20 64 61 74 61 62 61 73 65 2c 20 | as a database, | 00000200 66 69 65 6c 64 20 73 65 70 61 72 61 74 6f 72 20 |field separator | 00000210 62 65 69 6e 67 20 39 20 61 6e 64 20 72 65 63 6f |being 9 and reco| 00000220 72 64 0d 73 65 70 61 72 61 74 6f 72 20 62 65 69 |rd.separator bei| 00000230 6e 67 20 31 33 2e 0d 0d 0d 31 37 20 20 46 69 6e |ng 13....17 Fin| 00000240 61 6c 20 52 45 50 4f 52 54 20 65 64 69 74 69 6e |al REPORT editin| 00000250 67 0d 0d 52 65 70 6f 72 74 73 20 63 61 6e 20 62 |g..Reports can b| 00000260 65 20 65 64 69 74 65 64 20 62 79 20 73 70 6f 6f |e edited by spoo| 00000270 6c 69 6e 67 20 74 68 65 20 72 65 70 6f 72 74 20 |ling the report | 00000280 74 6f 20 64 69 73 63 2c 20 72 65 61 64 69 6e 67 |to disc, reading| 00000290 20 69 6e 74 6f 20 74 68 65 20 56 69 65 77 0d 77 | into the View.w| 000002a0 6f 72 64 20 70 72 6f 63 65 73 73 6f 72 2c 20 65 |ord processor, e| 000002b0 64 69 74 69 6e 67 20 61 6e 64 20 70 72 69 6e 74 |diting and print| 000002c0 69 6e 67 20 66 72 6f 6d 20 56 69 65 77 2e 0d 0d |ing from View...| 000002d0 0d 31 38 20 20 43 61 73 65 20 73 65 6e 73 69 74 |.18 Case sensit| 000002e0 69 76 69 74 79 20 69 6e 20 57 61 74 66 6f 72 64 |ivity in Watford| 000002f0 20 44 46 53 0d 0d 53 6f 6d 65 20 76 65 72 73 69 | DFS..Some versi| 00000300 6f 6e 73 20 6f 66 20 57 61 74 66 6f 72 64 20 44 |ons of Watford D| 00000310 46 53 20 64 6f 20 6e 6f 74 20 61 6c 6c 6f 77 20 |FS do not allow | 00000320 61 20 6d 69 78 74 75 72 65 20 6f 66 20 63 61 73 |a mixture of cas| 00000330 65 73 20 69 6e 0d 64 69 72 65 63 74 6f 72 79 20 |es in.directory | 00000340 6e 61 6d 65 73 2e 20 20 49 74 20 69 73 20 6e 65 |names. It is ne| 00000350 63 65 73 73 61 72 79 20 74 6f 20 65 6e 73 75 72 |cessary to ensur| 00000360 65 20 61 6c 6c 20 66 69 6c 65 6e 61 6d 65 73 20 |e all filenames | 00000370 73 70 65 63 69 66 69 63 61 74 69 6f 6e 73 20 61 |specifications a| 00000380 72 65 0d 69 6e 20 74 68 65 20 63 6f 72 72 65 63 |re.in the correc| 00000390 74 20 63 61 73 65 2e 20 20 49 6e 20 70 61 72 74 |t case. In part| 000003a0 69 63 75 6c 61 72 20 75 74 69 6c 69 74 69 65 73 |icular utilities| 000003b0 20 73 68 6f 75 6c 64 20 62 65 20 72 65 6e 61 6d | should be renam| 000003c0 65 64 20 66 72 6f 6d 0d 64 69 72 65 63 74 6f 72 |ed from.director| 000003d0 79 20 22 75 22 20 74 6f 20 22 55 22 2e 0d 0d 31 |y "u" to "U"...1| 000003e0 39 20 20 46 69 6c 65 73 69 7a 65 73 20 61 6e 64 |9 Filesizes and| 000003f0 20 55 74 69 6c 69 74 69 65 73 0d 0d 54 68 65 20 | Utilities..The | 00000400 56 69 65 77 73 74 6f 72 65 20 75 74 69 6c 69 74 |Viewstore utilit| 00000410 69 65 73 20 61 6c 6c 20 61 73 73 75 6d 65 20 6d |ies all assume m| 00000420 61 78 69 6d 75 6d 20 66 69 6c 65 73 69 7a 65 73 |aximum filesizes| 00000430 20 6f 66 20 36 35 35 33 36 20 77 68 65 6e 0d 70 | of 65536 when.p| 00000440 65 72 66 6f 72 6d 69 6e 67 20 63 61 6c 63 75 6c |erforming calcul| 00000450 61 74 69 6f 6e 73 20 6f 6e 20 66 69 6c 65 73 69 |ations on filesi| 00000460 7a 65 73 2e 20 20 49 6e 20 70 61 72 74 69 63 75 |zes. In particu| 00000470 6c 61 72 20 67 69 76 69 6e 67 20 61 20 73 69 7a |lar giving a siz| 00000480 65 20 6e 20 6f 66 20 6d 6f 72 65 0d 74 68 61 6e |e n of more.than| 00000490 20 36 35 35 33 36 20 62 79 74 65 73 20 74 6f 20 | 65536 bytes to | 000004a0 72 65 73 65 72 76 65 20 69 6e 20 74 68 65 20 73 |reserve in the s| 000004b0 65 74 75 70 20 75 74 69 6c 69 74 79 20 63 61 75 |etup utility cau| 000004c0 73 65 64 20 56 69 65 77 73 74 6f 72 65 20 74 6f |sed Viewstore to| 000004d0 20 72 65 73 65 72 76 65 0d 6e 20 6d 6f 64 75 6c | reserve.n modul| 000004e0 6f 20 36 35 35 33 36 20 62 79 74 65 73 2e 20 20 |o 65536 bytes. | 000004f0 53 6f 20 73 70 65 63 69 66 79 69 6e 67 20 37 30 |So specifying 70| 00000500 30 30 30 20 62 79 74 65 73 20 77 69 6c 6c 20 61 |000 bytes will a| 00000510 63 74 75 61 6c 6c 79 20 72 65 73 65 72 76 65 20 |ctually reserve | 00000520 34 34 36 34 0d 62 79 74 65 73 2e 20 20 54 68 69 |4464.bytes. Thi| 00000530 73 20 64 6f 65 73 20 6e 6f 74 20 6c 69 6d 69 74 |s does not limit| 00000540 20 65 69 74 68 65 72 20 74 68 65 20 73 69 7a 65 | either the size| 00000550 20 6f 66 20 79 6f 75 72 20 64 61 74 61 62 61 73 | of your databas| 00000560 65 20 66 69 6c 65 20 6f 72 20 74 68 65 0d 73 69 |e file or the.si| 00000570 7a 65 73 20 6f 66 20 79 6f 75 72 20 69 6e 64 65 |zes of your inde| 00000580 78 20 66 69 6c 65 73 2e 0d 0d 0d 32 30 20 20 42 |x files....20 B| 00000590 79 74 65 73 20 74 6f 20 72 65 73 65 72 76 65 20 |ytes to reserve | 000005a0 2d 20 4c 6f 61 64 20 74 69 6d 65 20 74 72 61 64 |- Load time trad| 000005b0 65 6f 66 66 0d 0d 4f 6e 20 6c 6f 61 64 69 6e 67 |eoff..On loading| 000005c0 20 61 20 64 61 74 61 62 61 73 65 20 56 69 65 77 | a database View| 000005d0 73 74 6f 72 65 20 71 75 69 63 6b 6c 79 20 6c 6f |store quickly lo| 000005e0 61 64 73 20 74 68 65 20 66 6f 72 6d 61 74 20 66 |ads the format f| 000005f0 69 6c 65 2c 20 6f 70 65 6e 73 20 75 70 20 74 68 |ile, opens up th| 00000600 65 0d 64 61 74 61 20 66 69 6c 65 20 61 6e 64 20 |e.data file and | 00000610 72 65 61 64 73 20 69 74 20 66 72 6f 6d 20 74 68 |reads it from th| 00000620 65 20 65 6e 64 20 6f 66 20 74 68 65 20 66 69 6c |e end of the fil| 00000630 65 20 62 61 63 6b 77 61 72 64 73 20 74 6f 20 74 |e backwards to t| 00000640 68 65 20 65 6e 64 20 6f 66 20 74 68 65 0d 64 61 |he end of the.da| 00000650 74 61 20 6d 61 72 6b 65 72 2e 20 20 49 66 20 74 |ta marker. If t| 00000660 68 65 72 65 20 69 73 20 61 20 6c 6f 74 20 6f 66 |here is a lot of| 00000670 20 73 70 61 63 65 20 61 74 20 74 68 65 20 65 6e | space at the en| 00000680 64 20 6f 66 20 74 68 65 20 66 69 6c 65 20 74 68 |d of the file th| 00000690 69 73 20 6d 61 79 0d 74 61 6b 65 20 61 20 6c 69 |is may.take a li| 000006a0 74 74 6c 65 20 74 69 6d 65 2e 20 20 43 6f 6e 73 |ttle time. Cons| 000006b0 65 71 75 65 6e 74 6c 79 20 75 6e 6c 65 73 73 20 |equently unless | 000006c0 79 6f 75 20 6e 65 65 64 20 73 70 61 63 65 20 72 |you need space r| 000006d0 65 73 65 72 76 65 64 20 61 74 20 74 68 65 20 65 |eserved at the e| 000006e0 6e 64 0d 6f 66 20 74 68 65 20 64 61 74 61 20 66 |nd.of the data f| 000006f0 69 6c 65 20 28 69 66 20 79 6f 75 20 61 72 65 20 |ile (if you are | 00000700 75 73 69 6e 67 20 61 20 73 69 6e 67 6c 65 20 44 |using a single D| 00000710 46 53 20 73 75 72 66 61 63 65 29 20 69 74 20 69 |FS surface) it i| 00000720 73 20 62 65 73 74 20 74 6f 0d 72 65 73 65 72 76 |s best to.reserv| 00000730 65 20 30 20 62 79 74 65 73 20 77 68 65 6e 20 73 |e 0 bytes when s| 00000740 65 74 74 69 6e 67 20 75 70 20 74 68 65 20 64 61 |etting up the da| 00000750 74 61 62 61 73 65 2e 0d 0d 0d 32 31 20 20 57 72 |tabase....21 Wr| 00000760 69 74 69 6e 67 20 75 74 69 6c 69 74 69 65 73 0d |iting utilities.| 00000770 0d 49 74 20 69 73 20 70 6f 73 73 69 62 6c 65 20 |.It is possible | 00000780 74 6f 20 77 72 69 74 65 20 65 78 74 72 61 20 75 |to write extra u| 00000790 74 69 6c 69 74 69 65 73 20 66 6f 72 20 75 73 65 |tilities for use| 000007a0 20 77 69 74 68 20 56 69 65 77 73 74 6f 72 65 2e | with Viewstore.| 000007b0 20 0d 48 6f 77 65 76 65 72 2c 20 74 68 69 73 20 | .However, this | 000007c0 73 68 6f 75 6c 64 20 6f 6e 6c 79 20 62 65 20 61 |should only be a| 000007d0 74 74 65 6d 70 74 65 64 20 62 79 20 65 78 70 65 |ttempted by expe| 000007e0 72 69 65 6e 63 65 64 20 36 35 30 32 20 70 72 6f |rienced 6502 pro| 000007f0 67 72 61 6d 6d 65 72 73 20 77 68 6f 0d 65 69 74 |grammers who.eit| 00000800 68 65 72 20 72 65 71 75 69 72 65 20 61 20 75 74 |her require a ut| 00000810 69 6c 69 74 79 20 66 6f 72 20 73 70 65 63 69 61 |ility for specia| 00000820 6c 20 75 73 65 20 6f 72 20 77 68 6f 20 61 72 65 |l use or who are| 00000830 20 70 6c 61 6e 6e 69 6e 67 20 74 6f 20 65 78 70 | planning to exp| 00000840 6c 6f 69 74 20 74 68 65 0d 75 74 69 6c 69 74 69 |loit the.utiliti| 00000850 65 73 20 63 6f 6d 6d 65 72 63 69 61 6c 6c 79 2e |es commercially.| 00000860 20 20 41 63 6f 72 6e 20 68 61 76 65 20 6e 6f 20 | Acorn have no | 00000870 63 6f 70 79 72 69 67 68 74 20 72 65 73 74 72 69 |copyright restri| 00000880 63 74 69 6f 6e 73 20 6f 6e 20 6f 74 68 65 72 73 |ctions on others| 00000890 0d 73 65 6c 6c 69 6e 67 20 74 68 65 69 72 20 6f |.selling their o| 000008a0 77 6e 20 56 69 65 77 73 74 6f 72 65 20 75 74 69 |wn Viewstore uti| 000008b0 6c 69 74 69 65 73 2e 0d 0d 0d 32 32 20 20 43 6f |lities....22 Co| 000008c0 70 79 72 69 67 68 74 0d 0d 41 6c 6c 20 6f 66 20 |pyright..All of | 000008d0 74 68 65 20 63 6f 64 65 20 61 6e 64 20 64 6f 63 |the code and doc| 000008e0 75 6d 65 6e 74 61 74 69 6f 6e 20 73 75 70 70 6c |umentation suppl| 000008f0 69 65 64 20 77 69 74 68 20 56 69 65 77 73 74 6f |ied with Viewsto| 00000900 72 65 20 69 73 20 73 75 62 6a 65 63 74 20 74 6f |re is subject to| 00000910 0d 45 6e 67 6c 69 73 68 20 63 6f 70 79 72 69 67 |.English copyrig| 00000920 68 74 20 6c 61 77 2e 20 20 59 6f 75 20 61 72 65 |ht law. You are| 00000930 20 6e 6f 74 20 61 6c 6c 6f 77 65 64 20 74 6f 20 | not allowed to | 00000940 63 6f 70 79 20 74 68 65 20 56 69 65 77 73 74 6f |copy the Viewsto| 00000950 72 65 20 20 45 50 52 4f 4d 0d 77 69 74 68 6f 75 |re EPROM.withou| 00000960 74 20 65 78 70 6c 69 63 69 74 20 70 65 72 6d 69 |t explicit permi| 00000970 73 73 69 6f 6e 20 66 72 6f 6d 20 41 63 6f 72 6e |ssion from Acorn| 00000980 2e 20 20 59 6f 75 20 6d 61 79 20 63 6f 70 79 20 |. You may copy | 00000990 74 68 65 20 56 69 65 77 73 74 6f 72 65 20 75 74 |the Viewstore ut| 000009a0 69 6c 69 74 79 0d 64 69 73 63 20 66 6f 72 20 79 |ility.disc for y| 000009b0 6f 75 72 20 6f 77 6e 20 75 73 65 2e 0d 0d 0d 32 |our own use....2| 000009c0 33 20 20 54 68 69 73 20 69 73 20 61 20 42 41 53 |3 This is a BAS| 000009d0 49 43 20 75 74 69 6c 69 74 79 20 74 68 61 74 20 |IC utility that | 000009e0 65 6e 61 62 6c 65 73 20 79 6f 75 20 74 6f 20 61 |enables you to a| 000009f0 70 70 65 6e 64 20 6f 6e 65 20 64 61 74 61 62 61 |ppend one databa| 00000a00 73 65 20 74 6f 0d 61 6e 6f 74 68 65 72 20 69 6e |se to.another in| 00000a10 20 56 69 65 77 73 74 6f 72 65 0d 0d 54 68 65 20 | Viewstore..The | 00000a20 73 69 6d 70 6c 65 20 66 6f 72 6d 61 74 20 6f 66 |simple format of| 00000a30 20 56 69 65 77 73 74 6f 72 65 20 64 61 74 61 62 | Viewstore datab| 00000a40 61 73 65 20 66 69 6c 65 73 20 65 6e 61 62 6c 65 |ase files enable| 00000a50 73 20 73 69 6d 70 6c 65 20 6d 61 6e 69 70 75 6c |s simple manipul| 00000a60 61 74 69 6f 6e 20 62 79 0d 70 72 6f 67 72 61 6d |ation by.program| 00000a70 73 20 77 72 69 74 74 65 6e 20 69 6e 20 42 42 43 |s written in BBC| 00000a80 20 42 41 53 49 43 2e 20 20 20 46 6f 72 20 65 78 | BASIC. For ex| 00000a90 61 6d 70 6c 65 2c 20 74 68 65 20 66 6f 6c 6c 6f |ample, the follo| 00000aa0 77 69 6e 67 20 20 70 72 6f 67 72 61 6d 20 61 70 |wing program ap| 00000ab0 70 65 6e 64 73 0d 6f 6e 65 20 64 61 74 61 62 61 |pends.one databa| 00000ac0 73 65 20 66 69 6c 65 20 74 6f 20 61 6e 6f 74 68 |se file to anoth| 00000ad0 65 72 2e 0d 0d 4e 4f 54 45 3a 20 20 74 68 65 20 |er...NOTE: the | 00000ae0 66 69 65 6c 64 20 6f 72 64 65 72 20 77 69 74 68 |field order with| 00000af0 69 6e 20 72 65 63 6f 72 64 73 20 6f 66 20 62 6f |in records of bo| 00000b00 74 68 20 64 61 74 61 62 61 73 65 73 20 73 68 6f |th databases sho| 00000b10 75 6c 64 20 62 65 20 74 68 65 20 73 61 6d 65 0d |uld be the same.| 00000b20 66 6f 72 20 73 65 6e 73 69 62 6c 65 20 72 65 73 |for sensible res| 00000b30 75 6c 74 73 2e 0d 0d 20 20 20 20 20 20 20 20 31 |ults... 1| 00000b40 30 20 20 20 49 4e 50 55 54 20 22 46 69 6c 65 20 |0 INPUT "File | 00000b50 31 22 2c 66 69 6c 65 31 24 0d 20 20 20 20 20 20 |1",file1$. | 00000b60 20 20 32 30 20 20 20 49 4e 50 55 54 20 22 46 69 | 20 INPUT "Fi| 00000b70 6c 65 20 32 22 2c 66 69 6c 65 32 24 0d 20 20 20 |le 2",file2$. | 00000b80 20 20 20 20 20 33 30 20 20 20 6f 6e 65 3d 4f 50 | 30 one=OP| 00000b90 45 4e 55 50 28 66 69 6c 65 31 24 29 20 3a 52 45 |ENUP(file1$) :RE| 00000ba0 4d 20 42 41 53 49 43 20 31 20 75 73 65 72 73 20 |M BASIC 1 users | 00000bb0 73 68 6f 75 6c 64 20 75 73 65 20 4f 50 45 4e 49 |should use OPENI| 00000bc0 4e 0d 20 20 20 20 20 20 20 20 34 30 20 20 20 74 |N. 40 t| 00000bd0 77 6f 3d 4f 50 45 4e 49 4e 28 66 69 6c 65 32 24 |wo=OPENIN(file2$| 00000be0 29 0d 20 20 20 20 20 20 20 20 35 30 20 20 20 52 |). 50 R| 00000bf0 45 50 45 41 54 20 55 4e 54 49 4c 20 42 47 45 54 |EPEAT UNTIL BGET| 00000c00 23 6f 6e 65 3d 31 0d 20 20 20 20 20 20 20 20 36 |#one=1. 6| 00000c10 30 20 20 20 50 54 52 23 31 3d 50 54 52 23 4f 6e |0 PTR#1=PTR#On| 00000c20 65 2d 31 0d 20 20 20 20 20 20 20 20 37 30 20 20 |e-1. 70 | 00000c30 20 52 45 50 45 41 54 0d 20 20 20 20 20 20 20 20 | REPEAT. | 00000c40 38 30 20 20 20 62 79 74 65 3d 42 47 45 54 23 74 |80 byte=BGET#t| 00000c50 77 6f 0d 20 20 20 20 20 20 20 20 39 30 20 20 20 |wo. 90 | 00000c60 42 50 55 54 23 6f 6e 65 2c 62 79 74 65 0d 20 20 |BPUT#one,byte. | 00000c70 20 20 20 20 20 20 31 30 30 20 20 55 4e 54 49 4c | 100 UNTIL| 00000c80 20 62 79 74 65 3d 31 0d 20 20 20 20 20 20 20 20 | byte=1. | 00000c90 31 31 30 20 20 43 4c 4f 53 45 23 6f 6e 65 0d 20 |110 CLOSE#one. | 00000ca0 20 20 20 20 20 20 20 31 32 30 20 20 43 4c 4f 53 | 120 CLOS| 00000cb0 45 23 32 0d 0d 0d 32 34 20 20 4f 62 74 61 69 6e |E#2...24 Obtain| 00000cc0 69 6e 67 20 52 65 70 6f 72 74 73 20 66 72 6f 6d |ing Reports from| 00000cd0 20 61 20 64 61 74 61 62 61 73 65 20 28 54 68 69 | a database (Thi| 00000ce0 73 20 69 73 20 61 6e 20 65 78 61 6d 70 6c 65 29 |s is an example)| 00000cf0 0d 0d 57 68 65 74 68 65 72 20 6f 72 20 6e 6f 74 |..Whether or not| 00000d00 20 79 6f 75 20 68 61 76 65 20 70 72 65 70 61 72 | you have prepar| 00000d10 65 64 20 61 20 53 65 6c 65 63 74 20 46 69 6c 65 |ed a Select File| 00000d20 20 77 68 65 6e 20 72 75 6e 6e 69 6e 67 20 74 68 | when running th| 00000d30 65 20 53 45 4c 45 43 54 0d 75 74 69 6c 69 74 79 |e SELECT.utility| 00000d40 2c 20 79 6f 75 20 63 61 6e 20 70 72 6f 64 75 63 |, you can produc| 00000d50 65 20 61 20 73 69 6d 70 6c 65 20 72 65 70 6f 72 |e a simple repor| 00000d60 74 20 6f 6e 20 73 63 72 65 65 6e 20 6f 66 20 74 |t on screen of t| 00000d70 68 65 20 66 69 72 73 74 20 38 30 0d 63 68 61 72 |he first 80.char| 00000d80 61 63 74 65 72 73 20 6f 66 20 65 61 63 68 20 72 |acters of each r| 00000d90 65 63 6f 72 64 2c 20 6f 72 20 69 66 20 79 6f 75 |ecord, or if you| 00000da0 20 63 68 6f 6f 73 65 20 74 68 65 20 70 72 69 6e | choose the prin| 00000db0 74 65 72 20 6f 70 74 69 6f 6e 2c 20 79 6f 75 20 |ter option, you | 00000dc0 63 61 6e 0d 73 70 65 63 69 66 79 20 74 68 65 20 |can.specify the | 00000dd0 77 69 64 74 68 20 6f 66 20 74 68 65 20 70 61 70 |width of the pap| 00000de0 65 72 2c 20 70 61 67 65 20 6c 65 6e 67 74 68 20 |er, page length | 00000df0 61 6e 64 20 77 68 65 74 68 65 72 20 6f 72 20 6e |and whether or n| 00000e00 6f 74 20 73 69 6e 67 6c 65 20 73 68 65 65 74 73 |ot single sheets| 00000e10 0d 61 72 65 20 72 65 71 75 69 72 65 64 2e 20 20 |.are required. | 00000e20 54 68 65 20 73 69 6d 70 6c 65 20 72 65 70 6f 72 |The simple repor| 00000e30 74 20 77 69 6c 6c 20 67 69 76 65 20 61 6c 6c 20 |t will give all | 00000e40 74 68 65 20 72 65 63 6f 72 64 73 20 6f 72 20 61 |the records or a| 00000e50 20 73 65 6c 65 63 74 69 6f 6e 2c 0d 64 65 70 65 | selection,.depe| 00000e60 6e 64 69 6e 67 20 6f 6e 20 77 68 65 74 68 65 72 |nding on whether| 00000e70 20 61 20 53 65 6c 65 63 74 20 46 69 6c 65 20 69 | a Select File i| 00000e80 73 20 75 73 65 64 2e 20 20 49 66 20 79 6f 75 20 |s used. If you | 00000e90 66 6f 6c 6c 6f 77 20 74 68 65 20 52 65 70 6f 72 |follow the Repor| 00000ea0 74 0d 55 74 69 6c 69 74 79 20 72 6f 75 74 69 6e |t.Utility routin| 00000eb0 65 20 74 68 72 6f 75 67 68 20 77 69 74 68 6f 75 |e through withou| 00000ec0 74 20 75 73 69 6e 67 20 61 20 52 65 70 6f 72 74 |t using a Report| 00000ed0 20 46 6f 72 6d 61 74 20 46 69 6c 65 20 28 61 6e | Format File (an| 00000ee0 73 77 65 72 20 4e 20 74 6f 20 74 68 65 0d 70 72 |swer N to the.pr| 00000ef0 6f 6d 70 74 20 22 55 73 65 72 20 72 65 70 6f 72 |ompt "User repor| 00000f00 74 20 66 6f 72 6d 61 74 20 66 69 6c 65 20 4e 2c |t format file N,| 00000f10 59 3f 22 29 20 79 6f 75 20 77 69 6c 6c 20 73 65 |Y?") you will se| 00000f20 65 20 74 68 61 74 20 74 68 69 73 20 27 73 69 6d |e that this 'sim| 00000f30 70 6c 65 27 0d 72 65 70 6f 72 74 20 69 73 20 6e |ple'.report is n| 00000f40 6f 74 20 70 61 72 74 69 63 75 6c 61 72 6c 79 20 |ot particularly | 00000f50 73 75 69 74 65 64 20 74 6f 20 74 68 65 20 63 68 |suited to the ch| 00000f60 6f 73 65 6e 20 6c 61 79 6f 75 74 20 6f 66 20 79 |osen layout of y| 00000f70 6f 75 72 20 64 61 74 61 20 69 6e 20 74 68 0d 6e |our data in th.n| 00000f80 61 6d 65 20 61 6e 64 20 61 64 64 72 65 73 73 20 |ame and address | 00000f90 66 69 6c 65 2e 20 20 54 68 65 20 6b 65 79 20 66 |file. The key f| 00000fa0 61 63 74 6f 72 20 68 65 72 65 20 69 73 20 74 68 |actor here is th| 00000fb0 61 74 20 74 68 65 20 72 65 63 6f 72 64 73 20 61 |at the records a| 00000fc0 72 65 20 73 68 6f 77 6e 20 69 6e 0d 74 68 65 20 |re shown in.the | 00000fd0 73 70 72 65 61 64 73 68 65 65 74 20 66 6f 72 6d |spreadsheet form| 00000fe0 61 74 2c 20 61 6e 64 20 61 72 65 20 74 68 75 73 |at, and are thus| 00000ff0 20 6c 69 6d 69 74 65 64 20 74 6f 20 74 68 65 20 | limited to the | 00001000 77 69 64 74 68 20 6f 66 20 74 68 65 20 73 63 72 |width of the scr| 00001010 65 65 6e 0d 28 75 73 75 61 6c 6c 79 20 61 20 6d |een.(usually a m| 00001020 61 78 20 6f 66 20 38 30 20 63 68 61 72 61 63 74 |ax of 80 charact| 00001030 65 72 73 29 2c 20 6f 72 20 74 68 65 20 73 70 65 |ers), or the spe| 00001040 63 69 66 69 65 64 20 70 61 70 65 72 20 77 69 64 |cified paper wid| 00001050 74 68 20 69 66 20 79 6f 75 20 63 68 6f 6f 73 65 |th if you choose| 00001060 0d 74 68 65 20 70 72 69 6e 74 65 72 20 6f 70 74 |.the printer opt| 00001070 69 6f 6e 2c 20 73 6f 20 6f 6e 63 65 20 61 67 61 |ion, so once aga| 00001080 69 6e 20 79 6f 75 20 61 72 65 20 6e 6f 74 20 67 |in you are not g| 00001090 6f 69 6e 67 20 74 6f 20 73 65 65 20 61 6c 6c 20 |oing to see all | 000010a0 74 68 65 20 64 61 74 61 20 66 72 6f 6d 0d 74 68 |the data from.th| 000010b0 65 20 64 61 74 61 62 61 73 65 2c 20 20 74 68 65 |e database, the| 000010c0 72 65 20 61 72 65 20 73 6f 6d 65 20 73 6f 72 74 |re are some sort| 000010d0 73 20 6f 66 20 64 61 74 61 62 61 73 65 20 66 6f |s of database fo| 000010e0 72 20 77 68 69 63 68 20 74 68 69 73 20 74 79 70 |r which this typ| 000010f0 65 20 6f 66 0d 72 65 70 6f 72 74 20 69 73 20 70 |e of.report is p| 00001100 65 72 66 65 63 74 20 28 73 75 63 68 20 61 73 20 |erfect (such as | 00001110 61 63 63 6f 75 6e 74 69 6e 67 20 61 70 70 6c 69 |accounting appli| 00001120 63 61 74 69 6f 6e 73 29 20 77 68 65 72 65 20 79 |cations) where y| 00001130 6f 75 20 6d 69 67 68 74 20 75 73 65 20 61 0d 73 |ou might use a.s| 00001140 70 72 65 61 64 73 68 65 65 74 20 73 74 79 6c 65 |preadsheet style| 00001150 20 64 69 73 70 6c 61 79 20 66 6f 72 20 74 68 65 | display for the| 00001160 20 64 61 74 61 62 61 73 65 20 61 6e 64 20 6c 69 | database and li| 00001170 6d 69 74 20 74 68 65 20 77 69 64 74 68 20 74 6f |mit the width to| 00001180 20 38 30 0d 63 68 61 72 61 63 74 65 72 73 20 61 | 80.characters a| 00001190 6e 79 77 61 79 2c 20 69 6e 20 77 68 69 63 68 20 |nyway, in which | 000011a0 63 61 73 65 20 74 68 69 73 20 66 6f 72 6d 20 6f |case this form o| 000011b0 66 20 72 65 70 6f 72 74 69 6e 67 20 69 73 20 70 |f reporting is p| 000011c0 65 72 66 65 63 74 6c 79 0d 73 61 74 69 73 66 61 |erfectly.satisfa| 000011d0 63 74 6f 72 79 2e 0d 0d 54 68 65 20 61 62 6f 76 |ctory...The abov| 000011e0 65 20 69 73 20 73 75 67 67 65 73 74 65 64 20 61 |e is suggested a| 000011f0 73 20 61 20 67 75 69 64 65 6c 69 6e 65 20 61 6e |s a guideline an| 00001200 64 20 77 65 20 68 6f 70 65 20 74 68 61 74 20 74 |d we hope that t| 00001210 68 69 73 20 77 69 6c 6c 20 65 6e 61 62 6c 65 20 |his will enable | 00001220 79 6f 75 0d 74 6f 20 73 65 74 75 70 20 61 20 72 |you.to setup a r| 00001230 65 70 6f 72 74 20 73 70 65 63 69 66 69 63 61 6c |eport specifical| 00001240 6c 79 20 66 6f 72 20 79 6f 75 72 20 70 72 69 6e |ly for your prin| 00001250 74 69 6e 67 20 72 65 71 75 69 72 65 6d 65 6e 74 |ting requirement| 00001260 73 2e 0d 0d 0d 32 35 20 50 72 69 6e 74 69 6e 67 |s....25 Printing| 00001270 20 6c 61 62 65 6c 73 20 66 72 6f 6d 20 61 20 56 | labels from a V| 00001280 69 65 77 73 74 6f 72 65 20 64 61 74 61 62 61 73 |iewstore databas| 00001290 65 20 75 73 69 6e 67 20 6c 61 62 65 6c 20 75 74 |e using label ut| 000012a0 69 6c 69 74 79 0d 0d 54 68 65 20 4c 61 62 65 6c |ility..The Label| 000012b0 20 55 74 69 6c 69 74 79 20 65 6e 61 62 6c 65 73 | Utility enables| 000012c0 20 79 6f 75 20 74 6f 20 65 78 74 72 61 63 74 20 | you to extract | 000012d0 69 6e 66 6f 72 6d 61 74 69 6f 6e 20 66 72 6f 6d |information from| 000012e0 20 61 20 64 61 74 61 62 61 73 65 20 66 6f 72 0d | a database for.| 000012f0 70 72 69 6e 74 69 6e 67 20 6c 61 62 65 6c 73 2e |printing labels.| 00001300 20 20 46 69 72 73 74 20 6c 6f 61 64 20 74 68 65 | First load the| 00001310 20 64 61 74 61 62 61 73 65 20 66 72 6f 6d 20 77 | database from w| 00001320 68 69 63 68 20 79 6f 75 20 77 61 6e 74 20 74 6f |hich you want to| 00001330 20 70 72 69 6e 74 20 74 68 65 0d 6c 61 62 65 6c | print the.label| 00001340 73 20 61 6e 64 20 65 6e 73 75 72 65 20 74 68 61 |s and ensure tha| 00001350 74 20 74 68 65 20 63 6f 6d 70 75 74 65 72 20 68 |t the computer h| 00001360 61 73 20 62 65 65 6e 20 70 72 65 70 61 72 65 64 |as been prepared| 00001370 20 66 6f 72 20 70 72 69 6e 74 69 6e 67 2e 20 20 | for printing. | 00001380 59 6f 75 0d 77 69 6c 6c 20 6e 6f 74 69 63 65 20 |You.will notice | 00001390 6f 6e 20 74 68 65 20 73 63 72 65 65 6e 20 61 66 |on the screen af| 000013a0 74 65 72 20 6c 6f 61 64 69 6e 67 20 74 68 65 20 |ter loading the | 000013b0 64 61 74 61 62 61 73 65 3a 0d 0d 20 20 20 20 20 |database:.. | 000013c0 20 20 20 45 64 69 74 69 6e 67 20 44 2e 28 64 61 | Editing D.(da| 000013d0 74 61 62 61 73 65 20 66 69 6c 65 6e 61 6d 65 29 |tabase filename)| 000013e0 0d 20 20 20 20 20 20 20 20 46 6f 72 6d 61 74 20 |. Format | 000013f0 46 2e 28 66 6f 72 6d 61 74 20 66 69 6c 65 6e 61 |F.(format filena| 00001400 6d 65 29 0d 0d 54 68 65 6e 20 74 79 70 65 3a 20 |me)..Then type: | 00001410 20 20 20 20 20 55 54 49 4c 49 54 59 20 4c 41 42 | UTILITY LAB| 00001420 45 4c 20 28 70 72 65 73 73 20 72 65 74 75 72 6e |EL (press return| 00001430 29 0d 0d |)..| 00001433
F/+hint4.m0
F/+hint4.m1
F/+hint4.m2
F/+hint4.m4
F/+hint4.m5
.