Home » Archimedes archive » Archimedes World » AW-1994-04-Disc2.adf » Disk2Apr94 » !AWApr94/Goodies/PowerBase/PBaseDoc/!Beginners

!AWApr94/Goodies/PowerBase/PBaseDoc/!Beginners

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/!Beginners
Read OK:
File size: 3BC0 bytes
Load address: 0000
Exec address: 0000
File contents
                                Quick Tutorial
                                ==============

This document is intended to acquaint the new user as painlessly as possible
with the most commonly-used facilities of Powerbase. It does not explain how
to create a database from scratch (the file 'Create' does that), nor does it
delve into the many advanced features, but it does explain how to:-

        (a) Start up Powerbase and open an existing database.
        (b) Browse through the database and search for individual records.
        (d) Add new records and alter or delete existing ones.
        (d) Query the database to create simple reports.
        (e) Close the database.

The supplied sample database 'Friends' is used to illustrate most of these
activities. If you have a hard disc you should copy 'Friends' and Powerbase
itself onto it before proceeding further. It is possible to use Powerbase
from floppy discs only but some operations, such as creating reports, will
be quite slow. Unless memory is very tight therefore, users of floppy discs
are recommended to allocate at least 32K to the RAM disc and copy 'Friends'
onto it. Everything will then run much faster. Powerbase can provide
context-sensitive help via Acorn's !Help application and you are advised to
load this, resizing the help window and placing it at the top right of the
screen. Further help can be had by choosing the Help entry on Powerbase's
main menu or on the icon-bar menu.

Starting Powerbase
==================
Double-click on the Powerbase icon. After a few seconds it will appear on
the icon-bar with the words "No data" beneath it to show that no database is
open. Dragging the 'Friends' icon onto the Powerbase icon on the icon-bar
will open 'Friends' for use and the words "No data" will be replaced by the
name of the database. Double-clicking on the 'Friends' icon has the same
effect, in fact if Powerbase isn't already on the icon-bar a double-click on
'Friends' will install it for you provided that the Powerbase icon has been
seen by the filer. 

Two windows will open. One is the RECORD WINDOW and displays the first
record in the database - the one for "Badgery Peter". The other is the
KEYPAD which allows you to control the browsing, searching and editing
functions of Powerbase. The keypad is rather large and obscures quite a big
area of the record window. The most-used buttons, however, are on the top
two rows and the keypad can be moved part way off screen to get it out of
the way.

Browsing through the Records
============================
The top row of buttons on the keypad allows you to browse through the file.
If you have !Help running, as previously suggested, it will tell you what
each button does. Once you get the general idea you will find the symbols on
the buttons logical and self-explanatory. The most commonly used ones act as
follows:

(a) The arrows at the ends of the row take you to the first and last
records. You are looking at the first record now, so click (with SELECT) on
the top-right button and you will see the record for Turnip Charles. The
leftmost button takes you back to the start again.

(b) Movement through the file one record at a time is achieved using the
single arrow keys next door to the ones you have just used. Try them out,
noting the way records come up in alphabetical, or reverse alphabetical,
order.

(c) The keys with double arrows allow you to make longer jumps through the
file. The number of records skipped is shown in the writable icon between
them and has a default value of 10. Since there are only 10 records in
'Friends' these keys will have the same effect as the "first" and "last"
keys, unless you change the interval to something less. Click in the icon,
delete the 10 and enter 5 or 2, then try the double-arrow keys again.                        
Searching for a record 
====================== 
The rightmost button on the third row of the keypad shows a question mark
followed by a "record card" icon  We will call it the Search button. When
clicked with SELECT the keypad window grows an extension on the right-hand
side. This new area contains a writable icon in which to enter the key of
the record you wish to display. Suppose you want to see the record for
"Bloggs Fred". You need to enter the KEY for the record. In this database
keys are made up from the first 4 letters of the surname plus the initial.
The required key is therefore BLOGF. Enter this and either click on OK or
type <Return> and the record will be displayed. Note that the key is shown
in the window heading.

Editing the Database
====================
This part of the tutorial involves changes to the data records. Make a
working copy of the disc and put the original in a safe place. If you are
using a copy of 'Friends' on the RAM disc then the floppy disc won't be
altered, but it's still not a good idea to work with the original disc.

Modifying records
-----------------
Pointing the mouse at any field and clicking SELECT places the caret in that
field. The contents of the field may then be edited in the standard way for
RISC OS writable icons. i.e.

       CTRL U clears the field.
       DELETE removes the character to the left of the caret.
       COPY removes the character to the right of the caret.
       SHIFT/COPY deletes the word to the right of the caret.
       CTRL/COPY deletes everything from the caret to the end of the line.
       � and � move the caret left/right by one character.
       SHIFT � and SHIFT � move the caret left/right by one word.
       CRTL � and CTRL � move the caret to start and end of the field.
          
Changes made to a record cause the record to be written back to the database
whenever you display a different record or close the database. (There is a
button on the keypad called 'Force update' but you don't normally need to
use it.)

Recovering data after a mistake
-------------------------------
You will sometimes edit the wrong field by mistake and want to restore the
previous contents. Click MENU over the field. The second entry on the main
menu contains the "tag" of the field. Follow the right-pointing arrow to the
'Field' sub-menu and choose the last entry: 'Undo changes'. Similarly, if
you make a mess of a complete record and want to go back to the way it was
you can choose 'Undo changes' from the main menu.

It is important to realise that these 'undo' facilities will not work if you
have looked at another record before using them (or clicked on 'Force
update'). In other words you can recover data which has been altered in or
removed from the currently-displayed record only.

Adding and deleting records 
---------------------------
To add a new record you use the "add record" button which looks like a plus
sign and an index card. Clicking on this offers a blank record into which
you can type some new data. You don't have to complete all the fields, in
fact the only field into which you MUST type something is the NAME field.
This is the KEY FIELD; the one from which the key, mentioned earlier, is
derived. If you leave the key field blank then nothing will be written to
the database.

Type the name "Bodmin George", then go to the beginning of the file and
step through it record by record. You will find that your new record has
been inserted in the correct place, i.e. the sequence goes: Badgery, Bloggs,
Bodmin, Cavendish.

Now let's try deleting the record you've just added. There is a "dustbin"
button  which will do just that: but don't use it yet. Make sure that the
unwanted record is on the screen and click the button to the RIGHT of the
bin. You will now find that the record has vanished; the names run straight
from Bloggs to Cavendish, just as they did before you added Bodmin.

Wasn't that rather TOO easy? Suppose you clicked the button by mistake and
deleted an important record! Powerbase handles this very nicely. The record
hasn't really been deleted at all. To prove this, click the button above the
one you used for "deleting". The button shows a green right-pointing arrow
and a "card index" icon. There's Bodmin again! You will soon find that it
appears to be the ONLY record in the file! Don't worry; nothing has been
lost.  A Powerbase database is treated as six separate SUBFILES  numbered
0-5. When you first open the database you are looking at Subfile 0 and the
heading of the record window shows this. If you look at the heading now you
will see that it has changed to Subfile 1.

The buttons on either side of the bin carry pictures which suggest their
true functions. They do NOT delete records; they merely MOVE records from
one subfile to another. The right button moves the displayed record to the
next subfile in sequence. Thus, in the above case the "Bodmin" record has
been moved from subfile 0 to subfile 1. A record in subfile 1 would be moved
to subfile 2 and so on.  What happens when it gets to 5? The next click
shoves it into subfile 0 where it was originally. As you might have guessed,
the left button moves records in the opposite direction, i.e. from subfile 1
to 0 or from subfile 0 to 5.

What happens when you DO want to lose a record for good?  That's when you
consign it to the dustbin!  Since this button's action is more drastic than
that of the other two you are asked for confirmation before deletion occurs.

Printing Lists
==============
Before Powerbase can produce a list it must be told:

           * which FIELDS should appear on the list
           * which RECORDS should appear on the list.

Making the field selection
--------------------------
Specifying the fields you want is extremely easy. To include a field simply
point the mouse at it and click with ADJUST. The selected field will then
appear in inverse video (i.e. normally white on black). If you change your
mind about a field you can de-select it by clicking on it again with ADJUST.
The order in which the fields will appear in the printed list is the order
in which you select them. Take care with this since there is nothing on the
screen to indicate what order the fields will be in.  The fields chosen for
inclusion in a printout make up a SELECTION  which may be saved and reloaded
for future use. Just for now select the name and the first 3 fields of the
address.

Choosing which records to print
-------------------------------
Specifying which records to print is somewhat more complex, although efforts
have been made to render it as simple as possible. With the mouse pointer in
the record window click MENU. This displays the main Powerbase menu from
which you should choose Print.  A small window appears in which you can
specify the criteria which must be met by records for inclusion in the list.
If you just click OK (or type <Return>) without entering anything here you
will obtain a list of the whole database (or, more accurately, of the the
whole of the current subfile). Try this first.

When the search is complete the list will be displayed in a window. If you
point to a record in the displayed list and double-click with SELECT
Powerbase will display the chosen record in the main record window. Note
that the caret is placed in the field you were pointing to on the list. This
is very useful if you spot errors in the data whilst examining a list. A
double click on the offending item offers the record with the caret
correctly positioned for editing.

Most database queries, however, don't involve printing all the records! You
will usually need to enter a SEARCH FORMULA before clicking OK. Search
formulae can be quite complex and a more detailed treatment is given in
another document. Only a few simple examples will be shown here.

Enter the following and click OK:

                ADD2=Exeter

The report window appears showing just one record: the one for Bloggs. ADD2
is called the TAG of the field. The label which appears beside a field on
the screen is called its DESCRIPTOR and you might have expected such
labels to be used to refer to fields in search formulae. This is not done
for two reasons:

(1) Descriptors can be inconveniently long for use in this way.
(2) Fields don't necessarily have descriptors. Of the 5 address fields only
the first has a descriptor (ADDRESS). Since every data field needs a
"handle" of some sort we give each a tag, which is never more than 4
characters. Clicking MENU over a field makes its tag appear in the second
menu item.

You may have noticed that Bloggs' is not the only address in Exeter. There
is another one but with Exeter in ADDR3 rather than ADDR2. Can we print both
on the same list? Yes we can! The formula needed is:

                ADD2,ADD3=Exeter

Notice the way the alternative tags are separated by commas. We call this a
TAG LIST. A record will be printed if ANY of the tags in the tag list are
matched. The part of the search formula after the = sign is the TARGET and
here too we may specify several of them in a TARGET LIST. Try the following:

                ADD3=Exeter,Anytown

and also:       ADD2,ADD3=Exeter,Anytown

The characters we want to match don't, of course, always make up the entire
field. Can we search for PART of a field. Yes indeed! Suppose you wanted the
records for people called Peter, Fred and Jean. Enter the formula:

                NAME{Peter,Fred,Jean

and you will find that the records for Peter Badgery, Fred Bloggs and Jean
Ford are printed. The { (left curly bracket) means "contains". i.e. the name
field doesn't have to CONSIST of Peter, or Fred or Jean, but has to CONTAIN
one of these names somewhere within it.

Hard copy
---------
So far you have only displayed reports in a window. What if you want to send
them to your printer? Nothing could be easier. Load up !Printers, switch on
the printer then click MENU over the displayed report. 'Save as text' leads
to a standard 'Save' box from which you can drag the file icon to !Printers.
You could, of course, also drag it to a directory window to save it. Or you
could simply type <Return>, in which case the report would be saved with the
default name 'List' in a directory called 'PrintJobs' which is inside the
'Friends' database directory. Every Powerbase database has a 'PrintJobs'
directory to use as a general "dumping ground" for generated output. Such
directories are apt to get cluttered and need "mucking out" from time to
time.        

Closing down
============
A database may be closed down by choosing the Close database entry from the
icon bar menu. When you do so all relevant data stored in memory is saved to
disc and the database is closed. You do not have to do anything to save the
database file itself to disc since it has been there all along. Only the
current record is in memory at any one time and this is automatically
written back to disc when it has been changed in any way.

If you are going to use another database straight away just double click on
it or drag it to the Powerbase icon on the icon bar. In fact you don't even
need to close the previous database before doing this; Powerbase will do it
for you.

When working with a database on the RAM disc Powerbase will issue a warning
that the data is not secure and that you need to drag it from the RAM disc
to a floppy or hard disc before switching off.

To terminate Powerbase itself use the Quit option on the icon bar menu.



00000000  20 20 20 20 20 20 20 20  20 20 20 20 20 20 20 20  |                |
*
00000020  51 75 69 63 6b 20 54 75  74 6f 72 69 61 6c 0a 20  |Quick Tutorial. |
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 20 20 3d  |               =|
00000050  3d 3d 3d 3d 3d 3d 3d 3d  3d 3d 3d 3d 3d 0a 0a 54  |=============..T|
00000060  68 69 73 20 64 6f 63 75  6d 65 6e 74 20 69 73 20  |his document is |
00000070  69 6e 74 65 6e 64 65 64  20 74 6f 20 61 63 71 75  |intended to acqu|
00000080  61 69 6e 74 20 74 68 65  20 6e 65 77 20 75 73 65  |aint the new use|
00000090  72 20 61 73 20 70 61 69  6e 6c 65 73 73 6c 79 20  |r as painlessly |
000000a0  61 73 20 70 6f 73 73 69  62 6c 65 0a 77 69 74 68  |as possible.with|
000000b0  20 74 68 65 20 6d 6f 73  74 20 63 6f 6d 6d 6f 6e  | the most common|
000000c0  6c 79 2d 75 73 65 64 20  66 61 63 69 6c 69 74 69  |ly-used faciliti|
000000d0  65 73 20 6f 66 20 50 6f  77 65 72 62 61 73 65 2e  |es of Powerbase.|
000000e0  20 49 74 20 64 6f 65 73  20 6e 6f 74 20 65 78 70  | It does not exp|
000000f0  6c 61 69 6e 20 68 6f 77  0a 74 6f 20 63 72 65 61  |lain how.to crea|
00000100  74 65 20 61 20 64 61 74  61 62 61 73 65 20 66 72  |te a database fr|
00000110  6f 6d 20 73 63 72 61 74  63 68 20 28 74 68 65 20  |om scratch (the |
00000120  66 69 6c 65 20 27 43 72  65 61 74 65 27 20 64 6f  |file 'Create' do|
00000130  65 73 20 74 68 61 74 29  2c 20 6e 6f 72 20 64 6f  |es that), nor do|
00000140  65 73 20 69 74 0a 64 65  6c 76 65 20 69 6e 74 6f  |es it.delve into|
00000150  20 74 68 65 20 6d 61 6e  79 20 61 64 76 61 6e 63  | the many advanc|
00000160  65 64 20 66 65 61 74 75  72 65 73 2c 20 62 75 74  |ed features, but|
00000170  20 69 74 20 64 6f 65 73  20 65 78 70 6c 61 69 6e  | it does explain|
00000180  20 68 6f 77 20 74 6f 3a  2d 0a 0a 20 20 20 20 20  | how to:-..     |
00000190  20 20 20 28 61 29 20 53  74 61 72 74 20 75 70 20  |   (a) Start up |
000001a0  50 6f 77 65 72 62 61 73  65 20 61 6e 64 20 6f 70  |Powerbase and op|
000001b0  65 6e 20 61 6e 20 65 78  69 73 74 69 6e 67 20 64  |en an existing d|
000001c0  61 74 61 62 61 73 65 2e  0a 20 20 20 20 20 20 20  |atabase..       |
000001d0  20 28 62 29 20 42 72 6f  77 73 65 20 74 68 72 6f  | (b) Browse thro|
000001e0  75 67 68 20 74 68 65 20  64 61 74 61 62 61 73 65  |ugh the database|
000001f0  20 61 6e 64 20 73 65 61  72 63 68 20 66 6f 72 20  | and search for |
00000200  69 6e 64 69 76 69 64 75  61 6c 20 72 65 63 6f 72  |individual recor|
00000210  64 73 2e 0a 20 20 20 20  20 20 20 20 28 64 29 20  |ds..        (d) |
00000220  41 64 64 20 6e 65 77 20  72 65 63 6f 72 64 73 20  |Add new records |
00000230  61 6e 64 20 61 6c 74 65  72 20 6f 72 20 64 65 6c  |and alter or del|
00000240  65 74 65 20 65 78 69 73  74 69 6e 67 20 6f 6e 65  |ete existing one|
00000250  73 2e 0a 20 20 20 20 20  20 20 20 28 64 29 20 51  |s..        (d) Q|
00000260  75 65 72 79 20 74 68 65  20 64 61 74 61 62 61 73  |uery the databas|
00000270  65 20 74 6f 20 63 72 65  61 74 65 20 73 69 6d 70  |e to create simp|
00000280  6c 65 20 72 65 70 6f 72  74 73 2e 0a 20 20 20 20  |le reports..    |
00000290  20 20 20 20 28 65 29 20  43 6c 6f 73 65 20 74 68  |    (e) Close th|
000002a0  65 20 64 61 74 61 62 61  73 65 2e 0a 0a 54 68 65  |e database...The|
000002b0  20 73 75 70 70 6c 69 65  64 20 73 61 6d 70 6c 65  | supplied sample|
000002c0  20 64 61 74 61 62 61 73  65 20 27 46 72 69 65 6e  | database 'Frien|
000002d0  64 73 27 20 69 73 20 75  73 65 64 20 74 6f 20 69  |ds' is used to i|
000002e0  6c 6c 75 73 74 72 61 74  65 20 6d 6f 73 74 20 6f  |llustrate most o|
000002f0  66 20 74 68 65 73 65 0a  61 63 74 69 76 69 74 69  |f these.activiti|
00000300  65 73 2e 20 49 66 20 79  6f 75 20 68 61 76 65 20  |es. If you have |
00000310  61 20 68 61 72 64 20 64  69 73 63 20 79 6f 75 20  |a hard disc you |
00000320  73 68 6f 75 6c 64 20 63  6f 70 79 20 27 46 72 69  |should copy 'Fri|
00000330  65 6e 64 73 27 20 61 6e  64 20 50 6f 77 65 72 62  |ends' and Powerb|
00000340  61 73 65 0a 69 74 73 65  6c 66 20 6f 6e 74 6f 20  |ase.itself onto |
00000350  69 74 20 62 65 66 6f 72  65 20 70 72 6f 63 65 65  |it before procee|
00000360  64 69 6e 67 20 66 75 72  74 68 65 72 2e 20 49 74  |ding further. It|
00000370  20 69 73 20 70 6f 73 73  69 62 6c 65 20 74 6f 20  | is possible to |
00000380  75 73 65 20 50 6f 77 65  72 62 61 73 65 0a 66 72  |use Powerbase.fr|
00000390  6f 6d 20 66 6c 6f 70 70  79 20 64 69 73 63 73 20  |om floppy discs |
000003a0  6f 6e 6c 79 20 62 75 74  20 73 6f 6d 65 20 6f 70  |only but some op|
000003b0  65 72 61 74 69 6f 6e 73  2c 20 73 75 63 68 20 61  |erations, such a|
000003c0  73 20 63 72 65 61 74 69  6e 67 20 72 65 70 6f 72  |s creating repor|
000003d0  74 73 2c 20 77 69 6c 6c  0a 62 65 20 71 75 69 74  |ts, will.be quit|
000003e0  65 20 73 6c 6f 77 2e 20  55 6e 6c 65 73 73 20 6d  |e slow. Unless m|
000003f0  65 6d 6f 72 79 20 69 73  20 76 65 72 79 20 74 69  |emory is very ti|
00000400  67 68 74 20 74 68 65 72  65 66 6f 72 65 2c 20 75  |ght therefore, u|
00000410  73 65 72 73 20 6f 66 20  66 6c 6f 70 70 79 20 64  |sers of floppy d|
00000420  69 73 63 73 0a 61 72 65  20 72 65 63 6f 6d 6d 65  |iscs.are recomme|
00000430  6e 64 65 64 20 74 6f 20  61 6c 6c 6f 63 61 74 65  |nded to allocate|
00000440  20 61 74 20 6c 65 61 73  74 20 33 32 4b 20 74 6f  | at least 32K to|
00000450  20 74 68 65 20 52 41 4d  20 64 69 73 63 20 61 6e  | the RAM disc an|
00000460  64 20 63 6f 70 79 20 27  46 72 69 65 6e 64 73 27  |d copy 'Friends'|
00000470  0a 6f 6e 74 6f 20 69 74  2e 20 45 76 65 72 79 74  |.onto it. Everyt|
00000480  68 69 6e 67 20 77 69 6c  6c 20 74 68 65 6e 20 72  |hing will then r|
00000490  75 6e 20 6d 75 63 68 20  66 61 73 74 65 72 2e 20  |un much faster. |
000004a0  50 6f 77 65 72 62 61 73  65 20 63 61 6e 20 70 72  |Powerbase can pr|
000004b0  6f 76 69 64 65 0a 63 6f  6e 74 65 78 74 2d 73 65  |ovide.context-se|
000004c0  6e 73 69 74 69 76 65 20  68 65 6c 70 20 76 69 61  |nsitive help via|
000004d0  20 41 63 6f 72 6e 27 73  20 21 48 65 6c 70 20 61  | Acorn's !Help a|
000004e0  70 70 6c 69 63 61 74 69  6f 6e 20 61 6e 64 20 79  |pplication and y|
000004f0  6f 75 20 61 72 65 20 61  64 76 69 73 65 64 20 74  |ou are advised t|
00000500  6f 0a 6c 6f 61 64 20 74  68 69 73 2c 20 72 65 73  |o.load this, res|
00000510  69 7a 69 6e 67 20 74 68  65 20 68 65 6c 70 20 77  |izing the help w|
00000520  69 6e 64 6f 77 20 61 6e  64 20 70 6c 61 63 69 6e  |indow and placin|
00000530  67 20 69 74 20 61 74 20  74 68 65 20 74 6f 70 20  |g it at the top |
00000540  72 69 67 68 74 20 6f 66  20 74 68 65 0a 73 63 72  |right of the.scr|
00000550  65 65 6e 2e 20 46 75 72  74 68 65 72 20 68 65 6c  |een. Further hel|
00000560  70 20 63 61 6e 20 62 65  20 68 61 64 20 62 79 20  |p can be had by |
00000570  63 68 6f 6f 73 69 6e 67  20 74 68 65 20 48 65 6c  |choosing the Hel|
00000580  70 20 65 6e 74 72 79 20  6f 6e 20 50 6f 77 65 72  |p entry on Power|
00000590  62 61 73 65 27 73 0a 6d  61 69 6e 20 6d 65 6e 75  |base's.main menu|
000005a0  20 6f 72 20 6f 6e 20 74  68 65 20 69 63 6f 6e 2d  | or on the icon-|
000005b0  62 61 72 20 6d 65 6e 75  2e 0a 0a 53 74 61 72 74  |bar menu...Start|
000005c0  69 6e 67 20 50 6f 77 65  72 62 61 73 65 0a 3d 3d  |ing Powerbase.==|
000005d0  3d 3d 3d 3d 3d 3d 3d 3d  3d 3d 3d 3d 3d 3d 3d 3d  |================|
000005e0  0a 44 6f 75 62 6c 65 2d  63 6c 69 63 6b 20 6f 6e  |.Double-click on|
000005f0  20 74 68 65 20 50 6f 77  65 72 62 61 73 65 20 69  | the Powerbase i|
00000600  63 6f 6e 2e 20 41 66 74  65 72 20 61 20 66 65 77  |con. After a few|
00000610  20 73 65 63 6f 6e 64 73  20 69 74 20 77 69 6c 6c  | seconds it will|
00000620  20 61 70 70 65 61 72 20  6f 6e 0a 74 68 65 20 69  | appear on.the i|
00000630  63 6f 6e 2d 62 61 72 20  77 69 74 68 20 74 68 65  |con-bar with the|
00000640  20 77 6f 72 64 73 20 22  4e 6f 20 64 61 74 61 22  | words "No data"|
00000650  20 62 65 6e 65 61 74 68  20 69 74 20 74 6f 20 73  | beneath it to s|
00000660  68 6f 77 20 74 68 61 74  20 6e 6f 20 64 61 74 61  |how that no data|
00000670  62 61 73 65 20 69 73 0a  6f 70 65 6e 2e 20 44 72  |base is.open. Dr|
00000680  61 67 67 69 6e 67 20 74  68 65 20 27 46 72 69 65  |agging the 'Frie|
00000690  6e 64 73 27 20 69 63 6f  6e 20 6f 6e 74 6f 20 74  |nds' icon onto t|
000006a0  68 65 20 50 6f 77 65 72  62 61 73 65 20 69 63 6f  |he Powerbase ico|
000006b0  6e 20 6f 6e 20 74 68 65  20 69 63 6f 6e 2d 62 61  |n on the icon-ba|
000006c0  72 0a 77 69 6c 6c 20 6f  70 65 6e 20 27 46 72 69  |r.will open 'Fri|
000006d0  65 6e 64 73 27 20 66 6f  72 20 75 73 65 20 61 6e  |ends' for use an|
000006e0  64 20 74 68 65 20 77 6f  72 64 73 20 22 4e 6f 20  |d the words "No |
000006f0  64 61 74 61 22 20 77 69  6c 6c 20 62 65 20 72 65  |data" will be re|
00000700  70 6c 61 63 65 64 20 62  79 20 74 68 65 0a 6e 61  |placed by the.na|
00000710  6d 65 20 6f 66 20 74 68  65 20 64 61 74 61 62 61  |me of the databa|
00000720  73 65 2e 20 44 6f 75 62  6c 65 2d 63 6c 69 63 6b  |se. Double-click|
00000730  69 6e 67 20 6f 6e 20 74  68 65 20 27 46 72 69 65  |ing on the 'Frie|
00000740  6e 64 73 27 20 69 63 6f  6e 20 68 61 73 20 74 68  |nds' icon has th|
00000750  65 20 73 61 6d 65 0a 65  66 66 65 63 74 2c 20 69  |e same.effect, i|
00000760  6e 20 66 61 63 74 20 69  66 20 50 6f 77 65 72 62  |n fact if Powerb|
00000770  61 73 65 20 69 73 6e 27  74 20 61 6c 72 65 61 64  |ase isn't alread|
00000780  79 20 6f 6e 20 74 68 65  20 69 63 6f 6e 2d 62 61  |y on the icon-ba|
00000790  72 20 61 20 64 6f 75 62  6c 65 2d 63 6c 69 63 6b  |r a double-click|
000007a0  20 6f 6e 0a 27 46 72 69  65 6e 64 73 27 20 77 69  | on.'Friends' wi|
000007b0  6c 6c 20 69 6e 73 74 61  6c 6c 20 69 74 20 66 6f  |ll install it fo|
000007c0  72 20 79 6f 75 20 70 72  6f 76 69 64 65 64 20 74  |r you provided t|
000007d0  68 61 74 20 74 68 65 20  50 6f 77 65 72 62 61 73  |hat the Powerbas|
000007e0  65 20 69 63 6f 6e 20 68  61 73 20 62 65 65 6e 0a  |e icon has been.|
000007f0  73 65 65 6e 20 62 79 20  74 68 65 20 66 69 6c 65  |seen by the file|
00000800  72 2e 20 0a 0a 54 77 6f  20 77 69 6e 64 6f 77 73  |r. ..Two windows|
00000810  20 77 69 6c 6c 20 6f 70  65 6e 2e 20 4f 6e 65 20  | will open. One |
00000820  69 73 20 74 68 65 20 52  45 43 4f 52 44 20 57 49  |is the RECORD WI|
00000830  4e 44 4f 57 20 61 6e 64  20 64 69 73 70 6c 61 79  |NDOW and display|
00000840  73 20 74 68 65 20 66 69  72 73 74 0a 72 65 63 6f  |s the first.reco|
00000850  72 64 20 69 6e 20 74 68  65 20 64 61 74 61 62 61  |rd in the databa|
00000860  73 65 20 2d 20 74 68 65  20 6f 6e 65 20 66 6f 72  |se - the one for|
00000870  20 22 42 61 64 67 65 72  79 20 50 65 74 65 72 22  | "Badgery Peter"|
00000880  2e 20 54 68 65 20 6f 74  68 65 72 20 69 73 20 74  |. The other is t|
00000890  68 65 0a 4b 45 59 50 41  44 20 77 68 69 63 68 20  |he.KEYPAD which |
000008a0  61 6c 6c 6f 77 73 20 79  6f 75 20 74 6f 20 63 6f  |allows you to co|
000008b0  6e 74 72 6f 6c 20 74 68  65 20 62 72 6f 77 73 69  |ntrol the browsi|
000008c0  6e 67 2c 20 73 65 61 72  63 68 69 6e 67 20 61 6e  |ng, searching an|
000008d0  64 20 65 64 69 74 69 6e  67 0a 66 75 6e 63 74 69  |d editing.functi|
000008e0  6f 6e 73 20 6f 66 20 50  6f 77 65 72 62 61 73 65  |ons of Powerbase|
000008f0  2e 20 54 68 65 20 6b 65  79 70 61 64 20 69 73 20  |. The keypad is |
00000900  72 61 74 68 65 72 20 6c  61 72 67 65 20 61 6e 64  |rather large and|
00000910  20 6f 62 73 63 75 72 65  73 20 71 75 69 74 65 20  | obscures quite |
00000920  61 20 62 69 67 0a 61 72  65 61 20 6f 66 20 74 68  |a big.area of th|
00000930  65 20 72 65 63 6f 72 64  20 77 69 6e 64 6f 77 2e  |e record window.|
00000940  20 54 68 65 20 6d 6f 73  74 2d 75 73 65 64 20 62  | The most-used b|
00000950  75 74 74 6f 6e 73 2c 20  68 6f 77 65 76 65 72 2c  |uttons, however,|
00000960  20 61 72 65 20 6f 6e 20  74 68 65 20 74 6f 70 0a  | are on the top.|
00000970  74 77 6f 20 72 6f 77 73  20 61 6e 64 20 74 68 65  |two rows and the|
00000980  20 6b 65 79 70 61 64 20  63 61 6e 20 62 65 20 6d  | keypad can be m|
00000990  6f 76 65 64 20 70 61 72  74 20 77 61 79 20 6f 66  |oved part way of|
000009a0  66 20 73 63 72 65 65 6e  20 74 6f 20 67 65 74 20  |f screen to get |
000009b0  69 74 20 6f 75 74 20 6f  66 0a 74 68 65 20 77 61  |it out of.the wa|
000009c0  79 2e 0a 0a 42 72 6f 77  73 69 6e 67 20 74 68 72  |y...Browsing thr|
000009d0  6f 75 67 68 20 74 68 65  20 52 65 63 6f 72 64 73  |ough the Records|
000009e0  0a 3d 3d 3d 3d 3d 3d 3d  3d 3d 3d 3d 3d 3d 3d 3d  |.===============|
000009f0  3d 3d 3d 3d 3d 3d 3d 3d  3d 3d 3d 3d 3d 0a 54 68  |=============.Th|
00000a00  65 20 74 6f 70 20 72 6f  77 20 6f 66 20 62 75 74  |e top row of but|
00000a10  74 6f 6e 73 20 6f 6e 20  74 68 65 20 6b 65 79 70  |tons on the keyp|
00000a20  61 64 20 61 6c 6c 6f 77  73 20 79 6f 75 20 74 6f  |ad allows you to|
00000a30  20 62 72 6f 77 73 65 20  74 68 72 6f 75 67 68 20  | browse through |
00000a40  74 68 65 20 66 69 6c 65  2e 0a 49 66 20 79 6f 75  |the file..If you|
00000a50  20 68 61 76 65 20 21 48  65 6c 70 20 72 75 6e 6e  | have !Help runn|
00000a60  69 6e 67 2c 20 61 73 20  70 72 65 76 69 6f 75 73  |ing, as previous|
00000a70  6c 79 20 73 75 67 67 65  73 74 65 64 2c 20 69 74  |ly suggested, it|
00000a80  20 77 69 6c 6c 20 74 65  6c 6c 20 79 6f 75 20 77  | will tell you w|
00000a90  68 61 74 0a 65 61 63 68  20 62 75 74 74 6f 6e 20  |hat.each button |
00000aa0  64 6f 65 73 2e 20 4f 6e  63 65 20 79 6f 75 20 67  |does. Once you g|
00000ab0  65 74 20 74 68 65 20 67  65 6e 65 72 61 6c 20 69  |et the general i|
00000ac0  64 65 61 20 79 6f 75 20  77 69 6c 6c 20 66 69 6e  |dea you will fin|
00000ad0  64 20 74 68 65 20 73 79  6d 62 6f 6c 73 20 6f 6e  |d the symbols on|
00000ae0  0a 74 68 65 20 62 75 74  74 6f 6e 73 20 6c 6f 67  |.the buttons log|
00000af0  69 63 61 6c 20 61 6e 64  20 73 65 6c 66 2d 65 78  |ical and self-ex|
00000b00  70 6c 61 6e 61 74 6f 72  79 2e 20 54 68 65 20 6d  |planatory. The m|
00000b10  6f 73 74 20 63 6f 6d 6d  6f 6e 6c 79 20 75 73 65  |ost commonly use|
00000b20  64 20 6f 6e 65 73 20 61  63 74 20 61 73 0a 66 6f  |d ones act as.fo|
00000b30  6c 6c 6f 77 73 3a 0a 0a  28 61 29 20 54 68 65 20  |llows:..(a) The |
00000b40  61 72 72 6f 77 73 20 61  74 20 74 68 65 20 65 6e  |arrows at the en|
00000b50  64 73 20 6f 66 20 74 68  65 20 72 6f 77 20 74 61  |ds of the row ta|
00000b60  6b 65 20 79 6f 75 20 74  6f 20 74 68 65 20 66 69  |ke you to the fi|
00000b70  72 73 74 20 61 6e 64 20  6c 61 73 74 0a 72 65 63  |rst and last.rec|
00000b80  6f 72 64 73 2e 20 59 6f  75 20 61 72 65 20 6c 6f  |ords. You are lo|
00000b90  6f 6b 69 6e 67 20 61 74  20 74 68 65 20 66 69 72  |oking at the fir|
00000ba0  73 74 20 72 65 63 6f 72  64 20 6e 6f 77 2c 20 73  |st record now, s|
00000bb0  6f 20 63 6c 69 63 6b 20  28 77 69 74 68 20 53 45  |o click (with SE|
00000bc0  4c 45 43 54 29 20 6f 6e  0a 74 68 65 20 74 6f 70  |LECT) on.the top|
00000bd0  2d 72 69 67 68 74 20 62  75 74 74 6f 6e 20 61 6e  |-right button an|
00000be0  64 20 79 6f 75 20 77 69  6c 6c 20 73 65 65 20 74  |d you will see t|
00000bf0  68 65 20 72 65 63 6f 72  64 20 66 6f 72 20 54 75  |he record for Tu|
00000c00  72 6e 69 70 20 43 68 61  72 6c 65 73 2e 20 54 68  |rnip Charles. Th|
00000c10  65 0a 6c 65 66 74 6d 6f  73 74 20 62 75 74 74 6f  |e.leftmost butto|
00000c20  6e 20 74 61 6b 65 73 20  79 6f 75 20 62 61 63 6b  |n takes you back|
00000c30  20 74 6f 20 74 68 65 20  73 74 61 72 74 20 61 67  | to the start ag|
00000c40  61 69 6e 2e 0a 0a 28 62  29 20 4d 6f 76 65 6d 65  |ain...(b) Moveme|
00000c50  6e 74 20 74 68 72 6f 75  67 68 20 74 68 65 20 66  |nt through the f|
00000c60  69 6c 65 20 6f 6e 65 20  72 65 63 6f 72 64 20 61  |ile one record a|
00000c70  74 20 61 20 74 69 6d 65  20 69 73 20 61 63 68 69  |t a time is achi|
00000c80  65 76 65 64 20 75 73 69  6e 67 20 74 68 65 0a 73  |eved using the.s|
00000c90  69 6e 67 6c 65 20 61 72  72 6f 77 20 6b 65 79 73  |ingle arrow keys|
00000ca0  20 6e 65 78 74 20 64 6f  6f 72 20 74 6f 20 74 68  | next door to th|
00000cb0  65 20 6f 6e 65 73 20 79  6f 75 20 68 61 76 65 20  |e ones you have |
00000cc0  6a 75 73 74 20 75 73 65  64 2e 20 54 72 79 20 74  |just used. Try t|
00000cd0  68 65 6d 20 6f 75 74 2c  0a 6e 6f 74 69 6e 67 20  |hem out,.noting |
00000ce0  74 68 65 20 77 61 79 20  72 65 63 6f 72 64 73 20  |the way records |
00000cf0  63 6f 6d 65 20 75 70 20  69 6e 20 61 6c 70 68 61  |come up in alpha|
00000d00  62 65 74 69 63 61 6c 2c  20 6f 72 20 72 65 76 65  |betical, or reve|
00000d10  72 73 65 20 61 6c 70 68  61 62 65 74 69 63 61 6c  |rse alphabetical|
00000d20  2c 0a 6f 72 64 65 72 2e  0a 0a 28 63 29 20 54 68  |,.order...(c) Th|
00000d30  65 20 6b 65 79 73 20 77  69 74 68 20 64 6f 75 62  |e keys with doub|
00000d40  6c 65 20 61 72 72 6f 77  73 20 61 6c 6c 6f 77 20  |le arrows allow |
00000d50  79 6f 75 20 74 6f 20 6d  61 6b 65 20 6c 6f 6e 67  |you to make long|
00000d60  65 72 20 6a 75 6d 70 73  20 74 68 72 6f 75 67 68  |er jumps through|
00000d70  20 74 68 65 0a 66 69 6c  65 2e 20 54 68 65 20 6e  | the.file. The n|
00000d80  75 6d 62 65 72 20 6f 66  20 72 65 63 6f 72 64 73  |umber of records|
00000d90  20 73 6b 69 70 70 65 64  20 69 73 20 73 68 6f 77  | skipped is show|
00000da0  6e 20 69 6e 20 74 68 65  20 77 72 69 74 61 62 6c  |n in the writabl|
00000db0  65 20 69 63 6f 6e 20 62  65 74 77 65 65 6e 0a 74  |e icon between.t|
00000dc0  68 65 6d 20 61 6e 64 20  68 61 73 20 61 20 64 65  |hem and has a de|
00000dd0  66 61 75 6c 74 20 76 61  6c 75 65 20 6f 66 20 31  |fault value of 1|
00000de0  30 2e 20 53 69 6e 63 65  20 74 68 65 72 65 20 61  |0. Since there a|
00000df0  72 65 20 6f 6e 6c 79 20  31 30 20 72 65 63 6f 72  |re only 10 recor|
00000e00  64 73 20 69 6e 0a 27 46  72 69 65 6e 64 73 27 20  |ds in.'Friends' |
00000e10  74 68 65 73 65 20 6b 65  79 73 20 77 69 6c 6c 20  |these keys will |
00000e20  68 61 76 65 20 74 68 65  20 73 61 6d 65 20 65 66  |have the same ef|
00000e30  66 65 63 74 20 61 73 20  74 68 65 20 22 66 69 72  |fect as the "fir|
00000e40  73 74 22 20 61 6e 64 20  22 6c 61 73 74 22 0a 6b  |st" and "last".k|
00000e50  65 79 73 2c 20 75 6e 6c  65 73 73 20 79 6f 75 20  |eys, unless you |
00000e60  63 68 61 6e 67 65 20 74  68 65 20 69 6e 74 65 72  |change the inter|
00000e70  76 61 6c 20 74 6f 20 73  6f 6d 65 74 68 69 6e 67  |val to something|
00000e80  20 6c 65 73 73 2e 20 43  6c 69 63 6b 20 69 6e 20  | less. Click in |
00000e90  74 68 65 20 69 63 6f 6e  2c 0a 64 65 6c 65 74 65  |the icon,.delete|
00000ea0  20 74 68 65 20 31 30 20  61 6e 64 20 65 6e 74 65  | the 10 and ente|
00000eb0  72 20 35 20 6f 72 20 32  2c 20 74 68 65 6e 20 74  |r 5 or 2, then t|
00000ec0  72 79 20 74 68 65 20 64  6f 75 62 6c 65 2d 61 72  |ry the double-ar|
00000ed0  72 6f 77 20 6b 65 79 73  20 61 67 61 69 6e 2e 20  |row keys again. |
00000ee0  20 20 20 20 20 20 20 20  20 20 20 20 20 20 20 20  |                |
00000ef0  20 20 20 20 20 20 20 0a  53 65 61 72 63 68 69 6e  |       .Searchin|
00000f00  67 20 66 6f 72 20 61 20  72 65 63 6f 72 64 20 0a  |g for a record .|
00000f10  3d 3d 3d 3d 3d 3d 3d 3d  3d 3d 3d 3d 3d 3d 3d 3d  |================|
00000f20  3d 3d 3d 3d 3d 3d 20 0a  54 68 65 20 72 69 67 68  |====== .The righ|
00000f30  74 6d 6f 73 74 20 62 75  74 74 6f 6e 20 6f 6e 20  |tmost button on |
00000f40  74 68 65 20 74 68 69 72  64 20 72 6f 77 20 6f 66  |the third row of|
00000f50  20 74 68 65 20 6b 65 79  70 61 64 20 73 68 6f 77  | the keypad show|
00000f60  73 20 61 20 71 75 65 73  74 69 6f 6e 20 6d 61 72  |s a question mar|
00000f70  6b 0a 66 6f 6c 6c 6f 77  65 64 20 62 79 20 61 20  |k.followed by a |
00000f80  22 72 65 63 6f 72 64 20  63 61 72 64 22 20 69 63  |"record card" ic|
00000f90  6f 6e 20 20 57 65 20 77  69 6c 6c 20 63 61 6c 6c  |on  We will call|
00000fa0  20 69 74 20 74 68 65 20  53 65 61 72 63 68 20 62  | it the Search b|
00000fb0  75 74 74 6f 6e 2e 20 57  68 65 6e 0a 63 6c 69 63  |utton. When.clic|
00000fc0  6b 65 64 20 77 69 74 68  20 53 45 4c 45 43 54 20  |ked with SELECT |
00000fd0  74 68 65 20 6b 65 79 70  61 64 20 77 69 6e 64 6f  |the keypad windo|
00000fe0  77 20 67 72 6f 77 73 20  61 6e 20 65 78 74 65 6e  |w grows an exten|
00000ff0  73 69 6f 6e 20 6f 6e 20  74 68 65 20 72 69 67 68  |sion on the righ|
00001000  74 2d 68 61 6e 64 0a 73  69 64 65 2e 20 54 68 69  |t-hand.side. Thi|
00001010  73 20 6e 65 77 20 61 72  65 61 20 63 6f 6e 74 61  |s new area conta|
00001020  69 6e 73 20 61 20 77 72  69 74 61 62 6c 65 20 69  |ins a writable i|
00001030  63 6f 6e 20 69 6e 20 77  68 69 63 68 20 74 6f 20  |con in which to |
00001040  65 6e 74 65 72 20 74 68  65 20 6b 65 79 20 6f 66  |enter the key of|
00001050  0a 74 68 65 20 72 65 63  6f 72 64 20 79 6f 75 20  |.the record you |
00001060  77 69 73 68 20 74 6f 20  64 69 73 70 6c 61 79 2e  |wish to display.|
00001070  20 53 75 70 70 6f 73 65  20 79 6f 75 20 77 61 6e  | Suppose you wan|
00001080  74 20 74 6f 20 73 65 65  20 74 68 65 20 72 65 63  |t to see the rec|
00001090  6f 72 64 20 66 6f 72 0a  22 42 6c 6f 67 67 73 20  |ord for."Bloggs |
000010a0  46 72 65 64 22 2e 20 59  6f 75 20 6e 65 65 64 20  |Fred". You need |
000010b0  74 6f 20 65 6e 74 65 72  20 74 68 65 20 4b 45 59  |to enter the KEY|
000010c0  20 66 6f 72 20 74 68 65  20 72 65 63 6f 72 64 2e  | for the record.|
000010d0  20 49 6e 20 74 68 69 73  20 64 61 74 61 62 61 73  | In this databas|
000010e0  65 0a 6b 65 79 73 20 61  72 65 20 6d 61 64 65 20  |e.keys are made |
000010f0  75 70 20 66 72 6f 6d 20  74 68 65 20 66 69 72 73  |up from the firs|
00001100  74 20 34 20 6c 65 74 74  65 72 73 20 6f 66 20 74  |t 4 letters of t|
00001110  68 65 20 73 75 72 6e 61  6d 65 20 70 6c 75 73 20  |he surname plus |
00001120  74 68 65 20 69 6e 69 74  69 61 6c 2e 0a 54 68 65  |the initial..The|
00001130  20 72 65 71 75 69 72 65  64 20 6b 65 79 20 69 73  | required key is|
00001140  20 74 68 65 72 65 66 6f  72 65 20 42 4c 4f 47 46  | therefore BLOGF|
00001150  2e 20 45 6e 74 65 72 20  74 68 69 73 20 61 6e 64  |. Enter this and|
00001160  20 65 69 74 68 65 72 20  63 6c 69 63 6b 20 6f 6e  | either click on|
00001170  20 4f 4b 20 6f 72 0a 74  79 70 65 20 3c 52 65 74  | OK or.type <Ret|
00001180  75 72 6e 3e 20 61 6e 64  20 74 68 65 20 72 65 63  |urn> and the rec|
00001190  6f 72 64 20 77 69 6c 6c  20 62 65 20 64 69 73 70  |ord will be disp|
000011a0  6c 61 79 65 64 2e 20 4e  6f 74 65 20 74 68 61 74  |layed. Note that|
000011b0  20 74 68 65 20 6b 65 79  20 69 73 20 73 68 6f 77  | the key is show|
000011c0  6e 0a 69 6e 20 74 68 65  20 77 69 6e 64 6f 77 20  |n.in the window |
000011d0  68 65 61 64 69 6e 67 2e  0a 0a 45 64 69 74 69 6e  |heading...Editin|
000011e0  67 20 74 68 65 20 44 61  74 61 62 61 73 65 0a 3d  |g the Database.=|
000011f0  3d 3d 3d 3d 3d 3d 3d 3d  3d 3d 3d 3d 3d 3d 3d 3d  |================|
00001200  3d 3d 3d 0a 54 68 69 73  20 70 61 72 74 20 6f 66  |===.This part of|
00001210  20 74 68 65 20 74 75 74  6f 72 69 61 6c 20 69 6e  | the tutorial in|
00001220  76 6f 6c 76 65 73 20 63  68 61 6e 67 65 73 20 74  |volves changes t|
00001230  6f 20 74 68 65 20 64 61  74 61 20 72 65 63 6f 72  |o the data recor|
00001240  64 73 2e 20 4d 61 6b 65  20 61 0a 77 6f 72 6b 69  |ds. Make a.worki|
00001250  6e 67 20 63 6f 70 79 20  6f 66 20 74 68 65 20 64  |ng copy of the d|
00001260  69 73 63 20 61 6e 64 20  70 75 74 20 74 68 65 20  |isc and put the |
00001270  6f 72 69 67 69 6e 61 6c  20 69 6e 20 61 20 73 61  |original in a sa|
00001280  66 65 20 70 6c 61 63 65  2e 20 49 66 20 79 6f 75  |fe place. If you|
00001290  20 61 72 65 0a 75 73 69  6e 67 20 61 20 63 6f 70  | are.using a cop|
000012a0  79 20 6f 66 20 27 46 72  69 65 6e 64 73 27 20 6f  |y of 'Friends' o|
000012b0  6e 20 74 68 65 20 52 41  4d 20 64 69 73 63 20 74  |n the RAM disc t|
000012c0  68 65 6e 20 74 68 65 20  66 6c 6f 70 70 79 20 64  |hen the floppy d|
000012d0  69 73 63 20 77 6f 6e 27  74 20 62 65 0a 61 6c 74  |isc won't be.alt|
000012e0  65 72 65 64 2c 20 62 75  74 20 69 74 27 73 20 73  |ered, but it's s|
000012f0  74 69 6c 6c 20 6e 6f 74  20 61 20 67 6f 6f 64 20  |till not a good |
00001300  69 64 65 61 20 74 6f 20  77 6f 72 6b 20 77 69 74  |idea to work wit|
00001310  68 20 74 68 65 20 6f 72  69 67 69 6e 61 6c 20 64  |h the original d|
00001320  69 73 63 2e 0a 0a 4d 6f  64 69 66 79 69 6e 67 20  |isc...Modifying |
00001330  72 65 63 6f 72 64 73 0a  2d 2d 2d 2d 2d 2d 2d 2d  |records.--------|
00001340  2d 2d 2d 2d 2d 2d 2d 2d  2d 0a 50 6f 69 6e 74 69  |---------.Pointi|
00001350  6e 67 20 74 68 65 20 6d  6f 75 73 65 20 61 74 20  |ng the mouse at |
00001360  61 6e 79 20 66 69 65 6c  64 20 61 6e 64 20 63 6c  |any field and cl|
00001370  69 63 6b 69 6e 67 20 53  45 4c 45 43 54 20 70 6c  |icking SELECT pl|
00001380  61 63 65 73 20 74 68 65  20 63 61 72 65 74 20 69  |aces the caret i|
00001390  6e 20 74 68 61 74 0a 66  69 65 6c 64 2e 20 54 68  |n that.field. Th|
000013a0  65 20 63 6f 6e 74 65 6e  74 73 20 6f 66 20 74 68  |e contents of th|
000013b0  65 20 66 69 65 6c 64 20  6d 61 79 20 74 68 65 6e  |e field may then|
000013c0  20 62 65 20 65 64 69 74  65 64 20 69 6e 20 74 68  | be edited in th|
000013d0  65 20 73 74 61 6e 64 61  72 64 20 77 61 79 20 66  |e standard way f|
000013e0  6f 72 0a 52 49 53 43 20  4f 53 20 77 72 69 74 61  |or.RISC OS writa|
000013f0  62 6c 65 20 69 63 6f 6e  73 2e 20 69 2e 65 2e 0a  |ble icons. i.e..|
00001400  0a 20 20 20 20 20 20 20  43 54 52 4c 20 55 20 63  |.       CTRL U c|
00001410  6c 65 61 72 73 20 74 68  65 20 66 69 65 6c 64 2e  |lears the field.|
00001420  0a 20 20 20 20 20 20 20  44 45 4c 45 54 45 20 72  |.       DELETE r|
00001430  65 6d 6f 76 65 73 20 74  68 65 20 63 68 61 72 61  |emoves the chara|
00001440  63 74 65 72 20 74 6f 20  74 68 65 20 6c 65 66 74  |cter to the left|
00001450  20 6f 66 20 74 68 65 20  63 61 72 65 74 2e 0a 20  | of the caret.. |
00001460  20 20 20 20 20 20 43 4f  50 59 20 72 65 6d 6f 76  |      COPY remov|
00001470  65 73 20 74 68 65 20 63  68 61 72 61 63 74 65 72  |es the character|
00001480  20 74 6f 20 74 68 65 20  72 69 67 68 74 20 6f 66  | to the right of|
00001490  20 74 68 65 20 63 61 72  65 74 2e 0a 20 20 20 20  | the caret..    |
000014a0  20 20 20 53 48 49 46 54  2f 43 4f 50 59 20 64 65  |   SHIFT/COPY de|
000014b0  6c 65 74 65 73 20 74 68  65 20 77 6f 72 64 20 74  |letes the word t|
000014c0  6f 20 74 68 65 20 72 69  67 68 74 20 6f 66 20 74  |o the right of t|
000014d0  68 65 20 63 61 72 65 74  2e 0a 20 20 20 20 20 20  |he caret..      |
000014e0  20 43 54 52 4c 2f 43 4f  50 59 20 64 65 6c 65 74  | CTRL/COPY delet|
000014f0  65 73 20 65 76 65 72 79  74 68 69 6e 67 20 66 72  |es everything fr|
00001500  6f 6d 20 74 68 65 20 63  61 72 65 74 20 74 6f 20  |om the caret to |
00001510  74 68 65 20 65 6e 64 20  6f 66 20 74 68 65 20 6c  |the end of the l|
00001520  69 6e 65 2e 0a 20 20 20  20 20 20 20 88 20 61 6e  |ine..       . an|
00001530  64 20 89 20 6d 6f 76 65  20 74 68 65 20 63 61 72  |d . move the car|
00001540  65 74 20 6c 65 66 74 2f  72 69 67 68 74 20 62 79  |et left/right by|
00001550  20 6f 6e 65 20 63 68 61  72 61 63 74 65 72 2e 0a  | one character..|
00001560  20 20 20 20 20 20 20 53  48 49 46 54 20 88 20 61  |       SHIFT . a|
00001570  6e 64 20 53 48 49 46 54  20 89 20 6d 6f 76 65 20  |nd SHIFT . move |
00001580  74 68 65 20 63 61 72 65  74 20 6c 65 66 74 2f 72  |the caret left/r|
00001590  69 67 68 74 20 62 79 20  6f 6e 65 20 77 6f 72 64  |ight by one word|
000015a0  2e 0a 20 20 20 20 20 20  20 43 52 54 4c 20 88 20  |..       CRTL . |
000015b0  61 6e 64 20 43 54 52 4c  20 89 20 6d 6f 76 65 20  |and CTRL . move |
000015c0  74 68 65 20 63 61 72 65  74 20 74 6f 20 73 74 61  |the caret to sta|
000015d0  72 74 20 61 6e 64 20 65  6e 64 20 6f 66 20 74 68  |rt and end of th|
000015e0  65 20 66 69 65 6c 64 2e  0a 20 20 20 20 20 20 20  |e field..       |
000015f0  20 20 20 0a 43 68 61 6e  67 65 73 20 6d 61 64 65  |   .Changes made|
00001600  20 74 6f 20 61 20 72 65  63 6f 72 64 20 63 61 75  | to a record cau|
00001610  73 65 20 74 68 65 20 72  65 63 6f 72 64 20 74 6f  |se the record to|
00001620  20 62 65 20 77 72 69 74  74 65 6e 20 62 61 63 6b  | be written back|
00001630  20 74 6f 20 74 68 65 20  64 61 74 61 62 61 73 65  | to the database|
00001640  0a 77 68 65 6e 65 76 65  72 20 79 6f 75 20 64 69  |.whenever you di|
00001650  73 70 6c 61 79 20 61 20  64 69 66 66 65 72 65 6e  |splay a differen|
00001660  74 20 72 65 63 6f 72 64  20 6f 72 20 63 6c 6f 73  |t record or clos|
00001670  65 20 74 68 65 20 64 61  74 61 62 61 73 65 2e 20  |e the database. |
00001680  28 54 68 65 72 65 20 69  73 20 61 0a 62 75 74 74  |(There is a.butt|
00001690  6f 6e 20 6f 6e 20 74 68  65 20 6b 65 79 70 61 64  |on on the keypad|
000016a0  20 63 61 6c 6c 65 64 20  27 46 6f 72 63 65 20 75  | called 'Force u|
000016b0  70 64 61 74 65 27 20 62  75 74 20 79 6f 75 20 64  |pdate' but you d|
000016c0  6f 6e 27 74 20 6e 6f 72  6d 61 6c 6c 79 20 6e 65  |on't normally ne|
000016d0  65 64 20 74 6f 0a 75 73  65 20 69 74 2e 29 0a 0a  |ed to.use it.)..|
000016e0  52 65 63 6f 76 65 72 69  6e 67 20 64 61 74 61 20  |Recovering data |
000016f0  61 66 74 65 72 20 61 20  6d 69 73 74 61 6b 65 0a  |after a mistake.|
00001700  2d 2d 2d 2d 2d 2d 2d 2d  2d 2d 2d 2d 2d 2d 2d 2d  |----------------|
00001710  2d 2d 2d 2d 2d 2d 2d 2d  2d 2d 2d 2d 2d 2d 2d 0a  |---------------.|
00001720  59 6f 75 20 77 69 6c 6c  20 73 6f 6d 65 74 69 6d  |You will sometim|
00001730  65 73 20 65 64 69 74 20  74 68 65 20 77 72 6f 6e  |es edit the wron|
00001740  67 20 66 69 65 6c 64 20  62 79 20 6d 69 73 74 61  |g field by mista|
00001750  6b 65 20 61 6e 64 20 77  61 6e 74 20 74 6f 20 72  |ke and want to r|
00001760  65 73 74 6f 72 65 20 74  68 65 0a 70 72 65 76 69  |estore the.previ|
00001770  6f 75 73 20 63 6f 6e 74  65 6e 74 73 2e 20 43 6c  |ous contents. Cl|
00001780  69 63 6b 20 4d 45 4e 55  20 6f 76 65 72 20 74 68  |ick MENU over th|
00001790  65 20 66 69 65 6c 64 2e  20 54 68 65 20 73 65 63  |e field. The sec|
000017a0  6f 6e 64 20 65 6e 74 72  79 20 6f 6e 20 74 68 65  |ond entry on the|
000017b0  20 6d 61 69 6e 0a 6d 65  6e 75 20 63 6f 6e 74 61  | main.menu conta|
000017c0  69 6e 73 20 74 68 65 20  22 74 61 67 22 20 6f 66  |ins the "tag" of|
000017d0  20 74 68 65 20 66 69 65  6c 64 2e 20 46 6f 6c 6c  | the field. Foll|
000017e0  6f 77 20 74 68 65 20 72  69 67 68 74 2d 70 6f 69  |ow the right-poi|
000017f0  6e 74 69 6e 67 20 61 72  72 6f 77 20 74 6f 20 74  |nting arrow to t|
00001800  68 65 0a 27 46 69 65 6c  64 27 20 73 75 62 2d 6d  |he.'Field' sub-m|
00001810  65 6e 75 20 61 6e 64 20  63 68 6f 6f 73 65 20 74  |enu and choose t|
00001820  68 65 20 6c 61 73 74 20  65 6e 74 72 79 3a 20 27  |he last entry: '|
00001830  55 6e 64 6f 20 63 68 61  6e 67 65 73 27 2e 20 53  |Undo changes'. S|
00001840  69 6d 69 6c 61 72 6c 79  2c 20 69 66 0a 79 6f 75  |imilarly, if.you|
00001850  20 6d 61 6b 65 20 61 20  6d 65 73 73 20 6f 66 20  | make a mess of |
00001860  61 20 63 6f 6d 70 6c 65  74 65 20 72 65 63 6f 72  |a complete recor|
00001870  64 20 61 6e 64 20 77 61  6e 74 20 74 6f 20 67 6f  |d and want to go|
00001880  20 62 61 63 6b 20 74 6f  20 74 68 65 20 77 61 79  | back to the way|
00001890  20 69 74 20 77 61 73 0a  79 6f 75 20 63 61 6e 20  | it was.you can |
000018a0  63 68 6f 6f 73 65 20 27  55 6e 64 6f 20 63 68 61  |choose 'Undo cha|
000018b0  6e 67 65 73 27 20 66 72  6f 6d 20 74 68 65 20 6d  |nges' from the m|
000018c0  61 69 6e 20 6d 65 6e 75  2e 0a 0a 49 74 20 69 73  |ain menu...It is|
000018d0  20 69 6d 70 6f 72 74 61  6e 74 20 74 6f 20 72 65  | important to re|
000018e0  61 6c 69 73 65 20 74 68  61 74 20 74 68 65 73 65  |alise that these|
000018f0  20 27 75 6e 64 6f 27 20  66 61 63 69 6c 69 74 69  | 'undo' faciliti|
00001900  65 73 20 77 69 6c 6c 20  6e 6f 74 20 77 6f 72 6b  |es will not work|
00001910  20 69 66 20 79 6f 75 0a  68 61 76 65 20 6c 6f 6f  | if you.have loo|
00001920  6b 65 64 20 61 74 20 61  6e 6f 74 68 65 72 20 72  |ked at another r|
00001930  65 63 6f 72 64 20 62 65  66 6f 72 65 20 75 73 69  |ecord before usi|
00001940  6e 67 20 74 68 65 6d 20  28 6f 72 20 63 6c 69 63  |ng them (or clic|
00001950  6b 65 64 20 6f 6e 20 27  46 6f 72 63 65 0a 75 70  |ked on 'Force.up|
00001960  64 61 74 65 27 29 2e 20  49 6e 20 6f 74 68 65 72  |date'). In other|
00001970  20 77 6f 72 64 73 20 79  6f 75 20 63 61 6e 20 72  | words you can r|
00001980  65 63 6f 76 65 72 20 64  61 74 61 20 77 68 69 63  |ecover data whic|
00001990  68 20 68 61 73 20 62 65  65 6e 20 61 6c 74 65 72  |h has been alter|
000019a0  65 64 20 69 6e 20 6f 72  0a 72 65 6d 6f 76 65 64  |ed in or.removed|
000019b0  20 66 72 6f 6d 20 74 68  65 20 63 75 72 72 65 6e  | from the curren|
000019c0  74 6c 79 2d 64 69 73 70  6c 61 79 65 64 20 72 65  |tly-displayed re|
000019d0  63 6f 72 64 20 6f 6e 6c  79 2e 0a 0a 41 64 64 69  |cord only...Addi|
000019e0  6e 67 20 61 6e 64 20 64  65 6c 65 74 69 6e 67 20  |ng and deleting |
000019f0  72 65 63 6f 72 64 73 20  0a 2d 2d 2d 2d 2d 2d 2d  |records .-------|
00001a00  2d 2d 2d 2d 2d 2d 2d 2d  2d 2d 2d 2d 2d 2d 2d 2d  |----------------|
00001a10  2d 2d 2d 2d 0a 54 6f 20  61 64 64 20 61 20 6e 65  |----.To add a ne|
00001a20  77 20 72 65 63 6f 72 64  20 79 6f 75 20 75 73 65  |w record you use|
00001a30  20 74 68 65 20 22 61 64  64 20 72 65 63 6f 72 64  | the "add record|
00001a40  22 20 62 75 74 74 6f 6e  20 77 68 69 63 68 20 6c  |" button which l|
00001a50  6f 6f 6b 73 20 6c 69 6b  65 20 61 20 70 6c 75 73  |ooks like a plus|
00001a60  0a 73 69 67 6e 20 61 6e  64 20 61 6e 20 69 6e 64  |.sign and an ind|
00001a70  65 78 20 63 61 72 64 2e  20 43 6c 69 63 6b 69 6e  |ex card. Clickin|
00001a80  67 20 6f 6e 20 74 68 69  73 20 6f 66 66 65 72 73  |g on this offers|
00001a90  20 61 20 62 6c 61 6e 6b  20 72 65 63 6f 72 64 20  | a blank record |
00001aa0  69 6e 74 6f 20 77 68 69  63 68 0a 79 6f 75 20 63  |into which.you c|
00001ab0  61 6e 20 74 79 70 65 20  73 6f 6d 65 20 6e 65 77  |an type some new|
00001ac0  20 64 61 74 61 2e 20 59  6f 75 20 64 6f 6e 27 74  | data. You don't|
00001ad0  20 68 61 76 65 20 74 6f  20 63 6f 6d 70 6c 65 74  | have to complet|
00001ae0  65 20 61 6c 6c 20 74 68  65 20 66 69 65 6c 64 73  |e all the fields|
00001af0  2c 20 69 6e 0a 66 61 63  74 20 74 68 65 20 6f 6e  |, in.fact the on|
00001b00  6c 79 20 66 69 65 6c 64  20 69 6e 74 6f 20 77 68  |ly field into wh|
00001b10  69 63 68 20 79 6f 75 20  4d 55 53 54 20 74 79 70  |ich you MUST typ|
00001b20  65 20 73 6f 6d 65 74 68  69 6e 67 20 69 73 20 74  |e something is t|
00001b30  68 65 20 4e 41 4d 45 20  66 69 65 6c 64 2e 0a 54  |he NAME field..T|
00001b40  68 69 73 20 69 73 20 74  68 65 20 4b 45 59 20 46  |his is the KEY F|
00001b50  49 45 4c 44 3b 20 74 68  65 20 6f 6e 65 20 66 72  |IELD; the one fr|
00001b60  6f 6d 20 77 68 69 63 68  20 74 68 65 20 6b 65 79  |om which the key|
00001b70  2c 20 6d 65 6e 74 69 6f  6e 65 64 20 65 61 72 6c  |, mentioned earl|
00001b80  69 65 72 2c 20 69 73 0a  64 65 72 69 76 65 64 2e  |ier, is.derived.|
00001b90  20 49 66 20 79 6f 75 20  6c 65 61 76 65 20 74 68  | If you leave th|
00001ba0  65 20 6b 65 79 20 66 69  65 6c 64 20 62 6c 61 6e  |e key field blan|
00001bb0  6b 20 74 68 65 6e 20 6e  6f 74 68 69 6e 67 20 77  |k then nothing w|
00001bc0  69 6c 6c 20 62 65 20 77  72 69 74 74 65 6e 20 74  |ill be written t|
00001bd0  6f 0a 74 68 65 20 64 61  74 61 62 61 73 65 2e 0a  |o.the database..|
00001be0  0a 54 79 70 65 20 74 68  65 20 6e 61 6d 65 20 22  |.Type the name "|
00001bf0  42 6f 64 6d 69 6e 20 47  65 6f 72 67 65 22 2c 20  |Bodmin George", |
00001c00  74 68 65 6e 20 67 6f 20  74 6f 20 74 68 65 20 62  |then go to the b|
00001c10  65 67 69 6e 6e 69 6e 67  20 6f 66 20 74 68 65 20  |eginning of the |
00001c20  66 69 6c 65 20 61 6e 64  0a 73 74 65 70 20 74 68  |file and.step th|
00001c30  72 6f 75 67 68 20 69 74  20 72 65 63 6f 72 64 20  |rough it record |
00001c40  62 79 20 72 65 63 6f 72  64 2e 20 59 6f 75 20 77  |by record. You w|
00001c50  69 6c 6c 20 66 69 6e 64  20 74 68 61 74 20 79 6f  |ill find that yo|
00001c60  75 72 20 6e 65 77 20 72  65 63 6f 72 64 20 68 61  |ur new record ha|
00001c70  73 0a 62 65 65 6e 20 69  6e 73 65 72 74 65 64 20  |s.been inserted |
00001c80  69 6e 20 74 68 65 20 63  6f 72 72 65 63 74 20 70  |in the correct p|
00001c90  6c 61 63 65 2c 20 69 2e  65 2e 20 74 68 65 20 73  |lace, i.e. the s|
00001ca0  65 71 75 65 6e 63 65 20  67 6f 65 73 3a 20 42 61  |equence goes: Ba|
00001cb0  64 67 65 72 79 2c 20 42  6c 6f 67 67 73 2c 0a 42  |dgery, Bloggs,.B|
00001cc0  6f 64 6d 69 6e 2c 20 43  61 76 65 6e 64 69 73 68  |odmin, Cavendish|
00001cd0  2e 0a 0a 4e 6f 77 20 6c  65 74 27 73 20 74 72 79  |...Now let's try|
00001ce0  20 64 65 6c 65 74 69 6e  67 20 74 68 65 20 72 65  | deleting the re|
00001cf0  63 6f 72 64 20 79 6f 75  27 76 65 20 6a 75 73 74  |cord you've just|
00001d00  20 61 64 64 65 64 2e 20  54 68 65 72 65 20 69 73  | added. There is|
00001d10  20 61 20 22 64 75 73 74  62 69 6e 22 0a 62 75 74  | a "dustbin".but|
00001d20  74 6f 6e 20 20 77 68 69  63 68 20 77 69 6c 6c 20  |ton  which will |
00001d30  64 6f 20 6a 75 73 74 20  74 68 61 74 3a 20 62 75  |do just that: bu|
00001d40  74 20 64 6f 6e 27 74 20  75 73 65 20 69 74 20 79  |t don't use it y|
00001d50  65 74 2e 20 4d 61 6b 65  20 73 75 72 65 20 74 68  |et. Make sure th|
00001d60  61 74 20 74 68 65 0a 75  6e 77 61 6e 74 65 64 20  |at the.unwanted |
00001d70  72 65 63 6f 72 64 20 69  73 20 6f 6e 20 74 68 65  |record is on the|
00001d80  20 73 63 72 65 65 6e 20  61 6e 64 20 63 6c 69 63  | screen and clic|
00001d90  6b 20 74 68 65 20 62 75  74 74 6f 6e 20 74 6f 20  |k the button to |
00001da0  74 68 65 20 52 49 47 48  54 20 6f 66 20 74 68 65  |the RIGHT of the|
00001db0  0a 62 69 6e 2e 20 59 6f  75 20 77 69 6c 6c 20 6e  |.bin. You will n|
00001dc0  6f 77 20 66 69 6e 64 20  74 68 61 74 20 74 68 65  |ow find that the|
00001dd0  20 72 65 63 6f 72 64 20  68 61 73 20 76 61 6e 69  | record has vani|
00001de0  73 68 65 64 3b 20 74 68  65 20 6e 61 6d 65 73 20  |shed; the names |
00001df0  72 75 6e 20 73 74 72 61  69 67 68 74 0a 66 72 6f  |run straight.fro|
00001e00  6d 20 42 6c 6f 67 67 73  20 74 6f 20 43 61 76 65  |m Bloggs to Cave|
00001e10  6e 64 69 73 68 2c 20 6a  75 73 74 20 61 73 20 74  |ndish, just as t|
00001e20  68 65 79 20 64 69 64 20  62 65 66 6f 72 65 20 79  |hey did before y|
00001e30  6f 75 20 61 64 64 65 64  20 42 6f 64 6d 69 6e 2e  |ou added Bodmin.|
00001e40  0a 0a 57 61 73 6e 27 74  20 74 68 61 74 20 72 61  |..Wasn't that ra|
00001e50  74 68 65 72 20 54 4f 4f  20 65 61 73 79 3f 20 53  |ther TOO easy? S|
00001e60  75 70 70 6f 73 65 20 79  6f 75 20 63 6c 69 63 6b  |uppose you click|
00001e70  65 64 20 74 68 65 20 62  75 74 74 6f 6e 20 62 79  |ed the button by|
00001e80  20 6d 69 73 74 61 6b 65  20 61 6e 64 0a 64 65 6c  | mistake and.del|
00001e90  65 74 65 64 20 61 6e 20  69 6d 70 6f 72 74 61 6e  |eted an importan|
00001ea0  74 20 72 65 63 6f 72 64  21 20 50 6f 77 65 72 62  |t record! Powerb|
00001eb0  61 73 65 20 68 61 6e 64  6c 65 73 20 74 68 69 73  |ase handles this|
00001ec0  20 76 65 72 79 20 6e 69  63 65 6c 79 2e 20 54 68  | very nicely. Th|
00001ed0  65 20 72 65 63 6f 72 64  0a 68 61 73 6e 27 74 20  |e record.hasn't |
00001ee0  72 65 61 6c 6c 79 20 62  65 65 6e 20 64 65 6c 65  |really been dele|
00001ef0  74 65 64 20 61 74 20 61  6c 6c 2e 20 54 6f 20 70  |ted at all. To p|
00001f00  72 6f 76 65 20 74 68 69  73 2c 20 63 6c 69 63 6b  |rove this, click|
00001f10  20 74 68 65 20 62 75 74  74 6f 6e 20 61 62 6f 76  | the button abov|
00001f20  65 20 74 68 65 0a 6f 6e  65 20 79 6f 75 20 75 73  |e the.one you us|
00001f30  65 64 20 66 6f 72 20 22  64 65 6c 65 74 69 6e 67  |ed for "deleting|
00001f40  22 2e 20 54 68 65 20 62  75 74 74 6f 6e 20 73 68  |". The button sh|
00001f50  6f 77 73 20 61 20 67 72  65 65 6e 20 72 69 67 68  |ows a green righ|
00001f60  74 2d 70 6f 69 6e 74 69  6e 67 20 61 72 72 6f 77  |t-pointing arrow|
00001f70  0a 61 6e 64 20 61 20 22  63 61 72 64 20 69 6e 64  |.and a "card ind|
00001f80  65 78 22 20 69 63 6f 6e  2e 20 54 68 65 72 65 27  |ex" icon. There'|
00001f90  73 20 42 6f 64 6d 69 6e  20 61 67 61 69 6e 21 20  |s Bodmin again! |
00001fa0  59 6f 75 20 77 69 6c 6c  20 73 6f 6f 6e 20 66 69  |You will soon fi|
00001fb0  6e 64 20 74 68 61 74 20  69 74 0a 61 70 70 65 61  |nd that it.appea|
00001fc0  72 73 20 74 6f 20 62 65  20 74 68 65 20 4f 4e 4c  |rs to be the ONL|
00001fd0  59 20 72 65 63 6f 72 64  20 69 6e 20 74 68 65 20  |Y record in the |
00001fe0  66 69 6c 65 21 20 44 6f  6e 27 74 20 77 6f 72 72  |file! Don't worr|
00001ff0  79 3b 20 6e 6f 74 68 69  6e 67 20 68 61 73 20 62  |y; nothing has b|
00002000  65 65 6e 0a 6c 6f 73 74  2e 20 20 41 20 50 6f 77  |een.lost.  A Pow|
00002010  65 72 62 61 73 65 20 64  61 74 61 62 61 73 65 20  |erbase database |
00002020  69 73 20 74 72 65 61 74  65 64 20 61 73 20 73 69  |is treated as si|
00002030  78 20 73 65 70 61 72 61  74 65 20 53 55 42 46 49  |x separate SUBFI|
00002040  4c 45 53 20 20 6e 75 6d  62 65 72 65 64 0a 30 2d  |LES  numbered.0-|
00002050  35 2e 20 57 68 65 6e 20  79 6f 75 20 66 69 72 73  |5. When you firs|
00002060  74 20 6f 70 65 6e 20 74  68 65 20 64 61 74 61 62  |t open the datab|
00002070  61 73 65 20 79 6f 75 20  61 72 65 20 6c 6f 6f 6b  |ase you are look|
00002080  69 6e 67 20 61 74 20 53  75 62 66 69 6c 65 20 30  |ing at Subfile 0|
00002090  20 61 6e 64 20 74 68 65  0a 68 65 61 64 69 6e 67  | and the.heading|
000020a0  20 6f 66 20 74 68 65 20  72 65 63 6f 72 64 20 77  | of the record w|
000020b0  69 6e 64 6f 77 20 73 68  6f 77 73 20 74 68 69 73  |indow shows this|
000020c0  2e 20 49 66 20 79 6f 75  20 6c 6f 6f 6b 20 61 74  |. If you look at|
000020d0  20 74 68 65 20 68 65 61  64 69 6e 67 20 6e 6f 77  | the heading now|
000020e0  20 79 6f 75 0a 77 69 6c  6c 20 73 65 65 20 74 68  | you.will see th|
000020f0  61 74 20 69 74 20 68 61  73 20 63 68 61 6e 67 65  |at it has change|
00002100  64 20 74 6f 20 53 75 62  66 69 6c 65 20 31 2e 0a  |d to Subfile 1..|
00002110  0a 54 68 65 20 62 75 74  74 6f 6e 73 20 6f 6e 20  |.The buttons on |
00002120  65 69 74 68 65 72 20 73  69 64 65 20 6f 66 20 74  |either side of t|
00002130  68 65 20 62 69 6e 20 63  61 72 72 79 20 70 69 63  |he bin carry pic|
00002140  74 75 72 65 73 20 77 68  69 63 68 20 73 75 67 67  |tures which sugg|
00002150  65 73 74 20 74 68 65 69  72 0a 74 72 75 65 20 66  |est their.true f|
00002160  75 6e 63 74 69 6f 6e 73  2e 20 54 68 65 79 20 64  |unctions. They d|
00002170  6f 20 4e 4f 54 20 64 65  6c 65 74 65 20 72 65 63  |o NOT delete rec|
00002180  6f 72 64 73 3b 20 74 68  65 79 20 6d 65 72 65 6c  |ords; they merel|
00002190  79 20 4d 4f 56 45 20 72  65 63 6f 72 64 73 20 66  |y MOVE records f|
000021a0  72 6f 6d 0a 6f 6e 65 20  73 75 62 66 69 6c 65 20  |rom.one subfile |
000021b0  74 6f 20 61 6e 6f 74 68  65 72 2e 20 54 68 65 20  |to another. The |
000021c0  72 69 67 68 74 20 62 75  74 74 6f 6e 20 6d 6f 76  |right button mov|
000021d0  65 73 20 74 68 65 20 64  69 73 70 6c 61 79 65 64  |es the displayed|
000021e0  20 72 65 63 6f 72 64 20  74 6f 20 74 68 65 0a 6e  | record to the.n|
000021f0  65 78 74 20 73 75 62 66  69 6c 65 20 69 6e 20 73  |ext subfile in s|
00002200  65 71 75 65 6e 63 65 2e  20 54 68 75 73 2c 20 69  |equence. Thus, i|
00002210  6e 20 74 68 65 20 61 62  6f 76 65 20 63 61 73 65  |n the above case|
00002220  20 74 68 65 20 22 42 6f  64 6d 69 6e 22 20 72 65  | the "Bodmin" re|
00002230  63 6f 72 64 20 68 61 73  0a 62 65 65 6e 20 6d 6f  |cord has.been mo|
00002240  76 65 64 20 66 72 6f 6d  20 73 75 62 66 69 6c 65  |ved from subfile|
00002250  20 30 20 74 6f 20 73 75  62 66 69 6c 65 20 31 2e  | 0 to subfile 1.|
00002260  20 41 20 72 65 63 6f 72  64 20 69 6e 20 73 75 62  | A record in sub|
00002270  66 69 6c 65 20 31 20 77  6f 75 6c 64 20 62 65 20  |file 1 would be |
00002280  6d 6f 76 65 64 0a 74 6f  20 73 75 62 66 69 6c 65  |moved.to subfile|
00002290  20 32 20 61 6e 64 20 73  6f 20 6f 6e 2e 20 20 57  | 2 and so on.  W|
000022a0  68 61 74 20 68 61 70 70  65 6e 73 20 77 68 65 6e  |hat happens when|
000022b0  20 69 74 20 67 65 74 73  20 74 6f 20 35 3f 20 54  | it gets to 5? T|
000022c0  68 65 20 6e 65 78 74 20  63 6c 69 63 6b 0a 73 68  |he next click.sh|
000022d0  6f 76 65 73 20 69 74 20  69 6e 74 6f 20 73 75 62  |oves it into sub|
000022e0  66 69 6c 65 20 30 20 77  68 65 72 65 20 69 74 20  |file 0 where it |
000022f0  77 61 73 20 6f 72 69 67  69 6e 61 6c 6c 79 2e 20  |was originally. |
00002300  41 73 20 79 6f 75 20 6d  69 67 68 74 20 68 61 76  |As you might hav|
00002310  65 20 67 75 65 73 73 65  64 2c 0a 74 68 65 20 6c  |e guessed,.the l|
00002320  65 66 74 20 62 75 74 74  6f 6e 20 6d 6f 76 65 73  |eft button moves|
00002330  20 72 65 63 6f 72 64 73  20 69 6e 20 74 68 65 20  | records in the |
00002340  6f 70 70 6f 73 69 74 65  20 64 69 72 65 63 74 69  |opposite directi|
00002350  6f 6e 2c 20 69 2e 65 2e  20 66 72 6f 6d 20 73 75  |on, i.e. from su|
00002360  62 66 69 6c 65 20 31 0a  74 6f 20 30 20 6f 72 20  |bfile 1.to 0 or |
00002370  66 72 6f 6d 20 73 75 62  66 69 6c 65 20 30 20 74  |from subfile 0 t|
00002380  6f 20 35 2e 0a 0a 57 68  61 74 20 68 61 70 70 65  |o 5...What happe|
00002390  6e 73 20 77 68 65 6e 20  79 6f 75 20 44 4f 20 77  |ns when you DO w|
000023a0  61 6e 74 20 74 6f 20 6c  6f 73 65 20 61 20 72 65  |ant to lose a re|
000023b0  63 6f 72 64 20 66 6f 72  20 67 6f 6f 64 3f 20 20  |cord for good?  |
000023c0  54 68 61 74 27 73 20 77  68 65 6e 20 79 6f 75 0a  |That's when you.|
000023d0  63 6f 6e 73 69 67 6e 20  69 74 20 74 6f 20 74 68  |consign it to th|
000023e0  65 20 64 75 73 74 62 69  6e 21 20 20 53 69 6e 63  |e dustbin!  Sinc|
000023f0  65 20 74 68 69 73 20 62  75 74 74 6f 6e 27 73 20  |e this button's |
00002400  61 63 74 69 6f 6e 20 69  73 20 6d 6f 72 65 20 64  |action is more d|
00002410  72 61 73 74 69 63 20 74  68 61 6e 0a 74 68 61 74  |rastic than.that|
00002420  20 6f 66 20 74 68 65 20  6f 74 68 65 72 20 74 77  | of the other tw|
00002430  6f 20 79 6f 75 20 61 72  65 20 61 73 6b 65 64 20  |o you are asked |
00002440  66 6f 72 20 63 6f 6e 66  69 72 6d 61 74 69 6f 6e  |for confirmation|
00002450  20 62 65 66 6f 72 65 20  64 65 6c 65 74 69 6f 6e  | before deletion|
00002460  20 6f 63 63 75 72 73 2e  0a 0a 50 72 69 6e 74 69  | occurs...Printi|
00002470  6e 67 20 4c 69 73 74 73  0a 3d 3d 3d 3d 3d 3d 3d  |ng Lists.=======|
00002480  3d 3d 3d 3d 3d 3d 3d 0a  42 65 66 6f 72 65 20 50  |=======.Before P|
00002490  6f 77 65 72 62 61 73 65  20 63 61 6e 20 70 72 6f  |owerbase can pro|
000024a0  64 75 63 65 20 61 20 6c  69 73 74 20 69 74 20 6d  |duce a list it m|
000024b0  75 73 74 20 62 65 20 74  6f 6c 64 3a 0a 0a 20 20  |ust be told:..  |
000024c0  20 20 20 20 20 20 20 20  20 2a 20 77 68 69 63 68  |         * which|
000024d0  20 46 49 45 4c 44 53 20  73 68 6f 75 6c 64 20 61  | FIELDS should a|
000024e0  70 70 65 61 72 20 6f 6e  20 74 68 65 20 6c 69 73  |ppear on the lis|
000024f0  74 0a 20 20 20 20 20 20  20 20 20 20 20 2a 20 77  |t.           * w|
00002500  68 69 63 68 20 52 45 43  4f 52 44 53 20 73 68 6f  |hich RECORDS sho|
00002510  75 6c 64 20 61 70 70 65  61 72 20 6f 6e 20 74 68  |uld appear on th|
00002520  65 20 6c 69 73 74 2e 0a  0a 4d 61 6b 69 6e 67 20  |e list...Making |
00002530  74 68 65 20 66 69 65 6c  64 20 73 65 6c 65 63 74  |the field select|
00002540  69 6f 6e 0a 2d 2d 2d 2d  2d 2d 2d 2d 2d 2d 2d 2d  |ion.------------|
00002550  2d 2d 2d 2d 2d 2d 2d 2d  2d 2d 2d 2d 2d 2d 0a 53  |--------------.S|
00002560  70 65 63 69 66 79 69 6e  67 20 74 68 65 20 66 69  |pecifying the fi|
00002570  65 6c 64 73 20 79 6f 75  20 77 61 6e 74 20 69 73  |elds you want is|
00002580  20 65 78 74 72 65 6d 65  6c 79 20 65 61 73 79 2e  | extremely easy.|
00002590  20 54 6f 20 69 6e 63 6c  75 64 65 20 61 20 66 69  | To include a fi|
000025a0  65 6c 64 20 73 69 6d 70  6c 79 0a 70 6f 69 6e 74  |eld simply.point|
000025b0  20 74 68 65 20 6d 6f 75  73 65 20 61 74 20 69 74  | the mouse at it|
000025c0  20 61 6e 64 20 63 6c 69  63 6b 20 77 69 74 68 20  | and click with |
000025d0  41 44 4a 55 53 54 2e 20  54 68 65 20 73 65 6c 65  |ADJUST. The sele|
000025e0  63 74 65 64 20 66 69 65  6c 64 20 77 69 6c 6c 20  |cted field will |
000025f0  74 68 65 6e 0a 61 70 70  65 61 72 20 69 6e 20 69  |then.appear in i|
00002600  6e 76 65 72 73 65 20 76  69 64 65 6f 20 28 69 2e  |nverse video (i.|
00002610  65 2e 20 6e 6f 72 6d 61  6c 6c 79 20 77 68 69 74  |e. normally whit|
00002620  65 20 6f 6e 20 62 6c 61  63 6b 29 2e 20 49 66 20  |e on black). If |
00002630  79 6f 75 20 63 68 61 6e  67 65 20 79 6f 75 72 0a  |you change your.|
00002640  6d 69 6e 64 20 61 62 6f  75 74 20 61 20 66 69 65  |mind about a fie|
00002650  6c 64 20 79 6f 75 20 63  61 6e 20 64 65 2d 73 65  |ld you can de-se|
00002660  6c 65 63 74 20 69 74 20  62 79 20 63 6c 69 63 6b  |lect it by click|
00002670  69 6e 67 20 6f 6e 20 69  74 20 61 67 61 69 6e 20  |ing on it again |
00002680  77 69 74 68 20 41 44 4a  55 53 54 2e 0a 54 68 65  |with ADJUST..The|
00002690  20 6f 72 64 65 72 20 69  6e 20 77 68 69 63 68 20  | order in which |
000026a0  74 68 65 20 66 69 65 6c  64 73 20 77 69 6c 6c 20  |the fields will |
000026b0  61 70 70 65 61 72 20 69  6e 20 74 68 65 20 70 72  |appear in the pr|
000026c0  69 6e 74 65 64 20 6c 69  73 74 20 69 73 20 74 68  |inted list is th|
000026d0  65 20 6f 72 64 65 72 0a  69 6e 20 77 68 69 63 68  |e order.in which|
000026e0  20 79 6f 75 20 73 65 6c  65 63 74 20 74 68 65 6d  | you select them|
000026f0  2e 20 54 61 6b 65 20 63  61 72 65 20 77 69 74 68  |. Take care with|
00002700  20 74 68 69 73 20 73 69  6e 63 65 20 74 68 65 72  | this since ther|
00002710  65 20 69 73 20 6e 6f 74  68 69 6e 67 20 6f 6e 20  |e is nothing on |
00002720  74 68 65 0a 73 63 72 65  65 6e 20 74 6f 20 69 6e  |the.screen to in|
00002730  64 69 63 61 74 65 20 77  68 61 74 20 6f 72 64 65  |dicate what orde|
00002740  72 20 74 68 65 20 66 69  65 6c 64 73 20 77 69 6c  |r the fields wil|
00002750  6c 20 62 65 20 69 6e 2e  20 20 54 68 65 20 66 69  |l be in.  The fi|
00002760  65 6c 64 73 20 63 68 6f  73 65 6e 20 66 6f 72 0a  |elds chosen for.|
00002770  69 6e 63 6c 75 73 69 6f  6e 20 69 6e 20 61 20 70  |inclusion in a p|
00002780  72 69 6e 74 6f 75 74 20  6d 61 6b 65 20 75 70 20  |rintout make up |
00002790  61 20 53 45 4c 45 43 54  49 4f 4e 20 20 77 68 69  |a SELECTION  whi|
000027a0  63 68 20 6d 61 79 20 62  65 20 73 61 76 65 64 20  |ch may be saved |
000027b0  61 6e 64 20 72 65 6c 6f  61 64 65 64 0a 66 6f 72  |and reloaded.for|
000027c0  20 66 75 74 75 72 65 20  75 73 65 2e 20 4a 75 73  | future use. Jus|
000027d0  74 20 66 6f 72 20 6e 6f  77 20 73 65 6c 65 63 74  |t for now select|
000027e0  20 74 68 65 20 6e 61 6d  65 20 61 6e 64 20 74 68  | the name and th|
000027f0  65 20 66 69 72 73 74 20  33 20 66 69 65 6c 64 73  |e first 3 fields|
00002800  20 6f 66 20 74 68 65 0a  61 64 64 72 65 73 73 2e  | of the.address.|
00002810  0a 0a 43 68 6f 6f 73 69  6e 67 20 77 68 69 63 68  |..Choosing which|
00002820  20 72 65 63 6f 72 64 73  20 74 6f 20 70 72 69 6e  | records to prin|
00002830  74 0a 2d 2d 2d 2d 2d 2d  2d 2d 2d 2d 2d 2d 2d 2d  |t.--------------|
00002840  2d 2d 2d 2d 2d 2d 2d 2d  2d 2d 2d 2d 2d 2d 2d 2d  |----------------|
00002850  2d 0a 53 70 65 63 69 66  79 69 6e 67 20 77 68 69  |-.Specifying whi|
00002860  63 68 20 72 65 63 6f 72  64 73 20 74 6f 20 70 72  |ch records to pr|
00002870  69 6e 74 20 69 73 20 73  6f 6d 65 77 68 61 74 20  |int is somewhat |
00002880  6d 6f 72 65 20 63 6f 6d  70 6c 65 78 2c 20 61 6c  |more complex, al|
00002890  74 68 6f 75 67 68 20 65  66 66 6f 72 74 73 0a 68  |though efforts.h|
000028a0  61 76 65 20 62 65 65 6e  20 6d 61 64 65 20 74 6f  |ave been made to|
000028b0  20 72 65 6e 64 65 72 20  69 74 20 61 73 20 73 69  | render it as si|
000028c0  6d 70 6c 65 20 61 73 20  70 6f 73 73 69 62 6c 65  |mple as possible|
000028d0  2e 20 57 69 74 68 20 74  68 65 20 6d 6f 75 73 65  |. With the mouse|
000028e0  20 70 6f 69 6e 74 65 72  20 69 6e 0a 74 68 65 20  | pointer in.the |
000028f0  72 65 63 6f 72 64 20 77  69 6e 64 6f 77 20 63 6c  |record window cl|
00002900  69 63 6b 20 4d 45 4e 55  2e 20 54 68 69 73 20 64  |ick MENU. This d|
00002910  69 73 70 6c 61 79 73 20  74 68 65 20 6d 61 69 6e  |isplays the main|
00002920  20 50 6f 77 65 72 62 61  73 65 20 6d 65 6e 75 20  | Powerbase menu |
00002930  66 72 6f 6d 0a 77 68 69  63 68 20 79 6f 75 20 73  |from.which you s|
00002940  68 6f 75 6c 64 20 63 68  6f 6f 73 65 20 50 72 69  |hould choose Pri|
00002950  6e 74 2e 20 20 41 20 73  6d 61 6c 6c 20 77 69 6e  |nt.  A small win|
00002960  64 6f 77 20 61 70 70 65  61 72 73 20 69 6e 20 77  |dow appears in w|
00002970  68 69 63 68 20 79 6f 75  20 63 61 6e 0a 73 70 65  |hich you can.spe|
00002980  63 69 66 79 20 74 68 65  20 63 72 69 74 65 72 69  |cify the criteri|
00002990  61 20 77 68 69 63 68 20  6d 75 73 74 20 62 65 20  |a which must be |
000029a0  6d 65 74 20 62 79 20 72  65 63 6f 72 64 73 20 66  |met by records f|
000029b0  6f 72 20 69 6e 63 6c 75  73 69 6f 6e 20 69 6e 20  |or inclusion in |
000029c0  74 68 65 20 6c 69 73 74  2e 0a 49 66 20 79 6f 75  |the list..If you|
000029d0  20 6a 75 73 74 20 63 6c  69 63 6b 20 4f 4b 20 28  | just click OK (|
000029e0  6f 72 20 74 79 70 65 20  3c 52 65 74 75 72 6e 3e  |or type <Return>|
000029f0  29 20 77 69 74 68 6f 75  74 20 65 6e 74 65 72 69  |) without enteri|
00002a00  6e 67 20 61 6e 79 74 68  69 6e 67 20 68 65 72 65  |ng anything here|
00002a10  20 79 6f 75 0a 77 69 6c  6c 20 6f 62 74 61 69 6e  | you.will obtain|
00002a20  20 61 20 6c 69 73 74 20  6f 66 20 74 68 65 20 77  | a list of the w|
00002a30  68 6f 6c 65 20 64 61 74  61 62 61 73 65 20 28 6f  |hole database (o|
00002a40  72 2c 20 6d 6f 72 65 20  61 63 63 75 72 61 74 65  |r, more accurate|
00002a50  6c 79 2c 20 6f 66 20 74  68 65 20 74 68 65 0a 77  |ly, of the the.w|
00002a60  68 6f 6c 65 20 6f 66 20  74 68 65 20 63 75 72 72  |hole of the curr|
00002a70  65 6e 74 20 73 75 62 66  69 6c 65 29 2e 20 54 72  |ent subfile). Tr|
00002a80  79 20 74 68 69 73 20 66  69 72 73 74 2e 0a 0a 57  |y this first...W|
00002a90  68 65 6e 20 74 68 65 20  73 65 61 72 63 68 20 69  |hen the search i|
00002aa0  73 20 63 6f 6d 70 6c 65  74 65 20 74 68 65 20 6c  |s complete the l|
00002ab0  69 73 74 20 77 69 6c 6c  20 62 65 20 64 69 73 70  |ist will be disp|
00002ac0  6c 61 79 65 64 20 69 6e  20 61 20 77 69 6e 64 6f  |layed in a windo|
00002ad0  77 2e 20 49 66 20 79 6f  75 0a 70 6f 69 6e 74 20  |w. If you.point |
00002ae0  74 6f 20 61 20 72 65 63  6f 72 64 20 69 6e 20 74  |to a record in t|
00002af0  68 65 20 64 69 73 70 6c  61 79 65 64 20 6c 69 73  |he displayed lis|
00002b00  74 20 61 6e 64 20 64 6f  75 62 6c 65 2d 63 6c 69  |t and double-cli|
00002b10  63 6b 20 77 69 74 68 20  53 45 4c 45 43 54 0a 50  |ck with SELECT.P|
00002b20  6f 77 65 72 62 61 73 65  20 77 69 6c 6c 20 64 69  |owerbase will di|
00002b30  73 70 6c 61 79 20 74 68  65 20 63 68 6f 73 65 6e  |splay the chosen|
00002b40  20 72 65 63 6f 72 64 20  69 6e 20 74 68 65 20 6d  | record in the m|
00002b50  61 69 6e 20 72 65 63 6f  72 64 20 77 69 6e 64 6f  |ain record windo|
00002b60  77 2e 20 4e 6f 74 65 0a  74 68 61 74 20 74 68 65  |w. Note.that the|
00002b70  20 63 61 72 65 74 20 69  73 20 70 6c 61 63 65 64  | caret is placed|
00002b80  20 69 6e 20 74 68 65 20  66 69 65 6c 64 20 79 6f  | in the field yo|
00002b90  75 20 77 65 72 65 20 70  6f 69 6e 74 69 6e 67 20  |u were pointing |
00002ba0  74 6f 20 6f 6e 20 74 68  65 20 6c 69 73 74 2e 20  |to on the list. |
00002bb0  54 68 69 73 0a 69 73 20  76 65 72 79 20 75 73 65  |This.is very use|
00002bc0  66 75 6c 20 69 66 20 79  6f 75 20 73 70 6f 74 20  |ful if you spot |
00002bd0  65 72 72 6f 72 73 20 69  6e 20 74 68 65 20 64 61  |errors in the da|
00002be0  74 61 20 77 68 69 6c 73  74 20 65 78 61 6d 69 6e  |ta whilst examin|
00002bf0  69 6e 67 20 61 20 6c 69  73 74 2e 20 41 0a 64 6f  |ing a list. A.do|
00002c00  75 62 6c 65 20 63 6c 69  63 6b 20 6f 6e 20 74 68  |uble click on th|
00002c10  65 20 6f 66 66 65 6e 64  69 6e 67 20 69 74 65 6d  |e offending item|
00002c20  20 6f 66 66 65 72 73 20  74 68 65 20 72 65 63 6f  | offers the reco|
00002c30  72 64 20 77 69 74 68 20  74 68 65 20 63 61 72 65  |rd with the care|
00002c40  74 0a 63 6f 72 72 65 63  74 6c 79 20 70 6f 73 69  |t.correctly posi|
00002c50  74 69 6f 6e 65 64 20 66  6f 72 20 65 64 69 74 69  |tioned for editi|
00002c60  6e 67 2e 0a 0a 4d 6f 73  74 20 64 61 74 61 62 61  |ng...Most databa|
00002c70  73 65 20 71 75 65 72 69  65 73 2c 20 68 6f 77 65  |se queries, howe|
00002c80  76 65 72 2c 20 64 6f 6e  27 74 20 69 6e 76 6f 6c  |ver, don't invol|
00002c90  76 65 20 70 72 69 6e 74  69 6e 67 20 61 6c 6c 20  |ve printing all |
00002ca0  74 68 65 20 72 65 63 6f  72 64 73 21 20 59 6f 75  |the records! You|
00002cb0  0a 77 69 6c 6c 20 75 73  75 61 6c 6c 79 20 6e 65  |.will usually ne|
00002cc0  65 64 20 74 6f 20 65 6e  74 65 72 20 61 20 53 45  |ed to enter a SE|
00002cd0  41 52 43 48 20 46 4f 52  4d 55 4c 41 20 62 65 66  |ARCH FORMULA bef|
00002ce0  6f 72 65 20 63 6c 69 63  6b 69 6e 67 20 4f 4b 2e  |ore clicking OK.|
00002cf0  20 53 65 61 72 63 68 0a  66 6f 72 6d 75 6c 61 65  | Search.formulae|
00002d00  20 63 61 6e 20 62 65 20  71 75 69 74 65 20 63 6f  | can be quite co|
00002d10  6d 70 6c 65 78 20 61 6e  64 20 61 20 6d 6f 72 65  |mplex and a more|
00002d20  20 64 65 74 61 69 6c 65  64 20 74 72 65 61 74 6d  | detailed treatm|
00002d30  65 6e 74 20 69 73 20 67  69 76 65 6e 20 69 6e 0a  |ent is given in.|
00002d40  61 6e 6f 74 68 65 72 20  64 6f 63 75 6d 65 6e 74  |another document|
00002d50  2e 20 4f 6e 6c 79 20 61  20 66 65 77 20 73 69 6d  |. Only a few sim|
00002d60  70 6c 65 20 65 78 61 6d  70 6c 65 73 20 77 69 6c  |ple examples wil|
00002d70  6c 20 62 65 20 73 68 6f  77 6e 20 68 65 72 65 2e  |l be shown here.|
00002d80  0a 0a 45 6e 74 65 72 20  74 68 65 20 66 6f 6c 6c  |..Enter the foll|
00002d90  6f 77 69 6e 67 20 61 6e  64 20 63 6c 69 63 6b 20  |owing and click |
00002da0  4f 4b 3a 0a 0a 20 20 20  20 20 20 20 20 20 20 20  |OK:..           |
00002db0  20 20 20 20 20 41 44 44  32 3d 45 78 65 74 65 72  |     ADD2=Exeter|
00002dc0  0a 0a 54 68 65 20 72 65  70 6f 72 74 20 77 69 6e  |..The report win|
00002dd0  64 6f 77 20 61 70 70 65  61 72 73 20 73 68 6f 77  |dow appears show|
00002de0  69 6e 67 20 6a 75 73 74  20 6f 6e 65 20 72 65 63  |ing just one rec|
00002df0  6f 72 64 3a 20 74 68 65  20 6f 6e 65 20 66 6f 72  |ord: the one for|
00002e00  20 42 6c 6f 67 67 73 2e  20 41 44 44 32 0a 69 73  | Bloggs. ADD2.is|
00002e10  20 63 61 6c 6c 65 64 20  74 68 65 20 54 41 47 20  | called the TAG |
00002e20  6f 66 20 74 68 65 20 66  69 65 6c 64 2e 20 54 68  |of the field. Th|
00002e30  65 20 6c 61 62 65 6c 20  77 68 69 63 68 20 61 70  |e label which ap|
00002e40  70 65 61 72 73 20 62 65  73 69 64 65 20 61 20 66  |pears beside a f|
00002e50  69 65 6c 64 20 6f 6e 0a  74 68 65 20 73 63 72 65  |ield on.the scre|
00002e60  65 6e 20 69 73 20 63 61  6c 6c 65 64 20 69 74 73  |en is called its|
00002e70  20 44 45 53 43 52 49 50  54 4f 52 20 61 6e 64 20  | DESCRIPTOR and |
00002e80  79 6f 75 20 6d 69 67 68  74 20 68 61 76 65 20 65  |you might have e|
00002e90  78 70 65 63 74 65 64 20  73 75 63 68 0a 6c 61 62  |xpected such.lab|
00002ea0  65 6c 73 20 74 6f 20 62  65 20 75 73 65 64 20 74  |els to be used t|
00002eb0  6f 20 72 65 66 65 72 20  74 6f 20 66 69 65 6c 64  |o refer to field|
00002ec0  73 20 69 6e 20 73 65 61  72 63 68 20 66 6f 72 6d  |s in search form|
00002ed0  75 6c 61 65 2e 20 54 68  69 73 20 69 73 20 6e 6f  |ulae. This is no|
00002ee0  74 20 64 6f 6e 65 0a 66  6f 72 20 74 77 6f 20 72  |t done.for two r|
00002ef0  65 61 73 6f 6e 73 3a 0a  0a 28 31 29 20 44 65 73  |easons:..(1) Des|
00002f00  63 72 69 70 74 6f 72 73  20 63 61 6e 20 62 65 20  |criptors can be |
00002f10  69 6e 63 6f 6e 76 65 6e  69 65 6e 74 6c 79 20 6c  |inconveniently l|
00002f20  6f 6e 67 20 66 6f 72 20  75 73 65 20 69 6e 20 74  |ong for use in t|
00002f30  68 69 73 20 77 61 79 2e  0a 28 32 29 20 46 69 65  |his way..(2) Fie|
00002f40  6c 64 73 20 64 6f 6e 27  74 20 6e 65 63 65 73 73  |lds don't necess|
00002f50  61 72 69 6c 79 20 68 61  76 65 20 64 65 73 63 72  |arily have descr|
00002f60  69 70 74 6f 72 73 2e 20  4f 66 20 74 68 65 20 35  |iptors. Of the 5|
00002f70  20 61 64 64 72 65 73 73  20 66 69 65 6c 64 73 20  | address fields |
00002f80  6f 6e 6c 79 0a 74 68 65  20 66 69 72 73 74 20 68  |only.the first h|
00002f90  61 73 20 61 20 64 65 73  63 72 69 70 74 6f 72 20  |as a descriptor |
00002fa0  28 41 44 44 52 45 53 53  29 2e 20 53 69 6e 63 65  |(ADDRESS). Since|
00002fb0  20 65 76 65 72 79 20 64  61 74 61 20 66 69 65 6c  | every data fiel|
00002fc0  64 20 6e 65 65 64 73 20  61 0a 22 68 61 6e 64 6c  |d needs a."handl|
00002fd0  65 22 20 6f 66 20 73 6f  6d 65 20 73 6f 72 74 20  |e" of some sort |
00002fe0  77 65 20 67 69 76 65 20  65 61 63 68 20 61 20 74  |we give each a t|
00002ff0  61 67 2c 20 77 68 69 63  68 20 69 73 20 6e 65 76  |ag, which is nev|
00003000  65 72 20 6d 6f 72 65 20  74 68 61 6e 20 34 0a 63  |er more than 4.c|
00003010  68 61 72 61 63 74 65 72  73 2e 20 43 6c 69 63 6b  |haracters. Click|
00003020  69 6e 67 20 4d 45 4e 55  20 6f 76 65 72 20 61 20  |ing MENU over a |
00003030  66 69 65 6c 64 20 6d 61  6b 65 73 20 69 74 73 20  |field makes its |
00003040  74 61 67 20 61 70 70 65  61 72 20 69 6e 20 74 68  |tag appear in th|
00003050  65 20 73 65 63 6f 6e 64  0a 6d 65 6e 75 20 69 74  |e second.menu it|
00003060  65 6d 2e 0a 0a 59 6f 75  20 6d 61 79 20 68 61 76  |em...You may hav|
00003070  65 20 6e 6f 74 69 63 65  64 20 74 68 61 74 20 42  |e noticed that B|
00003080  6c 6f 67 67 73 27 20 69  73 20 6e 6f 74 20 74 68  |loggs' is not th|
00003090  65 20 6f 6e 6c 79 20 61  64 64 72 65 73 73 20 69  |e only address i|
000030a0  6e 20 45 78 65 74 65 72  2e 20 54 68 65 72 65 0a  |n Exeter. There.|
000030b0  69 73 20 61 6e 6f 74 68  65 72 20 6f 6e 65 20 62  |is another one b|
000030c0  75 74 20 77 69 74 68 20  45 78 65 74 65 72 20 69  |ut with Exeter i|
000030d0  6e 20 41 44 44 52 33 20  72 61 74 68 65 72 20 74  |n ADDR3 rather t|
000030e0  68 61 6e 20 41 44 44 52  32 2e 20 43 61 6e 20 77  |han ADDR2. Can w|
000030f0  65 20 70 72 69 6e 74 20  62 6f 74 68 0a 6f 6e 20  |e print both.on |
00003100  74 68 65 20 73 61 6d 65  20 6c 69 73 74 3f 20 59  |the same list? Y|
00003110  65 73 20 77 65 20 63 61  6e 21 20 54 68 65 20 66  |es we can! The f|
00003120  6f 72 6d 75 6c 61 20 6e  65 65 64 65 64 20 69 73  |ormula needed is|
00003130  3a 0a 0a 20 20 20 20 20  20 20 20 20 20 20 20 20  |:..             |
00003140  20 20 20 41 44 44 32 2c  41 44 44 33 3d 45 78 65  |   ADD2,ADD3=Exe|
00003150  74 65 72 0a 0a 4e 6f 74  69 63 65 20 74 68 65 20  |ter..Notice the |
00003160  77 61 79 20 74 68 65 20  61 6c 74 65 72 6e 61 74  |way the alternat|
00003170  69 76 65 20 74 61 67 73  20 61 72 65 20 73 65 70  |ive tags are sep|
00003180  61 72 61 74 65 64 20 62  79 20 63 6f 6d 6d 61 73  |arated by commas|
00003190  2e 20 57 65 20 63 61 6c  6c 20 74 68 69 73 20 61  |. We call this a|
000031a0  0a 54 41 47 20 4c 49 53  54 2e 20 41 20 72 65 63  |.TAG LIST. A rec|
000031b0  6f 72 64 20 77 69 6c 6c  20 62 65 20 70 72 69 6e  |ord will be prin|
000031c0  74 65 64 20 69 66 20 41  4e 59 20 6f 66 20 74 68  |ted if ANY of th|
000031d0  65 20 74 61 67 73 20 69  6e 20 74 68 65 20 74 61  |e tags in the ta|
000031e0  67 20 6c 69 73 74 20 61  72 65 0a 6d 61 74 63 68  |g list are.match|
000031f0  65 64 2e 20 54 68 65 20  70 61 72 74 20 6f 66 20  |ed. The part of |
00003200  74 68 65 20 73 65 61 72  63 68 20 66 6f 72 6d 75  |the search formu|
00003210  6c 61 20 61 66 74 65 72  20 74 68 65 20 3d 20 73  |la after the = s|
00003220  69 67 6e 20 69 73 20 74  68 65 20 54 41 52 47 45  |ign is the TARGE|
00003230  54 20 61 6e 64 0a 68 65  72 65 20 74 6f 6f 20 77  |T and.here too w|
00003240  65 20 6d 61 79 20 73 70  65 63 69 66 79 20 73 65  |e may specify se|
00003250  76 65 72 61 6c 20 6f 66  20 74 68 65 6d 20 69 6e  |veral of them in|
00003260  20 61 20 54 41 52 47 45  54 20 4c 49 53 54 2e 20  | a TARGET LIST. |
00003270  54 72 79 20 74 68 65 20  66 6f 6c 6c 6f 77 69 6e  |Try the followin|
00003280  67 3a 0a 0a 20 20 20 20  20 20 20 20 20 20 20 20  |g:..            |
00003290  20 20 20 20 41 44 44 33  3d 45 78 65 74 65 72 2c  |    ADD3=Exeter,|
000032a0  41 6e 79 74 6f 77 6e 0a  0a 61 6e 64 20 61 6c 73  |Anytown..and als|
000032b0  6f 3a 20 20 20 20 20 20  20 41 44 44 32 2c 41 44  |o:       ADD2,AD|
000032c0  44 33 3d 45 78 65 74 65  72 2c 41 6e 79 74 6f 77  |D3=Exeter,Anytow|
000032d0  6e 0a 0a 54 68 65 20 63  68 61 72 61 63 74 65 72  |n..The character|
000032e0  73 20 77 65 20 77 61 6e  74 20 74 6f 20 6d 61 74  |s we want to mat|
000032f0  63 68 20 64 6f 6e 27 74  2c 20 6f 66 20 63 6f 75  |ch don't, of cou|
00003300  72 73 65 2c 20 61 6c 77  61 79 73 20 6d 61 6b 65  |rse, always make|
00003310  20 75 70 20 74 68 65 20  65 6e 74 69 72 65 0a 66  | up the entire.f|
00003320  69 65 6c 64 2e 20 43 61  6e 20 77 65 20 73 65 61  |ield. Can we sea|
00003330  72 63 68 20 66 6f 72 20  50 41 52 54 20 6f 66 20  |rch for PART of |
00003340  61 20 66 69 65 6c 64 2e  20 59 65 73 20 69 6e 64  |a field. Yes ind|
00003350  65 65 64 21 20 53 75 70  70 6f 73 65 20 79 6f 75  |eed! Suppose you|
00003360  20 77 61 6e 74 65 64 20  74 68 65 0a 72 65 63 6f  | wanted the.reco|
00003370  72 64 73 20 66 6f 72 20  70 65 6f 70 6c 65 20 63  |rds for people c|
00003380  61 6c 6c 65 64 20 50 65  74 65 72 2c 20 46 72 65  |alled Peter, Fre|
00003390  64 20 61 6e 64 20 4a 65  61 6e 2e 20 45 6e 74 65  |d and Jean. Ente|
000033a0  72 20 74 68 65 20 66 6f  72 6d 75 6c 61 3a 0a 0a  |r the formula:..|
000033b0  20 20 20 20 20 20 20 20  20 20 20 20 20 20 20 20  |                |
000033c0  4e 41 4d 45 7b 50 65 74  65 72 2c 46 72 65 64 2c  |NAME{Peter,Fred,|
000033d0  4a 65 61 6e 0a 0a 61 6e  64 20 79 6f 75 20 77 69  |Jean..and you wi|
000033e0  6c 6c 20 66 69 6e 64 20  74 68 61 74 20 74 68 65  |ll find that the|
000033f0  20 72 65 63 6f 72 64 73  20 66 6f 72 20 50 65 74  | records for Pet|
00003400  65 72 20 42 61 64 67 65  72 79 2c 20 46 72 65 64  |er Badgery, Fred|
00003410  20 42 6c 6f 67 67 73 20  61 6e 64 20 4a 65 61 6e  | Bloggs and Jean|
00003420  0a 46 6f 72 64 20 61 72  65 20 70 72 69 6e 74 65  |.Ford are printe|
00003430  64 2e 20 54 68 65 20 7b  20 28 6c 65 66 74 20 63  |d. The { (left c|
00003440  75 72 6c 79 20 62 72 61  63 6b 65 74 29 20 6d 65  |urly bracket) me|
00003450  61 6e 73 20 22 63 6f 6e  74 61 69 6e 73 22 2e 20  |ans "contains". |
00003460  69 2e 65 2e 20 74 68 65  20 6e 61 6d 65 0a 66 69  |i.e. the name.fi|
00003470  65 6c 64 20 64 6f 65 73  6e 27 74 20 68 61 76 65  |eld doesn't have|
00003480  20 74 6f 20 43 4f 4e 53  49 53 54 20 6f 66 20 50  | to CONSIST of P|
00003490  65 74 65 72 2c 20 6f 72  20 46 72 65 64 20 6f 72  |eter, or Fred or|
000034a0  20 4a 65 61 6e 2c 20 62  75 74 20 68 61 73 20 74  | Jean, but has t|
000034b0  6f 20 43 4f 4e 54 41 49  4e 0a 6f 6e 65 20 6f 66  |o CONTAIN.one of|
000034c0  20 74 68 65 73 65 20 6e  61 6d 65 73 20 73 6f 6d  | these names som|
000034d0  65 77 68 65 72 65 20 77  69 74 68 69 6e 20 69 74  |ewhere within it|
000034e0  2e 0a 0a 48 61 72 64 20  63 6f 70 79 0a 2d 2d 2d  |...Hard copy.---|
000034f0  2d 2d 2d 2d 2d 2d 0a 53  6f 20 66 61 72 20 79 6f  |------.So far yo|
00003500  75 20 68 61 76 65 20 6f  6e 6c 79 20 64 69 73 70  |u have only disp|
00003510  6c 61 79 65 64 20 72 65  70 6f 72 74 73 20 69 6e  |layed reports in|
00003520  20 61 20 77 69 6e 64 6f  77 2e 20 57 68 61 74 20  | a window. What |
00003530  69 66 20 79 6f 75 20 77  61 6e 74 20 74 6f 20 73  |if you want to s|
00003540  65 6e 64 0a 74 68 65 6d  20 74 6f 20 79 6f 75 72  |end.them to your|
00003550  20 70 72 69 6e 74 65 72  3f 20 4e 6f 74 68 69 6e  | printer? Nothin|
00003560  67 20 63 6f 75 6c 64 20  62 65 20 65 61 73 69 65  |g could be easie|
00003570  72 2e 20 4c 6f 61 64 20  75 70 20 21 50 72 69 6e  |r. Load up !Prin|
00003580  74 65 72 73 2c 20 73 77  69 74 63 68 20 6f 6e 0a  |ters, switch on.|
00003590  74 68 65 20 70 72 69 6e  74 65 72 20 74 68 65 6e  |the printer then|
000035a0  20 63 6c 69 63 6b 20 4d  45 4e 55 20 6f 76 65 72  | click MENU over|
000035b0  20 74 68 65 20 64 69 73  70 6c 61 79 65 64 20 72  | the displayed r|
000035c0  65 70 6f 72 74 2e 20 27  53 61 76 65 20 61 73 20  |eport. 'Save as |
000035d0  74 65 78 74 27 20 6c 65  61 64 73 0a 74 6f 20 61  |text' leads.to a|
000035e0  20 73 74 61 6e 64 61 72  64 20 27 53 61 76 65 27  | standard 'Save'|
000035f0  20 62 6f 78 20 66 72 6f  6d 20 77 68 69 63 68 20  | box from which |
00003600  79 6f 75 20 63 61 6e 20  64 72 61 67 20 74 68 65  |you can drag the|
00003610  20 66 69 6c 65 20 69 63  6f 6e 20 74 6f 20 21 50  | file icon to !P|
00003620  72 69 6e 74 65 72 73 2e  0a 59 6f 75 20 63 6f 75  |rinters..You cou|
00003630  6c 64 2c 20 6f 66 20 63  6f 75 72 73 65 2c 20 61  |ld, of course, a|
00003640  6c 73 6f 20 64 72 61 67  20 69 74 20 74 6f 20 61  |lso drag it to a|
00003650  20 64 69 72 65 63 74 6f  72 79 20 77 69 6e 64 6f  | directory windo|
00003660  77 20 74 6f 20 73 61 76  65 20 69 74 2e 20 4f 72  |w to save it. Or|
00003670  20 79 6f 75 0a 63 6f 75  6c 64 20 73 69 6d 70 6c  | you.could simpl|
00003680  79 20 74 79 70 65 20 3c  52 65 74 75 72 6e 3e 2c  |y type <Return>,|
00003690  20 69 6e 20 77 68 69 63  68 20 63 61 73 65 20 74  | in which case t|
000036a0  68 65 20 72 65 70 6f 72  74 20 77 6f 75 6c 64 20  |he report would |
000036b0  62 65 20 73 61 76 65 64  20 77 69 74 68 20 74 68  |be saved with th|
000036c0  65 0a 64 65 66 61 75 6c  74 20 6e 61 6d 65 20 27  |e.default name '|
000036d0  4c 69 73 74 27 20 69 6e  20 61 20 64 69 72 65 63  |List' in a direc|
000036e0  74 6f 72 79 20 63 61 6c  6c 65 64 20 27 50 72 69  |tory called 'Pri|
000036f0  6e 74 4a 6f 62 73 27 20  77 68 69 63 68 20 69 73  |ntJobs' which is|
00003700  20 69 6e 73 69 64 65 20  74 68 65 0a 27 46 72 69  | inside the.'Fri|
00003710  65 6e 64 73 27 20 64 61  74 61 62 61 73 65 20 64  |ends' database d|
00003720  69 72 65 63 74 6f 72 79  2e 20 45 76 65 72 79 20  |irectory. Every |
00003730  50 6f 77 65 72 62 61 73  65 20 64 61 74 61 62 61  |Powerbase databa|
00003740  73 65 20 68 61 73 20 61  20 27 50 72 69 6e 74 4a  |se has a 'PrintJ|
00003750  6f 62 73 27 0a 64 69 72  65 63 74 6f 72 79 20 74  |obs'.directory t|
00003760  6f 20 75 73 65 20 61 73  20 61 20 67 65 6e 65 72  |o use as a gener|
00003770  61 6c 20 22 64 75 6d 70  69 6e 67 20 67 72 6f 75  |al "dumping grou|
00003780  6e 64 22 20 66 6f 72 20  67 65 6e 65 72 61 74 65  |nd" for generate|
00003790  64 20 6f 75 74 70 75 74  2e 20 53 75 63 68 0a 64  |d output. Such.d|
000037a0  69 72 65 63 74 6f 72 69  65 73 20 61 72 65 20 61  |irectories are a|
000037b0  70 74 20 74 6f 20 67 65  74 20 63 6c 75 74 74 65  |pt to get clutte|
000037c0  72 65 64 20 61 6e 64 20  6e 65 65 64 20 22 6d 75  |red and need "mu|
000037d0  63 6b 69 6e 67 20 6f 75  74 22 20 66 72 6f 6d 20  |cking out" from |
000037e0  74 69 6d 65 20 74 6f 0a  74 69 6d 65 2e 20 20 20  |time to.time.   |
000037f0  20 20 20 20 20 0a 0a 43  6c 6f 73 69 6e 67 20 64  |     ..Closing d|
00003800  6f 77 6e 0a 3d 3d 3d 3d  3d 3d 3d 3d 3d 3d 3d 3d  |own.============|
00003810  0a 41 20 64 61 74 61 62  61 73 65 20 6d 61 79 20  |.A database may |
00003820  62 65 20 63 6c 6f 73 65  64 20 64 6f 77 6e 20 62  |be closed down b|
00003830  79 20 63 68 6f 6f 73 69  6e 67 20 74 68 65 20 43  |y choosing the C|
00003840  6c 6f 73 65 20 64 61 74  61 62 61 73 65 20 65 6e  |lose database en|
00003850  74 72 79 20 66 72 6f 6d  20 74 68 65 0a 69 63 6f  |try from the.ico|
00003860  6e 20 62 61 72 20 6d 65  6e 75 2e 20 57 68 65 6e  |n bar menu. When|
00003870  20 79 6f 75 20 64 6f 20  73 6f 20 61 6c 6c 20 72  | you do so all r|
00003880  65 6c 65 76 61 6e 74 20  64 61 74 61 20 73 74 6f  |elevant data sto|
00003890  72 65 64 20 69 6e 20 6d  65 6d 6f 72 79 20 69 73  |red in memory is|
000038a0  20 73 61 76 65 64 20 74  6f 0a 64 69 73 63 20 61  | saved to.disc a|
000038b0  6e 64 20 74 68 65 20 64  61 74 61 62 61 73 65 20  |nd the database |
000038c0  69 73 20 63 6c 6f 73 65  64 2e 20 59 6f 75 20 64  |is closed. You d|
000038d0  6f 20 6e 6f 74 20 68 61  76 65 20 74 6f 20 64 6f  |o not have to do|
000038e0  20 61 6e 79 74 68 69 6e  67 20 74 6f 20 73 61 76  | anything to sav|
000038f0  65 20 74 68 65 0a 64 61  74 61 62 61 73 65 20 66  |e the.database f|
00003900  69 6c 65 20 69 74 73 65  6c 66 20 74 6f 20 64 69  |ile itself to di|
00003910  73 63 20 73 69 6e 63 65  20 69 74 20 68 61 73 20  |sc since it has |
00003920  62 65 65 6e 20 74 68 65  72 65 20 61 6c 6c 20 61  |been there all a|
00003930  6c 6f 6e 67 2e 20 4f 6e  6c 79 20 74 68 65 0a 63  |long. Only the.c|
00003940  75 72 72 65 6e 74 20 72  65 63 6f 72 64 20 69 73  |urrent record is|
00003950  20 69 6e 20 6d 65 6d 6f  72 79 20 61 74 20 61 6e  | in memory at an|
00003960  79 20 6f 6e 65 20 74 69  6d 65 20 61 6e 64 20 74  |y one time and t|
00003970  68 69 73 20 69 73 20 61  75 74 6f 6d 61 74 69 63  |his is automatic|
00003980  61 6c 6c 79 0a 77 72 69  74 74 65 6e 20 62 61 63  |ally.written bac|
00003990  6b 20 74 6f 20 64 69 73  63 20 77 68 65 6e 20 69  |k to disc when i|
000039a0  74 20 68 61 73 20 62 65  65 6e 20 63 68 61 6e 67  |t has been chang|
000039b0  65 64 20 69 6e 20 61 6e  79 20 77 61 79 2e 0a 0a  |ed in any way...|
000039c0  49 66 20 79 6f 75 20 61  72 65 20 67 6f 69 6e 67  |If you are going|
000039d0  20 74 6f 20 75 73 65 20  61 6e 6f 74 68 65 72 20  | to use another |
000039e0  64 61 74 61 62 61 73 65  20 73 74 72 61 69 67 68  |database straigh|
000039f0  74 20 61 77 61 79 20 6a  75 73 74 20 64 6f 75 62  |t away just doub|
00003a00  6c 65 20 63 6c 69 63 6b  20 6f 6e 0a 69 74 20 6f  |le click on.it o|
00003a10  72 20 64 72 61 67 20 69  74 20 74 6f 20 74 68 65  |r drag it to the|
00003a20  20 50 6f 77 65 72 62 61  73 65 20 69 63 6f 6e 20  | Powerbase icon |
00003a30  6f 6e 20 74 68 65 20 69  63 6f 6e 20 62 61 72 2e  |on the icon bar.|
00003a40  20 49 6e 20 66 61 63 74  20 79 6f 75 20 64 6f 6e  | In fact you don|
00003a50  27 74 20 65 76 65 6e 0a  6e 65 65 64 20 74 6f 20  |'t even.need to |
00003a60  63 6c 6f 73 65 20 74 68  65 20 70 72 65 76 69 6f  |close the previo|
00003a70  75 73 20 64 61 74 61 62  61 73 65 20 62 65 66 6f  |us database befo|
00003a80  72 65 20 64 6f 69 6e 67  20 74 68 69 73 3b 20 50  |re doing this; P|
00003a90  6f 77 65 72 62 61 73 65  20 77 69 6c 6c 20 64 6f  |owerbase will do|
00003aa0  20 69 74 0a 66 6f 72 20  79 6f 75 2e 0a 0a 57 68  | it.for you...Wh|
00003ab0  65 6e 20 77 6f 72 6b 69  6e 67 20 77 69 74 68 20  |en working with |
00003ac0  61 20 64 61 74 61 62 61  73 65 20 6f 6e 20 74 68  |a database on th|
00003ad0  65 20 52 41 4d 20 64 69  73 63 20 50 6f 77 65 72  |e RAM disc Power|
00003ae0  62 61 73 65 20 77 69 6c  6c 20 69 73 73 75 65 20  |base will issue |
00003af0  61 20 77 61 72 6e 69 6e  67 0a 74 68 61 74 20 74  |a warning.that t|
00003b00  68 65 20 64 61 74 61 20  69 73 20 6e 6f 74 20 73  |he data is not s|
00003b10  65 63 75 72 65 20 61 6e  64 20 74 68 61 74 20 79  |ecure and that y|
00003b20  6f 75 20 6e 65 65 64 20  74 6f 20 64 72 61 67 20  |ou need to drag |
00003b30  69 74 20 66 72 6f 6d 20  74 68 65 20 52 41 4d 20  |it from the RAM |
00003b40  64 69 73 63 0a 74 6f 20  61 20 66 6c 6f 70 70 79  |disc.to a floppy|
00003b50  20 6f 72 20 68 61 72 64  20 64 69 73 63 20 62 65  | or hard disc be|
00003b60  66 6f 72 65 20 73 77 69  74 63 68 69 6e 67 20 6f  |fore switching o|
00003b70  66 66 2e 0a 0a 54 6f 20  74 65 72 6d 69 6e 61 74  |ff...To terminat|
00003b80  65 20 50 6f 77 65 72 62  61 73 65 20 69 74 73 65  |e Powerbase itse|
00003b90  6c 66 20 75 73 65 20 74  68 65 20 51 75 69 74 20  |lf use the Quit |
00003ba0  6f 70 74 69 6f 6e 20 6f  6e 20 74 68 65 20 69 63  |option on the ic|
00003bb0  6f 6e 20 62 61 72 20 6d  65 6e 75 2e 0a 0a 0a 0a  |on bar menu.....|
00003bc0