Home » Archimedes archive » Archimedes World » AW-1994-04-Disc2.adf » Disk2Apr94 » !AWApr94/Goodies/PowerBase/PBaseDoc/Create
!AWApr94/Goodies/PowerBase/PBaseDoc/Create
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/Create |
| Read OK: | ✔ |
| File size: | 5DCD bytes |
| Load address: | 0000 |
| Exec address: | 0000 |
File contents
Creating a New Database
=======================
To create a new database you need to go through five steps:-
(i) Create the database application shell.
(ii) Design the record screen.
(iii) Specify the number of records the database is to contain.
(iv) Specify the primary key.
(v) Build the empty database.
Each of these will be described in the order just given.
Creating the database application shell
=======================================
You need to have Powerbase installed on the icon bar but with no database
open, i.e. 'No data' should appear under the icon. Click SELECT over the
icon and a save box will appear. Type in the name of your database and drag
the database icon to a directory viewer. Remember that it cannot exceed 10
characters, including the initial "!". If you enter more the name will be
truncated and you could end up overwriting an existing database with a
similar name. You don't actually need to enter the "!"; Powerbase will
insert it automatically.
If you open the newly-created application directory (SHIFT/double click) you
will find that it contains files called !Boot, !Run, !Sprites, chkspr and
Colours and four subdirectories called Indices, PrintJobs, PrintRes and
ValTables. All Powerbase applications require these objects to be present so
don't delete any of them.
Designing the record screen
===========================
When you created the application shell you were left with a blank window on
screen and it is on this window that you must design your database record.
This is the lengthiest and trickiest part of setting up any database,
although efforts have been made to render it as painless as possible. If you
have closed the window just click on the Powerbase icon on the icon bar to
re-display it.
Clicking MENU over the window brings up the 'New database' menu on which
every item except 'Design field' and 'Help' is shaded at this stage. The
'Design field' choice leads to a dialogue box which allows you to specify the
characteristics of a field. First you must decide what category of field you
want to create. There are four such categories, selected via radio buttons:-
(i) Data (ii) External (iii) Button (iv) Check-box
For the present we will confine ourselves to the first, which is the default
selection. As well as the field category you must decide on the type of
field within the category. Most fields are of 'Alphanumeric' type and that
is offered as the default. We'll see about other types later.
Decide on a name for the field and enter it in the 'Descriptor' icon. This
is the name which will appear on the record window and may be up to 40
characters long. You should also enter a 'Tag', which is limited to 4
characters. Next enter the 'Data length'; the maximum number of characters
the field is to hold. Values up to 246 are allowed. Now click on 'Create'
and the field will appear on the record window. It's probably not where you
want it so use SELECT to drag the white rectangle to the position required.
When you drop the field in its new position you'll see that the descriptor
falls into place too. If you want the descriptor somewhere other than to the
left of the data icon (above it, for example) then you can move the
descriptor by itself without the data icon moving.
Basically that's all you actually need to do in order to create fields.
Mistakes may be corrected by clicking MENU over the field to be altered and
making the required changes. You then click on 'Update' rather than 'Create'
('Create' is shaded, in fact). A field may be deleted by clicking MENU over
it then clicking on 'Remove'. To insert a field into the middle of a record
you must enter the number of the field which must follow the new one in the
space provided. Clicking 'Create' will then create the field in the
correct place in the field sequence. It isn't sufficient to just drag the
fields around - the order in which they are accessed when the database is in
use won't be altered by that.
You might want to change the sequence of fields without recourse to the
tedious method of deleting a field and then re-creating and inserting it.
Ther are two ways of doing this. Click MENU over an exisitng field to bring
up the dialogue box. We will call this the "current field". Enter the number
of another existing field in the same place as was used above to specify the
insertion position of a new field. We'll call this the "entered field". The
two button 'Swap with' and 'Renumber as' may then be used. 'Swap with' does
exactly what you would expect: it swaps the positions of the current field
and the entered field in the field sequence.
The action of 'Renumber as' is more complex. The current field acquires the
number of the entered field. If this involves giving the current field a
lower number than previously the fields above the new position are all moved
up one place to open a gap for it, at the same time closing up the gap left
by moving the current field from its old position. If it is being given a
higher number the fields above its old position all move down one place,
closing up the gap left by its removal and opening a gap in the required
place farther up the sequence.
You can, if you wish, build up the record by creating more fields in the
same way and then go straight to the next main section (Specifying the
database size). If, however, you want more at this stage read on!
Re-sizing the bounding box
--------------------------
Left to itself Powerbase makes all its field icons the same height and of a
suitable length to contain the number of characters specified in 'Data
length'. This may not be quite what you want. If the Data length is more
than about 70 the field runs off the right edge of the window. You may also
want to make the field taller for emphasis. (But NOT for displaying multiple
lines. Only fields of 'Text block' type can be multi-line. These are
discussed later.) There are two ways of altering the size of a field's
bounding box:-
(a) By dragging with ADJUST.
(b) By typing in the required width and height in the 'Data field'
dialogue box. The units used are such that, in the most common
screen modes such as 12 and 15, a character is 16 units wide and 32
high and the screen itself is 1240 units wide and 1024 high. (N.B.
the default height for bounding boxes is 48 units.)
Besides altering the size of the bounding box by typing the data directly,
you may adjust its position in the same way by entering the X and Y
co-ordinates of the lower left corner. The units are the same as for width
and height but the origin is the TOP left corner of the record window. This
means that the Y values are always negative.
More about tags and descriptors
-------------------------------
Tags are of great importance in Powerbase. They are used when querying the
database to produce reports, export CSV files etc. and also by some internal
operations. Every writable field must have a tag and no two fields may have
the same tag. Descriptors are less important. Their main purpose is to
provide visible labels for fields and in some cases you may not need a
descriptor at all. e.g. If your database is to hold names and addresses you
might want the record to look like this:-
NAME Fred Bloggs
ADDRESS 27, Every Street
Anytown
Woolshire
WL4 7XZ
There are 5 fields here but, having given the second one the descriptor
ADDRESS, you don't really want descriptors for the remaining 3 (except
perhaps POSTCODE for the last). It is quite in order to have null
descriptors like this, but your MUST give each field a tag. Suitable ones
might be NAME, ADD1, ADD2, ADD3, ADD4. (Remember they must be unique and not
more than 4 characters.)
The only cases in which you may omit the tag is where the field is simply an
explanatory label and contains no actual data so that there would be no
reason to include it in a query.
Other types of Data field
-------------------------
So far we have only used fields of 'Alphanumeric' type. Clicking on the
"bump icons" to the left of the field type lets you cycle through the
various types available. These are:-
(a) None Accepts any printable character.
(b) Alphanumeric Accepts all letters and numerals and common
punctuation.
(c) Upper case Accepts capital letters and numerals only.
(d) Number Accepts numerals,+,- and . (decimal point).
(e) Yes/No Accepts Y and N only
(d) Date Accepts dates in the form dd-mm-yy or
dd-mm-yyyy.
(e) Calculated Can't be typed into directly. Takes its
value from other (Numeric) fields.
(f) Composite Similar to a Calculated field, but for
textual rather than numeric data.
(g) Time Accepts times in the form hh:mm:ss up to
a maximum value of 23:59:59.
As an alternative to the "bump" icons you may click with SELECT or MENU on
the right-pointing arrow to the right of the field-type icon. This displays
a menu of field types from which to make your choice.
When 'Numeric' or 'Calculated' is selected, certain icons in the dialogue
box which are normally shaded become available. Thus, you can make such a
field of fixed-point type and Powerbase will modify whatever you type in so
that it is displayed to the specified number of decimal places. For
'Numeric' fields only, you may also specify an upper and lower limit for
numbers which may be entered in these fields.
A 'Date' field should be either 8 or 10 characters long in order to hold the
date in one of the two formats specified above. The separator in these dates
need not be a hyphen. Look in the Powerbase directory for a subdirectory
called 'Resources'. Inside it is a file called 'Config'. Load this into
Edit. There is a line specifying the character to be used as a date
separator. If you change this make sure it is the first character on the
line. Note that the actual TYPING IN of dates allows far more flexibility.
You may type ANY non-numeric character as a separator and Powerbase will
make sense of entries such as 4/5/87, duly converting it to 04-05-87 when
you press RETURN.
A 'Calculated' field is used when you want the record to automatically
display the result of a calculation based on other fields. Similarly, a
'Composite' field might be used to display a person's name in the form
FORENAME SURNAME when the data actually typed in uses separate fields for
SURNAME and FORENAME. You don't specify at this stage how the field value is
derived; that's done when the database is actually working.
A 'Time' field (like a date) is checked for validity and (again like a date)
you may be fairly flexible in how you actually type the values in. If you
enter 3.45;9 it will be reformatted as 03:45:09. The colon separator may be
changed by editing the 'Config' file. Arithmetic may be performed on times
held in this type of field (see 'Calculate').
Other field categories
----------------------
Only the 'Data' category of field has been discussed so far. The other three
will now be dealt with.
External fields
---------------
External fields allow you to link a Powerbase record to pieces of data of a
size and type which make them unsuitable for inclusion in a 'Data' field.
Such items are sometimes called "BLOBs" (Binary Large Objects) in the PC
world. The field types in this category and the types of data they "hold"
are as follows:-
(a) Text Plain text files, such as Edit creates.
(b) Sprite Sprite files, such as Paint creates.
(c) Draw Drawings such as Draw creates.
(d) Text block Plain text files, as for (a).
(e) Picture Sprite files, as for (b).
When you create a field of type 'Text', 'Sprite' or 'Draw' it appears on the
record window as a button bearing a small version of the icon for Edit,
Paint or Draw respectively. Files of the appropriate type may be dropped on
these buttons, whereupon the file is copied into a special system of
subdirectories within the database application. Unlike fields of the 'Data'
category the data doesn't become part of the 'Database' file within the
application; the text, sprite or drawfile retains its identity and may be
exported for editing in the appropriate application. Clicking on the button
in the record window will display the file if the filer knows the
whereabouts of the relevant editor (Edit, Paint or Draw).
'Text block' and 'Picture' fields take this a step further by actually
displaying a text or sprite file on the record window. The bounding box of
the icon needs to be of suitable size to hold the text or picture. In the
case of a 'Text block' too small a box will cause the text to appear
truncated. None is actually lost; it just can't all be displayed. Too small
a box for a 'Picture' field will cause the sprite to spread beyond its
boundaries. (N.B. To display the same sprite on each record, e.g. a company
logo, define the field as of type 'Logo', not 'Picture'. The inclusion of
logos is described in the file 'Calculate' whcih may seem an odd place for
it but there is a reason!)
Check-box fields
----------------
These are fields whose status alternates between two values when clicked
over with SELECT. Three types are defined:-
(a) Cross/tick Displays a cross by default. A click changes it to a
tick. A second click changes it back to a cross.
(b) Null/tick Similar to (a), but first state is an empty box.
(c) Null/star Similar to (b), but second state is a star.
Check-boxes provide the fastest way of entering true/false or yes/no type
data. If you examine the 'ValStrings' file inside the Powerbase directory
you will find strings associated with each of these three types the latter
parts of which read, respectively:-
QNo,Yes
Q ,Yes
Q ,*
These specify what will actually appear in a print-out when a check-box
field is included in a query. You may change them if you wish, but don't
omit the initial Q and take care not to alter the remaider of the string.
Stamp fields
------------
These are of the following types:
(a) Record number Database record number.
(b) Sequence number A unique value which is numbered upwards
from a base value set by the user.
(c) Time Time at which record was created.
(d) Date Date on which record was created.
(e) Date and time Date and time of record creation.
(f) Day Day on which record was created (in the form
Mon,Tue etc or day of month as 10,24 etc).
(g) Month Month in which record was created (as either
a string; Jan,Feb etc or a number; 1,2 etc).
(h) Year Year in which record was created (as a
four-digit number, e.g. 1993).
Like 'Calculated' and 'Composite' fields none of the above is editable by
the user; all are automatically "stamped" by Powerbase at the time a record
is first entered. When using (a) or (b) make sure the 'Data length' fill-in
box contains a large enough value to accommodate the longest number which
will be encountered. In the case of (b) the base value from which the
sequence numbers begin is entered in the 'Numeric min' box. For the other
types the required field length is already known by Powerbase and the
'Data length' box is therefore shaded.
Type (d) fields may display the date in any of three formats:
(i) Sun,01 Aug 1993 (called "Date stamp")
(ii) 01-08-93 (called "Date stamp8")
(iii) 01-08-1993 (called "Date stamp10")
(ii) and (iii) are identical to the formats in which Powerbase displays
dates of the ordinary editable-data type (see "Other types of data field",
above). The numbers refer to the field length occupied by the date stamp.
Button fields
-------------
Any or all of the control buttons on the Powerbase keypad may be made to
appear on the record window itself. They have exactly the same functions as
their keypad equivalents. There are also a few extras (Print, Exit, Quit and
Directory) which have no keypad equivalent. The first three duplicate the
actions of 'Print' on the main menu and 'Close database' and 'Quit' on the
icon bar menu. 'Directory' enables you to open a filer window by
clicking on the button. The descriptor may be used to give the name of
the associated directory and the link is established by dropping the
directory onto the button in the same way that files are linked to
fields of 'External' type. These button fields allow you to build a
customised database which lets the user use only the features you want
him/her to have access to, since the keypad and menus can then be
suppressed.
Specifying the database size
============================
Immediately beneath the 'Data field' entry on the menu is one called
'Default database'. Choosing this is by far the fastest way of getting a
database up and running. Its action is to create three files inside the
application directory. These are called 'Form' (which holds the record
design), 'PrimaryKey' and 'Database' (which will ultimately contain the
entered records). The number of records in the database is set to 100, with
25 as the amount by which this should increase when the database becomes
full. The primary key is defined as the first four characters of the first
writable field. The database is opened and a blank record displayed ready
for data entry.
Since you can always alter such things as the database size and primary key
structure later, you might wish to use these defaults while you experiment
with the database. If, however, you want to set the database size yourself
at this stage proceed as follows:-
(1) Save the 'Form' file by following the menu option and clicking on 'OK'
or typing RETURN when the save box appears. The pathname is correctly set
for saving the file inside your database application.
(2) You will now see that the 'Database size' choice is no longer shaded and
may be used to reach the dialogue box in which you specify the number of
records in the database and the increment for expanding the database when it
becomes full.
Specifying the primary key
==========================
The primary key (or any other key) is derived from a record field called a
key field. The key field is selected by either clicking on the "bump" icons
which allow you to cycle through the field tags, or by choosing from a menu.
Key fields need to be chosen with care. An ideal key field is one whose
contents would never be repeated in another record. Powerbase allows you to
enforce this condition if you wish (see "Passwords"). Occasional repetitions
need not be serious, but a field which can have only a few "values" is
usually a poor choice. A customer number or membership number is the sort of
thing we are looking for, but your database may not contain anything like
that. In a database of school pupils the pupil's name would be a good
choice of key, but the form teacher's name would not, since only a small
number of names would be involved, each appearing on the record of many
pupils.
Suppose we decide to use a person's name, stored surname first, as a key. We
can hardly use the whole name; it would be far too long. The first four
letters would be more appropriate but, since this is the start of the
surname, we might have a lot of Smiths or, in Wales, a VERY large number of
repetitions of Jones or Evans! To get round this problem, Powerbase allows
you to construct an alphanumeric key from characters taken from up to four
successive words. You will seldom need to go as far as this. In the above
example, a five-letter key made up from the first four letters of the
surname and one letter of the forename would be good enough for most
purposes. Smith Peter and Smith Janet would have the keys SMITP and SMITJ.
Duplication can still occur, but not often enough to be a serious problem.
It isn't normally sensible to build a numeric key from several bits in this
way and Powerbase won't let you do so. Such a key consists of the numeric
value of the chosen key field.
There are databases where no field seems suitable as a key field. Consider
a database of classical music. There would be a field for the composer's
name and one for the name of the work. Neither is much use on its own: the
former would contain possibly hundreds of occurrences of Mozart and
Beethoven and the latter would have numerous repetitions of Symphony No.5
or String Quartet in D minor.
To deal with such situations Powerbase allows you to use a composite
alphanumeric key, based on two fields in combination. A second group of
icons allows you to cycle through the tags for the second field, or choose
it from a menu.
Imagine the two fields placed end to end, with a single space between them.
The key may then be based on the first four words of the composite field. We
might, for the music database, use all four words and take 4,3,3,2
characters respectively from them. The following two works then give the
keys shown:
BEETHOVEN Symphony No 5: BEETSYMNO5
MOZART Piano concerto 23: MOZAPIACON23
Note the following points in these examples:
(a) If a word is shorter than the number of letters assigned to it
("No" in the first example) then the whole word is used but no
padding is inserted.
(b) It may be necessary to leave out an insignificant word ("No" in
the second example, so that a significant one ("23") comes in the
first four words of the composite field.
Once you have decided on the structure of your primary key, go to the
dialogue box from the 'Primary key' menu entry. Click on the first icon
until the tag of the required field is shown. Do the same with the second if
specifying a composite key. Enter the numbers of letters assigned to each
word.
Another choice to be decided is if the indexing is to pay any attention to
whether letters are upper or lower case. By default indexing is NOT
case-sensitive, all keys being forced to upper case before insertion in the
index and search strings being similarly forced to upper case. Thus if a
record has the word "Horse" as the contents of a key field and the first
four letters are used as the key then the entry in the index will be "HORS"
and you may search for it by entering "HORS", "hors", "Hors", "hOrS" etc.
This might not be what you want. If you require indexing to be case-
sensitive then select the switch labelled 'Case sensitive'. The forcing to
upper case described above does not then take place - keys are inserted and
strings are searched for "as is". The field containing "Horse" will be
indexed as "Hors" and only that precise combination of upper and lower case
letters will successfully find it. Alphabetic keys will be ordered according
to the ASCII values of the letters. Since lower-case letters come later in
the ASCII table than upper-case ones a record containing "dog" would appear
AFTER one containing "Horse", whereas one containing "Dog" would come before
"Horse".
Once you are satisfied click OK and your database will be created. The
record window is redrawn and you may start entering data at once.
00000000 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
00000010 20 20 20 20 20 20 20 20 43 72 65 61 74 69 6e 67 | Creating|
00000020 20 61 20 4e 65 77 20 44 61 74 61 62 61 73 65 0a | a New Database.|
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 3d 3d 3d 3d 3d 3d 3d 3d | ========|
00000050 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a |===============.|
00000060 0a 54 6f 20 63 72 65 61 74 65 20 61 20 6e 65 77 |.To create a new|
00000070 20 64 61 74 61 62 61 73 65 20 79 6f 75 20 6e 65 | database you ne|
00000080 65 64 20 74 6f 20 67 6f 20 74 68 72 6f 75 67 68 |ed to go through|
00000090 20 66 69 76 65 20 73 74 65 70 73 3a 2d 0a 0a 20 | five steps:-.. |
000000a0 20 20 20 20 20 20 20 28 69 29 20 20 20 20 20 43 | (i) C|
000000b0 72 65 61 74 65 20 74 68 65 20 64 61 74 61 62 61 |reate the databa|
000000c0 73 65 20 61 70 70 6c 69 63 61 74 69 6f 6e 20 73 |se application s|
000000d0 68 65 6c 6c 2e 0a 20 20 20 20 20 20 20 20 28 69 |hell.. (i|
000000e0 69 29 20 20 20 20 44 65 73 69 67 6e 20 74 68 65 |i) Design the|
000000f0 20 72 65 63 6f 72 64 20 73 63 72 65 65 6e 2e 0a | record screen..|
00000100 20 20 20 20 20 20 20 20 28 69 69 69 29 20 20 20 | (iii) |
00000110 53 70 65 63 69 66 79 20 74 68 65 20 6e 75 6d 62 |Specify the numb|
00000120 65 72 20 6f 66 20 72 65 63 6f 72 64 73 20 74 68 |er of records th|
00000130 65 20 64 61 74 61 62 61 73 65 20 69 73 20 74 6f |e database is to|
00000140 20 63 6f 6e 74 61 69 6e 2e 0a 20 20 20 20 20 20 | contain.. |
00000150 20 20 28 69 76 29 20 20 20 20 53 70 65 63 69 66 | (iv) Specif|
00000160 79 20 74 68 65 20 70 72 69 6d 61 72 79 20 6b 65 |y the primary ke|
00000170 79 2e 0a 20 20 20 20 20 20 20 20 28 76 29 20 20 |y.. (v) |
00000180 20 20 20 42 75 69 6c 64 20 74 68 65 20 65 6d 70 | Build the emp|
00000190 74 79 20 64 61 74 61 62 61 73 65 2e 0a 0a 45 61 |ty database...Ea|
000001a0 63 68 20 6f 66 20 74 68 65 73 65 20 77 69 6c 6c |ch of these will|
000001b0 20 62 65 20 64 65 73 63 72 69 62 65 64 20 69 6e | be described in|
000001c0 20 74 68 65 20 6f 72 64 65 72 20 6a 75 73 74 20 | the order just |
000001d0 67 69 76 65 6e 2e 0a 0a 43 72 65 61 74 69 6e 67 |given...Creating|
000001e0 20 74 68 65 20 64 61 74 61 62 61 73 65 20 61 70 | the database ap|
000001f0 70 6c 69 63 61 74 69 6f 6e 20 73 68 65 6c 6c 0a |plication shell.|
00000200 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |================|
*
00000220 3d 3d 3d 3d 3d 3d 3d 0a 59 6f 75 20 6e 65 65 64 |=======.You need|
00000230 20 74 6f 20 68 61 76 65 20 50 6f 77 65 72 62 61 | to have Powerba|
00000240 73 65 20 69 6e 73 74 61 6c 6c 65 64 20 6f 6e 20 |se installed on |
00000250 74 68 65 20 69 63 6f 6e 20 62 61 72 20 62 75 74 |the icon bar but|
00000260 20 77 69 74 68 20 6e 6f 20 64 61 74 61 62 61 73 | with no databas|
00000270 65 0a 6f 70 65 6e 2c 20 69 2e 65 2e 20 27 4e 6f |e.open, i.e. 'No|
00000280 20 64 61 74 61 27 20 73 68 6f 75 6c 64 20 61 70 | data' should ap|
00000290 70 65 61 72 20 75 6e 64 65 72 20 74 68 65 20 69 |pear under the i|
000002a0 63 6f 6e 2e 20 43 6c 69 63 6b 20 53 45 4c 45 43 |con. Click SELEC|
000002b0 54 20 6f 76 65 72 20 74 68 65 0a 69 63 6f 6e 20 |T over the.icon |
000002c0 61 6e 64 20 61 20 73 61 76 65 20 62 6f 78 20 77 |and a save box w|
000002d0 69 6c 6c 20 61 70 70 65 61 72 2e 20 54 79 70 65 |ill appear. Type|
000002e0 20 69 6e 20 74 68 65 20 6e 61 6d 65 20 6f 66 20 | in the name of |
000002f0 79 6f 75 72 20 64 61 74 61 62 61 73 65 20 61 6e |your database an|
00000300 64 20 64 72 61 67 0a 74 68 65 20 64 61 74 61 62 |d drag.the datab|
00000310 61 73 65 20 69 63 6f 6e 20 74 6f 20 61 20 64 69 |ase icon to a di|
00000320 72 65 63 74 6f 72 79 20 76 69 65 77 65 72 2e 20 |rectory viewer. |
00000330 52 65 6d 65 6d 62 65 72 20 74 68 61 74 20 69 74 |Remember that it|
00000340 20 63 61 6e 6e 6f 74 20 65 78 63 65 65 64 20 31 | cannot exceed 1|
00000350 30 0a 63 68 61 72 61 63 74 65 72 73 2c 20 69 6e |0.characters, in|
00000360 63 6c 75 64 69 6e 67 20 74 68 65 20 69 6e 69 74 |cluding the init|
00000370 69 61 6c 20 22 21 22 2e 20 49 66 20 79 6f 75 20 |ial "!". If you |
00000380 65 6e 74 65 72 20 6d 6f 72 65 20 74 68 65 20 6e |enter more the n|
00000390 61 6d 65 20 77 69 6c 6c 20 62 65 0a 74 72 75 6e |ame will be.trun|
000003a0 63 61 74 65 64 20 61 6e 64 20 79 6f 75 20 63 6f |cated and you co|
000003b0 75 6c 64 20 65 6e 64 20 75 70 20 6f 76 65 72 77 |uld end up overw|
000003c0 72 69 74 69 6e 67 20 61 6e 20 65 78 69 73 74 69 |riting an existi|
000003d0 6e 67 20 64 61 74 61 62 61 73 65 20 77 69 74 68 |ng database with|
000003e0 20 61 0a 73 69 6d 69 6c 61 72 20 6e 61 6d 65 2e | a.similar name.|
000003f0 20 59 6f 75 20 64 6f 6e 27 74 20 61 63 74 75 61 | You don't actua|
00000400 6c 6c 79 20 6e 65 65 64 20 74 6f 20 65 6e 74 65 |lly need to ente|
00000410 72 20 74 68 65 20 22 21 22 3b 20 50 6f 77 65 72 |r the "!"; Power|
00000420 62 61 73 65 20 77 69 6c 6c 0a 69 6e 73 65 72 74 |base will.insert|
00000430 20 69 74 20 61 75 74 6f 6d 61 74 69 63 61 6c 6c | it automaticall|
00000440 79 2e 0a 0a 49 66 20 79 6f 75 20 6f 70 65 6e 20 |y...If you open |
00000450 74 68 65 20 6e 65 77 6c 79 2d 63 72 65 61 74 65 |the newly-create|
00000460 64 20 61 70 70 6c 69 63 61 74 69 6f 6e 20 64 69 |d application di|
00000470 72 65 63 74 6f 72 79 20 28 53 48 49 46 54 2f 64 |rectory (SHIFT/d|
00000480 6f 75 62 6c 65 20 63 6c 69 63 6b 29 20 79 6f 75 |ouble click) you|
00000490 0a 77 69 6c 6c 20 66 69 6e 64 20 74 68 61 74 20 |.will find that |
000004a0 69 74 20 63 6f 6e 74 61 69 6e 73 20 66 69 6c 65 |it contains file|
000004b0 73 20 63 61 6c 6c 65 64 20 21 42 6f 6f 74 2c 20 |s called !Boot, |
000004c0 21 52 75 6e 2c 20 21 53 70 72 69 74 65 73 2c 20 |!Run, !Sprites, |
000004d0 63 68 6b 73 70 72 20 61 6e 64 0a 43 6f 6c 6f 75 |chkspr and.Colou|
000004e0 72 73 20 61 6e 64 20 66 6f 75 72 20 73 75 62 64 |rs and four subd|
000004f0 69 72 65 63 74 6f 72 69 65 73 20 63 61 6c 6c 65 |irectories calle|
00000500 64 20 49 6e 64 69 63 65 73 2c 20 50 72 69 6e 74 |d Indices, Print|
00000510 4a 6f 62 73 2c 20 50 72 69 6e 74 52 65 73 20 61 |Jobs, PrintRes a|
00000520 6e 64 0a 56 61 6c 54 61 62 6c 65 73 2e 20 41 6c |nd.ValTables. Al|
00000530 6c 20 50 6f 77 65 72 62 61 73 65 20 61 70 70 6c |l Powerbase appl|
00000540 69 63 61 74 69 6f 6e 73 20 72 65 71 75 69 72 65 |ications require|
00000550 20 74 68 65 73 65 20 6f 62 6a 65 63 74 73 20 74 | these objects t|
00000560 6f 20 62 65 20 70 72 65 73 65 6e 74 20 73 6f 0a |o be present so.|
00000570 64 6f 6e 27 74 20 64 65 6c 65 74 65 20 61 6e 79 |don't delete any|
00000580 20 6f 66 20 74 68 65 6d 2e 20 0a 0a 44 65 73 69 | of them. ..Desi|
00000590 67 6e 69 6e 67 20 74 68 65 20 72 65 63 6f 72 64 |gning the record|
000005a0 20 73 63 72 65 65 6e 0a 3d 3d 3d 3d 3d 3d 3d 3d | screen.========|
000005b0 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |================|
000005c0 3d 3d 3d 0a 57 68 65 6e 20 79 6f 75 20 63 72 65 |===.When you cre|
000005d0 61 74 65 64 20 74 68 65 20 61 70 70 6c 69 63 61 |ated the applica|
000005e0 74 69 6f 6e 20 73 68 65 6c 6c 20 79 6f 75 20 77 |tion shell you w|
000005f0 65 72 65 20 6c 65 66 74 20 77 69 74 68 20 61 20 |ere left with a |
00000600 62 6c 61 6e 6b 20 77 69 6e 64 6f 77 20 6f 6e 0a |blank window on.|
00000610 73 63 72 65 65 6e 20 61 6e 64 20 69 74 20 69 73 |screen and it is|
00000620 20 6f 6e 20 74 68 69 73 20 77 69 6e 64 6f 77 20 | on this window |
00000630 74 68 61 74 20 79 6f 75 20 6d 75 73 74 20 64 65 |that you must de|
00000640 73 69 67 6e 20 79 6f 75 72 20 64 61 74 61 62 61 |sign your databa|
00000650 73 65 20 72 65 63 6f 72 64 2e 20 0a 54 68 69 73 |se record. .This|
00000660 20 69 73 20 74 68 65 20 6c 65 6e 67 74 68 69 65 | is the lengthie|
00000670 73 74 20 61 6e 64 20 74 72 69 63 6b 69 65 73 74 |st and trickiest|
00000680 20 70 61 72 74 20 6f 66 20 73 65 74 74 69 6e 67 | part of setting|
00000690 20 75 70 20 61 6e 79 20 64 61 74 61 62 61 73 65 | up any database|
000006a0 2c 0a 61 6c 74 68 6f 75 67 68 20 65 66 66 6f 72 |,.although effor|
000006b0 74 73 20 68 61 76 65 20 62 65 65 6e 20 6d 61 64 |ts have been mad|
000006c0 65 20 74 6f 20 72 65 6e 64 65 72 20 69 74 20 61 |e to render it a|
000006d0 73 20 70 61 69 6e 6c 65 73 73 20 61 73 20 70 6f |s painless as po|
000006e0 73 73 69 62 6c 65 2e 20 49 66 20 79 6f 75 0a 68 |ssible. If you.h|
000006f0 61 76 65 20 63 6c 6f 73 65 64 20 74 68 65 20 77 |ave closed the w|
00000700 69 6e 64 6f 77 20 6a 75 73 74 20 63 6c 69 63 6b |indow just click|
00000710 20 6f 6e 20 74 68 65 20 50 6f 77 65 72 62 61 73 | on the Powerbas|
00000720 65 20 69 63 6f 6e 20 6f 6e 20 74 68 65 20 69 63 |e icon on the ic|
00000730 6f 6e 20 62 61 72 20 74 6f 0a 72 65 2d 64 69 73 |on bar to.re-dis|
00000740 70 6c 61 79 20 69 74 2e 20 0a 0a 43 6c 69 63 6b |play it. ..Click|
00000750 69 6e 67 20 4d 45 4e 55 20 6f 76 65 72 20 74 68 |ing MENU over th|
00000760 65 20 77 69 6e 64 6f 77 20 62 72 69 6e 67 73 20 |e window brings |
00000770 75 70 20 74 68 65 20 27 4e 65 77 20 64 61 74 61 |up the 'New data|
00000780 62 61 73 65 27 20 6d 65 6e 75 20 6f 6e 20 77 68 |base' menu on wh|
00000790 69 63 68 0a 65 76 65 72 79 20 69 74 65 6d 20 65 |ich.every item e|
000007a0 78 63 65 70 74 20 27 44 65 73 69 67 6e 20 66 69 |xcept 'Design fi|
000007b0 65 6c 64 27 20 61 6e 64 20 27 48 65 6c 70 27 20 |eld' and 'Help' |
000007c0 69 73 20 73 68 61 64 65 64 20 61 74 20 74 68 69 |is shaded at thi|
000007d0 73 20 73 74 61 67 65 2e 20 54 68 65 20 0a 27 44 |s stage. The .'D|
000007e0 65 73 69 67 6e 20 66 69 65 6c 64 27 20 63 68 6f |esign field' cho|
000007f0 69 63 65 20 6c 65 61 64 73 20 74 6f 20 61 20 64 |ice leads to a d|
00000800 69 61 6c 6f 67 75 65 20 62 6f 78 20 77 68 69 63 |ialogue box whic|
00000810 68 20 61 6c 6c 6f 77 73 20 79 6f 75 20 74 6f 20 |h allows you to |
00000820 73 70 65 63 69 66 79 20 74 68 65 0a 63 68 61 72 |specify the.char|
00000830 61 63 74 65 72 69 73 74 69 63 73 20 6f 66 20 61 |acteristics of a|
00000840 20 66 69 65 6c 64 2e 20 46 69 72 73 74 20 79 6f | field. First yo|
00000850 75 20 6d 75 73 74 20 64 65 63 69 64 65 20 77 68 |u must decide wh|
00000860 61 74 20 63 61 74 65 67 6f 72 79 20 6f 66 20 66 |at category of f|
00000870 69 65 6c 64 20 79 6f 75 0a 77 61 6e 74 20 74 6f |ield you.want to|
00000880 20 63 72 65 61 74 65 2e 20 54 68 65 72 65 20 61 | create. There a|
00000890 72 65 20 66 6f 75 72 20 73 75 63 68 20 63 61 74 |re four such cat|
000008a0 65 67 6f 72 69 65 73 2c 20 73 65 6c 65 63 74 65 |egories, selecte|
000008b0 64 20 76 69 61 20 72 61 64 69 6f 20 62 75 74 74 |d via radio butt|
000008c0 6f 6e 73 3a 2d 0a 0a 20 20 20 20 20 20 28 69 29 |ons:-.. (i)|
000008d0 20 44 61 74 61 20 20 28 69 69 29 20 45 78 74 65 | Data (ii) Exte|
000008e0 72 6e 61 6c 20 20 28 69 69 69 29 20 42 75 74 74 |rnal (iii) Butt|
000008f0 6f 6e 20 20 28 69 76 29 20 43 68 65 63 6b 2d 62 |on (iv) Check-b|
00000900 6f 78 20 0a 0a 46 6f 72 20 74 68 65 20 70 72 65 |ox ..For the pre|
00000910 73 65 6e 74 20 77 65 20 77 69 6c 6c 20 63 6f 6e |sent we will con|
00000920 66 69 6e 65 20 6f 75 72 73 65 6c 76 65 73 20 74 |fine ourselves t|
00000930 6f 20 74 68 65 20 66 69 72 73 74 2c 20 77 68 69 |o the first, whi|
00000940 63 68 20 69 73 20 74 68 65 20 64 65 66 61 75 6c |ch is the defaul|
00000950 74 0a 73 65 6c 65 63 74 69 6f 6e 2e 20 41 73 20 |t.selection. As |
00000960 77 65 6c 6c 20 61 73 20 74 68 65 20 66 69 65 6c |well as the fiel|
00000970 64 20 63 61 74 65 67 6f 72 79 20 79 6f 75 20 6d |d category you m|
00000980 75 73 74 20 64 65 63 69 64 65 20 6f 6e 20 74 68 |ust decide on th|
00000990 65 20 74 79 70 65 20 6f 66 0a 66 69 65 6c 64 20 |e type of.field |
000009a0 77 69 74 68 69 6e 20 74 68 65 20 63 61 74 65 67 |within the categ|
000009b0 6f 72 79 2e 20 4d 6f 73 74 20 66 69 65 6c 64 73 |ory. Most fields|
000009c0 20 61 72 65 20 6f 66 20 27 41 6c 70 68 61 6e 75 | are of 'Alphanu|
000009d0 6d 65 72 69 63 27 20 74 79 70 65 20 61 6e 64 20 |meric' type and |
000009e0 74 68 61 74 0a 69 73 20 6f 66 66 65 72 65 64 20 |that.is offered |
000009f0 61 73 20 74 68 65 20 64 65 66 61 75 6c 74 2e 20 |as the default. |
00000a00 57 65 27 6c 6c 20 73 65 65 20 61 62 6f 75 74 20 |We'll see about |
00000a10 6f 74 68 65 72 20 74 79 70 65 73 20 6c 61 74 65 |other types late|
00000a20 72 2e 0a 0a 44 65 63 69 64 65 20 6f 6e 20 61 20 |r...Decide on a |
00000a30 6e 61 6d 65 20 66 6f 72 20 74 68 65 20 66 69 65 |name for the fie|
00000a40 6c 64 20 61 6e 64 20 65 6e 74 65 72 20 69 74 20 |ld and enter it |
00000a50 69 6e 20 74 68 65 20 27 44 65 73 63 72 69 70 74 |in the 'Descript|
00000a60 6f 72 27 20 69 63 6f 6e 2e 20 54 68 69 73 0a 69 |or' icon. This.i|
00000a70 73 20 74 68 65 20 6e 61 6d 65 20 77 68 69 63 68 |s the name which|
00000a80 20 77 69 6c 6c 20 61 70 70 65 61 72 20 6f 6e 20 | will appear on |
00000a90 74 68 65 20 72 65 63 6f 72 64 20 77 69 6e 64 6f |the record windo|
00000aa0 77 20 61 6e 64 20 6d 61 79 20 62 65 20 75 70 20 |w and may be up |
00000ab0 74 6f 20 34 30 0a 63 68 61 72 61 63 74 65 72 73 |to 40.characters|
00000ac0 20 6c 6f 6e 67 2e 20 59 6f 75 20 73 68 6f 75 6c | long. You shoul|
00000ad0 64 20 61 6c 73 6f 20 65 6e 74 65 72 20 61 20 27 |d also enter a '|
00000ae0 54 61 67 27 2c 20 77 68 69 63 68 20 69 73 20 6c |Tag', which is l|
00000af0 69 6d 69 74 65 64 20 74 6f 20 34 0a 63 68 61 72 |imited to 4.char|
00000b00 61 63 74 65 72 73 2e 20 4e 65 78 74 20 65 6e 74 |acters. Next ent|
00000b10 65 72 20 74 68 65 20 27 44 61 74 61 20 6c 65 6e |er the 'Data len|
00000b20 67 74 68 27 3b 20 74 68 65 20 6d 61 78 69 6d 75 |gth'; the maximu|
00000b30 6d 20 6e 75 6d 62 65 72 20 6f 66 20 63 68 61 72 |m number of char|
00000b40 61 63 74 65 72 73 0a 74 68 65 20 66 69 65 6c 64 |acters.the field|
00000b50 20 69 73 20 74 6f 20 68 6f 6c 64 2e 20 56 61 6c | is to hold. Val|
00000b60 75 65 73 20 75 70 20 74 6f 20 32 34 36 20 61 72 |ues up to 246 ar|
00000b70 65 20 61 6c 6c 6f 77 65 64 2e 20 4e 6f 77 20 63 |e allowed. Now c|
00000b80 6c 69 63 6b 20 6f 6e 20 27 43 72 65 61 74 65 27 |lick on 'Create'|
00000b90 0a 61 6e 64 20 74 68 65 20 66 69 65 6c 64 20 77 |.and the field w|
00000ba0 69 6c 6c 20 61 70 70 65 61 72 20 6f 6e 20 74 68 |ill appear on th|
00000bb0 65 20 72 65 63 6f 72 64 20 77 69 6e 64 6f 77 2e |e record window.|
00000bc0 20 49 74 27 73 20 70 72 6f 62 61 62 6c 79 20 6e | It's probably n|
00000bd0 6f 74 20 77 68 65 72 65 20 79 6f 75 0a 77 61 6e |ot where you.wan|
00000be0 74 20 69 74 20 73 6f 20 75 73 65 20 53 45 4c 45 |t it so use SELE|
00000bf0 43 54 20 74 6f 20 64 72 61 67 20 74 68 65 20 77 |CT to drag the w|
00000c00 68 69 74 65 20 72 65 63 74 61 6e 67 6c 65 20 74 |hite rectangle t|
00000c10 6f 20 74 68 65 20 70 6f 73 69 74 69 6f 6e 20 72 |o the position r|
00000c20 65 71 75 69 72 65 64 2e 0a 57 68 65 6e 20 79 6f |equired..When yo|
00000c30 75 20 64 72 6f 70 20 74 68 65 20 66 69 65 6c 64 |u drop the field|
00000c40 20 69 6e 20 69 74 73 20 6e 65 77 20 70 6f 73 69 | in its new posi|
00000c50 74 69 6f 6e 20 79 6f 75 27 6c 6c 20 73 65 65 20 |tion you'll see |
00000c60 74 68 61 74 20 74 68 65 20 64 65 73 63 72 69 70 |that the descrip|
00000c70 74 6f 72 0a 66 61 6c 6c 73 20 69 6e 74 6f 20 70 |tor.falls into p|
00000c80 6c 61 63 65 20 74 6f 6f 2e 20 49 66 20 79 6f 75 |lace too. If you|
00000c90 20 77 61 6e 74 20 74 68 65 20 64 65 73 63 72 69 | want the descri|
00000ca0 70 74 6f 72 20 73 6f 6d 65 77 68 65 72 65 20 6f |ptor somewhere o|
00000cb0 74 68 65 72 20 74 68 61 6e 20 74 6f 20 74 68 65 |ther than to the|
00000cc0 0a 6c 65 66 74 20 6f 66 20 74 68 65 20 64 61 74 |.left of the dat|
00000cd0 61 20 69 63 6f 6e 20 28 61 62 6f 76 65 20 69 74 |a icon (above it|
00000ce0 2c 20 66 6f 72 20 65 78 61 6d 70 6c 65 29 20 74 |, for example) t|
00000cf0 68 65 6e 20 79 6f 75 20 63 61 6e 20 6d 6f 76 65 |hen you can move|
00000d00 20 74 68 65 0a 64 65 73 63 72 69 70 74 6f 72 20 | the.descriptor |
00000d10 62 79 20 69 74 73 65 6c 66 20 77 69 74 68 6f 75 |by itself withou|
00000d20 74 20 74 68 65 20 64 61 74 61 20 69 63 6f 6e 20 |t the data icon |
00000d30 6d 6f 76 69 6e 67 2e 0a 0a 42 61 73 69 63 61 6c |moving...Basical|
00000d40 6c 79 20 74 68 61 74 27 73 20 61 6c 6c 20 79 6f |ly that's all yo|
00000d50 75 20 61 63 74 75 61 6c 6c 79 20 6e 65 65 64 20 |u actually need |
00000d60 74 6f 20 64 6f 20 69 6e 20 6f 72 64 65 72 20 74 |to do in order t|
00000d70 6f 20 63 72 65 61 74 65 20 66 69 65 6c 64 73 2e |o create fields.|
00000d80 0a 4d 69 73 74 61 6b 65 73 20 6d 61 79 20 62 65 |.Mistakes may be|
00000d90 20 63 6f 72 72 65 63 74 65 64 20 62 79 20 63 6c | corrected by cl|
00000da0 69 63 6b 69 6e 67 20 4d 45 4e 55 20 6f 76 65 72 |icking MENU over|
00000db0 20 74 68 65 20 66 69 65 6c 64 20 74 6f 20 62 65 | the field to be|
00000dc0 20 61 6c 74 65 72 65 64 20 61 6e 64 0a 6d 61 6b | altered and.mak|
00000dd0 69 6e 67 20 74 68 65 20 72 65 71 75 69 72 65 64 |ing the required|
00000de0 20 63 68 61 6e 67 65 73 2e 20 59 6f 75 20 74 68 | changes. You th|
00000df0 65 6e 20 63 6c 69 63 6b 20 6f 6e 20 27 55 70 64 |en click on 'Upd|
00000e00 61 74 65 27 20 72 61 74 68 65 72 20 74 68 61 6e |ate' rather than|
00000e10 20 27 43 72 65 61 74 65 27 0a 28 27 43 72 65 61 | 'Create'.('Crea|
00000e20 74 65 27 20 69 73 20 73 68 61 64 65 64 2c 20 69 |te' is shaded, i|
00000e30 6e 20 66 61 63 74 29 2e 20 41 20 66 69 65 6c 64 |n fact). A field|
00000e40 20 6d 61 79 20 62 65 20 64 65 6c 65 74 65 64 20 | may be deleted |
00000e50 62 79 20 63 6c 69 63 6b 69 6e 67 20 4d 45 4e 55 |by clicking MENU|
00000e60 20 6f 76 65 72 0a 69 74 20 74 68 65 6e 20 63 6c | over.it then cl|
00000e70 69 63 6b 69 6e 67 20 6f 6e 20 27 52 65 6d 6f 76 |icking on 'Remov|
00000e80 65 27 2e 20 54 6f 20 69 6e 73 65 72 74 20 61 20 |e'. To insert a |
00000e90 66 69 65 6c 64 20 69 6e 74 6f 20 74 68 65 20 6d |field into the m|
00000ea0 69 64 64 6c 65 20 6f 66 20 61 20 72 65 63 6f 72 |iddle of a recor|
00000eb0 64 0a 79 6f 75 20 6d 75 73 74 20 65 6e 74 65 72 |d.you must enter|
00000ec0 20 74 68 65 20 6e 75 6d 62 65 72 20 6f 66 20 74 | the number of t|
00000ed0 68 65 20 66 69 65 6c 64 20 77 68 69 63 68 20 6d |he field which m|
00000ee0 75 73 74 20 66 6f 6c 6c 6f 77 20 74 68 65 20 6e |ust follow the n|
00000ef0 65 77 20 6f 6e 65 20 69 6e 20 74 68 65 0a 73 70 |ew one in the.sp|
00000f00 61 63 65 20 70 72 6f 76 69 64 65 64 2e 20 43 6c |ace provided. Cl|
00000f10 69 63 6b 69 6e 67 20 27 43 72 65 61 74 65 27 20 |icking 'Create' |
00000f20 77 69 6c 6c 20 74 68 65 6e 20 63 72 65 61 74 65 |will then create|
00000f30 20 74 68 65 20 66 69 65 6c 64 20 69 6e 20 74 68 | the field in th|
00000f40 65 0a 63 6f 72 72 65 63 74 20 70 6c 61 63 65 20 |e.correct place |
00000f50 69 6e 20 74 68 65 20 66 69 65 6c 64 20 73 65 71 |in the field seq|
00000f60 75 65 6e 63 65 2e 20 49 74 20 69 73 6e 27 74 20 |uence. It isn't |
00000f70 73 75 66 66 69 63 69 65 6e 74 20 74 6f 20 6a 75 |sufficient to ju|
00000f80 73 74 20 64 72 61 67 20 74 68 65 0a 66 69 65 6c |st drag the.fiel|
00000f90 64 73 20 61 72 6f 75 6e 64 20 2d 20 74 68 65 20 |ds around - the |
00000fa0 6f 72 64 65 72 20 69 6e 20 77 68 69 63 68 20 74 |order in which t|
00000fb0 68 65 79 20 61 72 65 20 61 63 63 65 73 73 65 64 |hey are accessed|
00000fc0 20 77 68 65 6e 20 74 68 65 20 64 61 74 61 62 61 | when the databa|
00000fd0 73 65 20 69 73 20 69 6e 0a 75 73 65 20 77 6f 6e |se is in.use won|
00000fe0 27 74 20 62 65 20 61 6c 74 65 72 65 64 20 62 79 |'t be altered by|
00000ff0 20 74 68 61 74 2e 0a 0a 59 6f 75 20 6d 69 67 68 | that...You migh|
00001000 74 20 77 61 6e 74 20 74 6f 20 63 68 61 6e 67 65 |t want to change|
00001010 20 74 68 65 20 73 65 71 75 65 6e 63 65 20 6f 66 | the sequence of|
00001020 20 66 69 65 6c 64 73 20 77 69 74 68 6f 75 74 20 | fields without |
00001030 72 65 63 6f 75 72 73 65 20 74 6f 20 74 68 65 0a |recourse to the.|
00001040 74 65 64 69 6f 75 73 20 6d 65 74 68 6f 64 20 6f |tedious method o|
00001050 66 20 64 65 6c 65 74 69 6e 67 20 61 20 66 69 65 |f deleting a fie|
00001060 6c 64 20 61 6e 64 20 74 68 65 6e 20 72 65 2d 63 |ld and then re-c|
00001070 72 65 61 74 69 6e 67 20 61 6e 64 20 69 6e 73 65 |reating and inse|
00001080 72 74 69 6e 67 20 69 74 2e 0a 54 68 65 72 20 61 |rting it..Ther a|
00001090 72 65 20 74 77 6f 20 77 61 79 73 20 6f 66 20 64 |re two ways of d|
000010a0 6f 69 6e 67 20 74 68 69 73 2e 20 43 6c 69 63 6b |oing this. Click|
000010b0 20 4d 45 4e 55 20 6f 76 65 72 20 61 6e 20 65 78 | MENU over an ex|
000010c0 69 73 69 74 6e 67 20 66 69 65 6c 64 20 74 6f 20 |isitng field to |
000010d0 62 72 69 6e 67 0a 75 70 20 74 68 65 20 64 69 61 |bring.up the dia|
000010e0 6c 6f 67 75 65 20 62 6f 78 2e 20 57 65 20 77 69 |logue box. We wi|
000010f0 6c 6c 20 63 61 6c 6c 20 74 68 69 73 20 74 68 65 |ll call this the|
00001100 20 22 63 75 72 72 65 6e 74 20 66 69 65 6c 64 22 | "current field"|
00001110 2e 20 45 6e 74 65 72 20 74 68 65 20 6e 75 6d 62 |. Enter the numb|
00001120 65 72 0a 6f 66 20 61 6e 6f 74 68 65 72 20 65 78 |er.of another ex|
00001130 69 73 74 69 6e 67 20 66 69 65 6c 64 20 69 6e 20 |isting field in |
00001140 74 68 65 20 73 61 6d 65 20 70 6c 61 63 65 20 61 |the same place a|
00001150 73 20 77 61 73 20 75 73 65 64 20 61 62 6f 76 65 |s was used above|
00001160 20 74 6f 20 73 70 65 63 69 66 79 20 74 68 65 0a | to specify the.|
00001170 69 6e 73 65 72 74 69 6f 6e 20 70 6f 73 69 74 69 |insertion positi|
00001180 6f 6e 20 6f 66 20 61 20 6e 65 77 20 66 69 65 6c |on of a new fiel|
00001190 64 2e 20 57 65 27 6c 6c 20 63 61 6c 6c 20 74 68 |d. We'll call th|
000011a0 69 73 20 74 68 65 20 22 65 6e 74 65 72 65 64 20 |is the "entered |
000011b0 66 69 65 6c 64 22 2e 20 54 68 65 0a 74 77 6f 20 |field". The.two |
000011c0 62 75 74 74 6f 6e 20 27 53 77 61 70 20 77 69 74 |button 'Swap wit|
000011d0 68 27 20 61 6e 64 20 27 52 65 6e 75 6d 62 65 72 |h' and 'Renumber|
000011e0 20 61 73 27 20 6d 61 79 20 74 68 65 6e 20 62 65 | as' may then be|
000011f0 20 75 73 65 64 2e 20 27 53 77 61 70 20 77 69 74 | used. 'Swap wit|
00001200 68 27 20 64 6f 65 73 0a 65 78 61 63 74 6c 79 20 |h' does.exactly |
00001210 77 68 61 74 20 79 6f 75 20 77 6f 75 6c 64 20 65 |what you would e|
00001220 78 70 65 63 74 3a 20 69 74 20 73 77 61 70 73 20 |xpect: it swaps |
00001230 74 68 65 20 70 6f 73 69 74 69 6f 6e 73 20 6f 66 |the positions of|
00001240 20 74 68 65 20 63 75 72 72 65 6e 74 20 66 69 65 | the current fie|
00001250 6c 64 0a 61 6e 64 20 74 68 65 20 65 6e 74 65 72 |ld.and the enter|
00001260 65 64 20 66 69 65 6c 64 20 69 6e 20 74 68 65 20 |ed field in the |
00001270 66 69 65 6c 64 20 73 65 71 75 65 6e 63 65 2e 0a |field sequence..|
00001280 0a 54 68 65 20 61 63 74 69 6f 6e 20 6f 66 20 27 |.The action of '|
00001290 52 65 6e 75 6d 62 65 72 20 61 73 27 20 69 73 20 |Renumber as' is |
000012a0 6d 6f 72 65 20 63 6f 6d 70 6c 65 78 2e 20 54 68 |more complex. Th|
000012b0 65 20 63 75 72 72 65 6e 74 20 66 69 65 6c 64 20 |e current field |
000012c0 61 63 71 75 69 72 65 73 20 74 68 65 0a 6e 75 6d |acquires the.num|
000012d0 62 65 72 20 6f 66 20 74 68 65 20 65 6e 74 65 72 |ber of the enter|
000012e0 65 64 20 66 69 65 6c 64 2e 20 49 66 20 74 68 69 |ed field. If thi|
000012f0 73 20 69 6e 76 6f 6c 76 65 73 20 67 69 76 69 6e |s involves givin|
00001300 67 20 74 68 65 20 63 75 72 72 65 6e 74 20 66 69 |g the current fi|
00001310 65 6c 64 20 61 0a 6c 6f 77 65 72 20 6e 75 6d 62 |eld a.lower numb|
00001320 65 72 20 74 68 61 6e 20 70 72 65 76 69 6f 75 73 |er than previous|
00001330 6c 79 20 74 68 65 20 66 69 65 6c 64 73 20 61 62 |ly the fields ab|
00001340 6f 76 65 20 74 68 65 20 6e 65 77 20 70 6f 73 69 |ove the new posi|
00001350 74 69 6f 6e 20 61 72 65 20 61 6c 6c 20 6d 6f 76 |tion are all mov|
00001360 65 64 0a 75 70 20 6f 6e 65 20 70 6c 61 63 65 20 |ed.up one place |
00001370 74 6f 20 6f 70 65 6e 20 61 20 67 61 70 20 66 6f |to open a gap fo|
00001380 72 20 69 74 2c 20 61 74 20 74 68 65 20 73 61 6d |r it, at the sam|
00001390 65 20 74 69 6d 65 20 63 6c 6f 73 69 6e 67 20 75 |e time closing u|
000013a0 70 20 74 68 65 20 67 61 70 20 6c 65 66 74 0a 62 |p the gap left.b|
000013b0 79 20 6d 6f 76 69 6e 67 20 74 68 65 20 63 75 72 |y moving the cur|
000013c0 72 65 6e 74 20 66 69 65 6c 64 20 66 72 6f 6d 20 |rent field from |
000013d0 69 74 73 20 6f 6c 64 20 70 6f 73 69 74 69 6f 6e |its old position|
000013e0 2e 20 49 66 20 69 74 20 69 73 20 62 65 69 6e 67 |. If it is being|
000013f0 20 67 69 76 65 6e 20 61 0a 68 69 67 68 65 72 20 | given a.higher |
00001400 6e 75 6d 62 65 72 20 74 68 65 20 66 69 65 6c 64 |number the field|
00001410 73 20 61 62 6f 76 65 20 69 74 73 20 6f 6c 64 20 |s above its old |
00001420 70 6f 73 69 74 69 6f 6e 20 61 6c 6c 20 6d 6f 76 |position all mov|
00001430 65 20 64 6f 77 6e 20 6f 6e 65 20 70 6c 61 63 65 |e down one place|
00001440 2c 0a 63 6c 6f 73 69 6e 67 20 75 70 20 74 68 65 |,.closing up the|
00001450 20 67 61 70 20 6c 65 66 74 20 62 79 20 69 74 73 | gap left by its|
00001460 20 72 65 6d 6f 76 61 6c 20 61 6e 64 20 6f 70 65 | removal and ope|
00001470 6e 69 6e 67 20 61 20 67 61 70 20 69 6e 20 74 68 |ning a gap in th|
00001480 65 20 72 65 71 75 69 72 65 64 0a 70 6c 61 63 65 |e required.place|
00001490 20 66 61 72 74 68 65 72 20 75 70 20 74 68 65 20 | farther up the |
000014a0 73 65 71 75 65 6e 63 65 2e 0a 0a 59 6f 75 20 63 |sequence...You c|
000014b0 61 6e 2c 20 69 66 20 79 6f 75 20 77 69 73 68 2c |an, if you wish,|
000014c0 20 62 75 69 6c 64 20 75 70 20 74 68 65 20 72 65 | build up the re|
000014d0 63 6f 72 64 20 62 79 20 63 72 65 61 74 69 6e 67 |cord by creating|
000014e0 20 6d 6f 72 65 20 66 69 65 6c 64 73 20 69 6e 20 | more fields in |
000014f0 74 68 65 0a 73 61 6d 65 20 77 61 79 20 61 6e 64 |the.same way and|
00001500 20 74 68 65 6e 20 67 6f 20 73 74 72 61 69 67 68 | then go straigh|
00001510 74 20 74 6f 20 74 68 65 20 6e 65 78 74 20 6d 61 |t to the next ma|
00001520 69 6e 20 73 65 63 74 69 6f 6e 20 28 53 70 65 63 |in section (Spec|
00001530 69 66 79 69 6e 67 20 74 68 65 0a 64 61 74 61 62 |ifying the.datab|
00001540 61 73 65 20 73 69 7a 65 29 2e 20 49 66 2c 20 68 |ase size). If, h|
00001550 6f 77 65 76 65 72 2c 20 79 6f 75 20 77 61 6e 74 |owever, you want|
00001560 20 6d 6f 72 65 20 61 74 20 74 68 69 73 20 73 74 | more at this st|
00001570 61 67 65 20 72 65 61 64 20 6f 6e 21 0a 0a 52 65 |age read on!..Re|
00001580 2d 73 69 7a 69 6e 67 20 74 68 65 20 62 6f 75 6e |-sizing the boun|
00001590 64 69 6e 67 20 62 6f 78 0a 2d 2d 2d 2d 2d 2d 2d |ding box.-------|
000015a0 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------|
000015b0 2d 2d 2d 0a 4c 65 66 74 20 74 6f 20 69 74 73 65 |---.Left to itse|
000015c0 6c 66 20 50 6f 77 65 72 62 61 73 65 20 6d 61 6b |lf Powerbase mak|
000015d0 65 73 20 61 6c 6c 20 69 74 73 20 66 69 65 6c 64 |es all its field|
000015e0 20 69 63 6f 6e 73 20 74 68 65 20 73 61 6d 65 20 | icons the same |
000015f0 68 65 69 67 68 74 20 61 6e 64 20 6f 66 20 61 0a |height and of a.|
00001600 73 75 69 74 61 62 6c 65 20 6c 65 6e 67 74 68 20 |suitable length |
00001610 74 6f 20 63 6f 6e 74 61 69 6e 20 74 68 65 20 6e |to contain the n|
00001620 75 6d 62 65 72 20 6f 66 20 63 68 61 72 61 63 74 |umber of charact|
00001630 65 72 73 20 73 70 65 63 69 66 69 65 64 20 69 6e |ers specified in|
00001640 20 27 44 61 74 61 0a 6c 65 6e 67 74 68 27 2e 20 | 'Data.length'. |
00001650 54 68 69 73 20 6d 61 79 20 6e 6f 74 20 62 65 20 |This may not be |
00001660 71 75 69 74 65 20 77 68 61 74 20 79 6f 75 20 77 |quite what you w|
00001670 61 6e 74 2e 20 49 66 20 74 68 65 20 44 61 74 61 |ant. If the Data|
00001680 20 6c 65 6e 67 74 68 20 69 73 20 6d 6f 72 65 0a | length is more.|
00001690 74 68 61 6e 20 61 62 6f 75 74 20 37 30 20 74 68 |than about 70 th|
000016a0 65 20 66 69 65 6c 64 20 72 75 6e 73 20 6f 66 66 |e field runs off|
000016b0 20 74 68 65 20 72 69 67 68 74 20 65 64 67 65 20 | the right edge |
000016c0 6f 66 20 74 68 65 20 77 69 6e 64 6f 77 2e 20 59 |of the window. Y|
000016d0 6f 75 20 6d 61 79 20 61 6c 73 6f 0a 77 61 6e 74 |ou may also.want|
000016e0 20 74 6f 20 6d 61 6b 65 20 74 68 65 20 66 69 65 | to make the fie|
000016f0 6c 64 20 74 61 6c 6c 65 72 20 66 6f 72 20 65 6d |ld taller for em|
00001700 70 68 61 73 69 73 2e 20 28 42 75 74 20 4e 4f 54 |phasis. (But NOT|
00001710 20 66 6f 72 20 64 69 73 70 6c 61 79 69 6e 67 20 | for displaying |
00001720 6d 75 6c 74 69 70 6c 65 0a 6c 69 6e 65 73 2e 20 |multiple.lines. |
00001730 4f 6e 6c 79 20 66 69 65 6c 64 73 20 6f 66 20 27 |Only fields of '|
00001740 54 65 78 74 20 62 6c 6f 63 6b 27 20 74 79 70 65 |Text block' type|
00001750 20 63 61 6e 20 62 65 20 6d 75 6c 74 69 2d 6c 69 | can be multi-li|
00001760 6e 65 2e 20 54 68 65 73 65 20 61 72 65 0a 64 69 |ne. These are.di|
00001770 73 63 75 73 73 65 64 20 6c 61 74 65 72 2e 29 20 |scussed later.) |
00001780 54 68 65 72 65 20 61 72 65 20 74 77 6f 20 77 61 |There are two wa|
00001790 79 73 20 6f 66 20 61 6c 74 65 72 69 6e 67 20 74 |ys of altering t|
000017a0 68 65 20 73 69 7a 65 20 6f 66 20 61 20 66 69 65 |he size of a fie|
000017b0 6c 64 27 73 0a 62 6f 75 6e 64 69 6e 67 20 62 6f |ld's.bounding bo|
000017c0 78 3a 2d 0a 0a 20 20 20 20 20 20 20 20 28 61 29 |x:-.. (a)|
000017d0 20 42 79 20 64 72 61 67 67 69 6e 67 20 77 69 74 | By dragging wit|
000017e0 68 20 41 44 4a 55 53 54 2e 0a 20 20 20 20 20 20 |h ADJUST.. |
000017f0 20 20 28 62 29 20 42 79 20 74 79 70 69 6e 67 20 | (b) By typing |
00001800 69 6e 20 74 68 65 20 72 65 71 75 69 72 65 64 20 |in the required |
00001810 77 69 64 74 68 20 61 6e 64 20 68 65 69 67 68 74 |width and height|
00001820 20 69 6e 20 74 68 65 20 27 44 61 74 61 20 66 69 | in the 'Data fi|
00001830 65 6c 64 27 0a 20 20 20 20 20 20 20 20 64 69 61 |eld'. dia|
00001840 6c 6f 67 75 65 20 62 6f 78 2e 20 54 68 65 20 75 |logue box. The u|
00001850 6e 69 74 73 20 75 73 65 64 20 61 72 65 20 73 75 |nits used are su|
00001860 63 68 20 74 68 61 74 2c 20 69 6e 20 74 68 65 20 |ch that, in the |
00001870 6d 6f 73 74 20 63 6f 6d 6d 6f 6e 0a 20 20 20 20 |most common. |
00001880 20 20 20 20 73 63 72 65 65 6e 20 6d 6f 64 65 73 | screen modes|
00001890 20 73 75 63 68 20 61 73 20 31 32 20 61 6e 64 20 | such as 12 and |
000018a0 31 35 2c 20 61 20 63 68 61 72 61 63 74 65 72 20 |15, a character |
000018b0 69 73 20 31 36 20 75 6e 69 74 73 20 77 69 64 65 |is 16 units wide|
000018c0 20 61 6e 64 20 33 32 0a 20 20 20 20 20 20 20 20 | and 32. |
000018d0 68 69 67 68 20 61 6e 64 20 74 68 65 20 73 63 72 |high and the scr|
000018e0 65 65 6e 20 69 74 73 65 6c 66 20 69 73 20 31 32 |een itself is 12|
000018f0 34 30 20 75 6e 69 74 73 20 77 69 64 65 20 61 6e |40 units wide an|
00001900 64 20 31 30 32 34 20 68 69 67 68 2e 20 28 4e 2e |d 1024 high. (N.|
00001910 42 2e 0a 20 20 20 20 20 20 20 20 74 68 65 20 64 |B.. the d|
00001920 65 66 61 75 6c 74 20 68 65 69 67 68 74 20 66 6f |efault height fo|
00001930 72 20 62 6f 75 6e 64 69 6e 67 20 62 6f 78 65 73 |r bounding boxes|
00001940 20 69 73 20 34 38 20 75 6e 69 74 73 2e 29 0a 0a | is 48 units.)..|
00001950 42 65 73 69 64 65 73 20 61 6c 74 65 72 69 6e 67 |Besides altering|
00001960 20 74 68 65 20 73 69 7a 65 20 6f 66 20 74 68 65 | the size of the|
00001970 20 62 6f 75 6e 64 69 6e 67 20 62 6f 78 20 62 79 | bounding box by|
00001980 20 74 79 70 69 6e 67 20 74 68 65 20 64 61 74 61 | typing the data|
00001990 20 64 69 72 65 63 74 6c 79 2c 0a 79 6f 75 20 6d | directly,.you m|
000019a0 61 79 20 61 64 6a 75 73 74 20 69 74 73 20 70 6f |ay adjust its po|
000019b0 73 69 74 69 6f 6e 20 69 6e 20 74 68 65 20 73 61 |sition in the sa|
000019c0 6d 65 20 77 61 79 20 62 79 20 65 6e 74 65 72 69 |me way by enteri|
000019d0 6e 67 20 74 68 65 20 58 20 61 6e 64 20 59 0a 63 |ng the X and Y.c|
000019e0 6f 2d 6f 72 64 69 6e 61 74 65 73 20 6f 66 20 74 |o-ordinates of t|
000019f0 68 65 20 6c 6f 77 65 72 20 6c 65 66 74 20 63 6f |he lower left co|
00001a00 72 6e 65 72 2e 20 54 68 65 20 75 6e 69 74 73 20 |rner. The units |
00001a10 61 72 65 20 74 68 65 20 73 61 6d 65 20 61 73 20 |are the same as |
00001a20 66 6f 72 20 77 69 64 74 68 0a 61 6e 64 20 68 65 |for width.and he|
00001a30 69 67 68 74 20 62 75 74 20 74 68 65 20 6f 72 69 |ight but the ori|
00001a40 67 69 6e 20 69 73 20 74 68 65 20 54 4f 50 20 6c |gin is the TOP l|
00001a50 65 66 74 20 63 6f 72 6e 65 72 20 6f 66 20 74 68 |eft corner of th|
00001a60 65 20 72 65 63 6f 72 64 20 77 69 6e 64 6f 77 2e |e record window.|
00001a70 20 54 68 69 73 0a 6d 65 61 6e 73 20 74 68 61 74 | This.means that|
00001a80 20 74 68 65 20 59 20 76 61 6c 75 65 73 20 61 72 | the Y values ar|
00001a90 65 20 61 6c 77 61 79 73 20 6e 65 67 61 74 69 76 |e always negativ|
00001aa0 65 2e 0a 0a 4d 6f 72 65 20 61 62 6f 75 74 20 74 |e...More about t|
00001ab0 61 67 73 20 61 6e 64 20 64 65 73 63 72 69 70 74 |ags and descript|
00001ac0 6f 72 73 0a 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |ors.------------|
00001ad0 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------|
00001ae0 2d 2d 2d 0a 54 61 67 73 20 61 72 65 20 6f 66 20 |---.Tags are of |
00001af0 67 72 65 61 74 20 69 6d 70 6f 72 74 61 6e 63 65 |great importance|
00001b00 20 69 6e 20 50 6f 77 65 72 62 61 73 65 2e 20 54 | in Powerbase. T|
00001b10 68 65 79 20 61 72 65 20 75 73 65 64 20 77 68 65 |hey are used whe|
00001b20 6e 20 71 75 65 72 79 69 6e 67 20 74 68 65 0a 64 |n querying the.d|
00001b30 61 74 61 62 61 73 65 20 74 6f 20 70 72 6f 64 75 |atabase to produ|
00001b40 63 65 20 72 65 70 6f 72 74 73 2c 20 65 78 70 6f |ce reports, expo|
00001b50 72 74 20 43 53 56 20 66 69 6c 65 73 20 65 74 63 |rt CSV files etc|
00001b60 2e 20 61 6e 64 20 61 6c 73 6f 20 62 79 20 73 6f |. and also by so|
00001b70 6d 65 20 69 6e 74 65 72 6e 61 6c 0a 6f 70 65 72 |me internal.oper|
00001b80 61 74 69 6f 6e 73 2e 20 45 76 65 72 79 20 77 72 |ations. Every wr|
00001b90 69 74 61 62 6c 65 20 66 69 65 6c 64 20 6d 75 73 |itable field mus|
00001ba0 74 20 68 61 76 65 20 61 20 74 61 67 20 61 6e 64 |t have a tag and|
00001bb0 20 6e 6f 20 74 77 6f 20 66 69 65 6c 64 73 20 6d | no two fields m|
00001bc0 61 79 20 68 61 76 65 0a 74 68 65 20 73 61 6d 65 |ay have.the same|
00001bd0 20 74 61 67 2e 20 44 65 73 63 72 69 70 74 6f 72 | tag. Descriptor|
00001be0 73 20 61 72 65 20 6c 65 73 73 20 69 6d 70 6f 72 |s are less impor|
00001bf0 74 61 6e 74 2e 20 54 68 65 69 72 20 6d 61 69 6e |tant. Their main|
00001c00 20 70 75 72 70 6f 73 65 20 69 73 20 74 6f 0a 70 | purpose is to.p|
00001c10 72 6f 76 69 64 65 20 76 69 73 69 62 6c 65 20 6c |rovide visible l|
00001c20 61 62 65 6c 73 20 66 6f 72 20 66 69 65 6c 64 73 |abels for fields|
00001c30 20 61 6e 64 20 69 6e 20 73 6f 6d 65 20 63 61 73 | and in some cas|
00001c40 65 73 20 79 6f 75 20 6d 61 79 20 6e 6f 74 20 6e |es you may not n|
00001c50 65 65 64 20 61 0a 64 65 73 63 72 69 70 74 6f 72 |eed a.descriptor|
00001c60 20 61 74 20 61 6c 6c 2e 20 65 2e 67 2e 20 49 66 | at all. e.g. If|
00001c70 20 79 6f 75 72 20 64 61 74 61 62 61 73 65 20 69 | your database i|
00001c80 73 20 74 6f 20 68 6f 6c 64 20 6e 61 6d 65 73 20 |s to hold names |
00001c90 61 6e 64 20 61 64 64 72 65 73 73 65 73 20 79 6f |and addresses yo|
00001ca0 75 0a 6d 69 67 68 74 20 77 61 6e 74 20 74 68 65 |u.might want the|
00001cb0 20 72 65 63 6f 72 64 20 74 6f 20 6c 6f 6f 6b 20 | record to look |
00001cc0 6c 69 6b 65 20 74 68 69 73 3a 2d 0a 0a 20 20 20 |like this:-.. |
00001cd0 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
00001ce0 20 20 20 20 20 20 20 20 4e 41 4d 45 20 46 72 65 | NAME Fre|
00001cf0 64 20 42 6c 6f 67 67 73 0a 20 20 20 20 20 20 20 |d Bloggs. |
00001d00 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
00001d10 20 41 44 44 52 45 53 53 20 32 37 2c 20 45 76 65 | ADDRESS 27, Eve|
00001d20 72 79 20 53 74 72 65 65 74 0a 20 20 20 20 20 20 |ry Street. |
00001d30 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
00001d40 20 20 20 20 20 20 20 20 20 20 41 6e 79 74 6f 77 | Anytow|
00001d50 6e 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 |n. |
00001d60 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
00001d70 20 20 57 6f 6f 6c 73 68 69 72 65 0a 20 20 20 20 | Woolshire. |
00001d80 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
00001d90 20 20 20 20 20 20 20 20 20 20 20 20 57 4c 34 20 | WL4 |
00001da0 37 58 5a 0a 0a 54 68 65 72 65 20 61 72 65 20 35 |7XZ..There are 5|
00001db0 20 66 69 65 6c 64 73 20 68 65 72 65 20 62 75 74 | fields here but|
00001dc0 2c 20 68 61 76 69 6e 67 20 67 69 76 65 6e 20 74 |, having given t|
00001dd0 68 65 20 73 65 63 6f 6e 64 20 6f 6e 65 20 74 68 |he second one th|
00001de0 65 20 64 65 73 63 72 69 70 74 6f 72 0a 41 44 44 |e descriptor.ADD|
00001df0 52 45 53 53 2c 20 79 6f 75 20 64 6f 6e 27 74 20 |RESS, you don't |
00001e00 72 65 61 6c 6c 79 20 77 61 6e 74 20 64 65 73 63 |really want desc|
00001e10 72 69 70 74 6f 72 73 20 66 6f 72 20 74 68 65 20 |riptors for the |
00001e20 72 65 6d 61 69 6e 69 6e 67 20 33 20 28 65 78 63 |remaining 3 (exc|
00001e30 65 70 74 0a 70 65 72 68 61 70 73 20 50 4f 53 54 |ept.perhaps POST|
00001e40 43 4f 44 45 20 66 6f 72 20 74 68 65 20 6c 61 73 |CODE for the las|
00001e50 74 29 2e 20 49 74 20 69 73 20 71 75 69 74 65 20 |t). It is quite |
00001e60 69 6e 20 6f 72 64 65 72 20 74 6f 20 68 61 76 65 |in order to have|
00001e70 20 6e 75 6c 6c 0a 64 65 73 63 72 69 70 74 6f 72 | null.descriptor|
00001e80 73 20 6c 69 6b 65 20 74 68 69 73 2c 20 62 75 74 |s like this, but|
00001e90 20 79 6f 75 72 20 4d 55 53 54 20 67 69 76 65 20 | your MUST give |
00001ea0 65 61 63 68 20 66 69 65 6c 64 20 61 20 74 61 67 |each field a tag|
00001eb0 2e 20 53 75 69 74 61 62 6c 65 20 6f 6e 65 73 0a |. Suitable ones.|
00001ec0 6d 69 67 68 74 20 62 65 20 4e 41 4d 45 2c 20 41 |might be NAME, A|
00001ed0 44 44 31 2c 20 41 44 44 32 2c 20 41 44 44 33 2c |DD1, ADD2, ADD3,|
00001ee0 20 41 44 44 34 2e 20 28 52 65 6d 65 6d 62 65 72 | ADD4. (Remember|
00001ef0 20 74 68 65 79 20 6d 75 73 74 20 62 65 20 75 6e | they must be un|
00001f00 69 71 75 65 20 61 6e 64 20 6e 6f 74 0a 6d 6f 72 |ique and not.mor|
00001f10 65 20 74 68 61 6e 20 34 20 63 68 61 72 61 63 74 |e than 4 charact|
00001f20 65 72 73 2e 29 0a 0a 54 68 65 20 6f 6e 6c 79 20 |ers.)..The only |
00001f30 63 61 73 65 73 20 69 6e 20 77 68 69 63 68 20 79 |cases in which y|
00001f40 6f 75 20 6d 61 79 20 6f 6d 69 74 20 74 68 65 20 |ou may omit the |
00001f50 74 61 67 20 69 73 20 77 68 65 72 65 20 74 68 65 |tag is where the|
00001f60 20 66 69 65 6c 64 20 69 73 20 73 69 6d 70 6c 79 | field is simply|
00001f70 20 61 6e 0a 65 78 70 6c 61 6e 61 74 6f 72 79 20 | an.explanatory |
00001f80 6c 61 62 65 6c 20 61 6e 64 20 63 6f 6e 74 61 69 |label and contai|
00001f90 6e 73 20 6e 6f 20 61 63 74 75 61 6c 20 64 61 74 |ns no actual dat|
00001fa0 61 20 73 6f 20 74 68 61 74 20 74 68 65 72 65 20 |a so that there |
00001fb0 77 6f 75 6c 64 20 62 65 20 6e 6f 0a 72 65 61 73 |would be no.reas|
00001fc0 6f 6e 20 74 6f 20 69 6e 63 6c 75 64 65 20 69 74 |on to include it|
00001fd0 20 69 6e 20 61 20 71 75 65 72 79 2e 0a 0a 4f 74 | in a query...Ot|
00001fe0 68 65 72 20 74 79 70 65 73 20 6f 66 20 44 61 74 |her types of Dat|
00001ff0 61 20 66 69 65 6c 64 0a 2d 2d 2d 2d 2d 2d 2d 2d |a field.--------|
00002000 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------|
00002010 2d 0a 53 6f 20 66 61 72 20 77 65 20 68 61 76 65 |-.So far we have|
00002020 20 6f 6e 6c 79 20 75 73 65 64 20 66 69 65 6c 64 | only used field|
00002030 73 20 6f 66 20 27 41 6c 70 68 61 6e 75 6d 65 72 |s of 'Alphanumer|
00002040 69 63 27 20 74 79 70 65 2e 20 43 6c 69 63 6b 69 |ic' type. Clicki|
00002050 6e 67 20 6f 6e 20 74 68 65 0a 22 62 75 6d 70 20 |ng on the."bump |
00002060 69 63 6f 6e 73 22 20 74 6f 20 74 68 65 20 6c 65 |icons" to the le|
00002070 66 74 20 6f 66 20 74 68 65 20 66 69 65 6c 64 20 |ft of the field |
00002080 74 79 70 65 20 6c 65 74 73 20 79 6f 75 20 63 79 |type lets you cy|
00002090 63 6c 65 20 74 68 72 6f 75 67 68 20 74 68 65 0a |cle through the.|
000020a0 76 61 72 69 6f 75 73 20 74 79 70 65 73 20 61 76 |various types av|
000020b0 61 69 6c 61 62 6c 65 2e 20 54 68 65 73 65 20 61 |ailable. These a|
000020c0 72 65 3a 2d 0a 0a 20 20 20 20 20 20 20 20 28 61 |re:-.. (a|
000020d0 29 20 4e 6f 6e 65 20 20 20 20 20 20 20 20 20 20 |) None |
000020e0 20 20 20 20 20 20 41 63 63 65 70 74 73 20 61 6e | Accepts an|
000020f0 79 20 70 72 69 6e 74 61 62 6c 65 20 63 68 61 72 |y printable char|
00002100 61 63 74 65 72 2e 0a 20 20 20 20 20 20 20 20 28 |acter.. (|
00002110 62 29 20 41 6c 70 68 61 6e 75 6d 65 72 69 63 20 |b) Alphanumeric |
00002120 20 20 20 20 20 20 20 41 63 63 65 70 74 73 20 61 | Accepts a|
00002130 6c 6c 20 6c 65 74 74 65 72 73 20 61 6e 64 20 6e |ll letters and n|
00002140 75 6d 65 72 61 6c 73 20 61 6e 64 20 63 6f 6d 6d |umerals and comm|
00002150 6f 6e 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 |on. |
00002160 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
00002170 20 20 20 70 75 6e 63 74 75 61 74 69 6f 6e 2e 0a | punctuation..|
00002180 20 20 20 20 20 20 20 20 28 63 29 20 55 70 70 65 | (c) Uppe|
00002190 72 20 63 61 73 65 20 20 20 20 20 20 20 20 20 20 |r case |
000021a0 41 63 63 65 70 74 73 20 63 61 70 69 74 61 6c 20 |Accepts capital |
000021b0 6c 65 74 74 65 72 73 20 61 6e 64 20 6e 75 6d 65 |letters and nume|
000021c0 72 61 6c 73 20 6f 6e 6c 79 2e 0a 20 20 20 20 20 |rals only.. |
000021d0 20 20 20 28 64 29 20 4e 75 6d 62 65 72 20 20 20 | (d) Number |
000021e0 20 20 20 20 20 20 20 20 20 20 20 41 63 63 65 70 | Accep|
000021f0 74 73 20 6e 75 6d 65 72 61 6c 73 2c 2b 2c 2d 20 |ts numerals,+,- |
00002200 61 6e 64 20 2e 20 28 64 65 63 69 6d 61 6c 20 70 |and . (decimal p|
00002210 6f 69 6e 74 29 2e 0a 20 20 20 20 20 20 20 20 28 |oint).. (|
00002220 65 29 20 59 65 73 2f 4e 6f 20 20 20 20 20 20 20 |e) Yes/No |
00002230 20 20 20 20 20 20 20 41 63 63 65 70 74 73 20 59 | Accepts Y|
00002240 20 61 6e 64 20 4e 20 6f 6e 6c 79 0a 20 20 20 20 | and N only. |
00002250 20 20 20 20 28 64 29 20 44 61 74 65 20 20 20 20 | (d) Date |
00002260 20 20 20 20 20 20 20 20 20 20 20 20 41 63 63 65 | Acce|
00002270 70 74 73 20 64 61 74 65 73 20 69 6e 20 74 68 65 |pts dates in the|
00002280 20 66 6f 72 6d 20 64 64 2d 6d 6d 2d 79 79 20 6f | form dd-mm-yy o|
00002290 72 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 |r. |
000022a0 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
000022b0 20 20 64 64 2d 6d 6d 2d 79 79 79 79 2e 0a 20 20 | dd-mm-yyyy.. |
000022c0 20 20 20 20 20 20 28 65 29 20 43 61 6c 63 75 6c | (e) Calcul|
000022d0 61 74 65 64 20 20 20 20 20 20 20 20 20 20 43 61 |ated Ca|
000022e0 6e 27 74 20 62 65 20 74 79 70 65 64 20 69 6e 74 |n't be typed int|
000022f0 6f 20 64 69 72 65 63 74 6c 79 2e 20 54 61 6b 65 |o directly. Take|
00002300 73 20 69 74 73 0a 20 20 20 20 20 20 20 20 20 20 |s its. |
00002310 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
00002320 20 20 20 20 20 20 76 61 6c 75 65 20 66 72 6f 6d | value from|
00002330 20 6f 74 68 65 72 20 28 4e 75 6d 65 72 69 63 29 | other (Numeric)|
00002340 20 66 69 65 6c 64 73 2e 20 0a 20 20 20 20 20 20 | fields. . |
00002350 20 20 28 66 29 20 43 6f 6d 70 6f 73 69 74 65 20 | (f) Composite |
00002360 20 20 20 20 20 20 20 20 20 20 53 69 6d 69 6c 61 | Simila|
00002370 72 20 74 6f 20 61 20 43 61 6c 63 75 6c 61 74 65 |r to a Calculate|
00002380 64 20 66 69 65 6c 64 2c 20 62 75 74 20 66 6f 72 |d field, but for|
00002390 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 |. |
000023a0 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
000023b0 20 74 65 78 74 75 61 6c 20 72 61 74 68 65 72 20 | textual rather |
000023c0 74 68 61 6e 20 6e 75 6d 65 72 69 63 20 64 61 74 |than numeric dat|
000023d0 61 2e 0a 20 20 20 20 20 20 20 20 28 67 29 20 54 |a.. (g) T|
000023e0 69 6d 65 20 20 20 20 20 20 20 20 20 20 20 20 20 |ime |
000023f0 20 20 20 41 63 63 65 70 74 73 20 74 69 6d 65 73 | Accepts times|
00002400 20 69 6e 20 74 68 65 20 66 6f 72 6d 20 68 68 3a | in the form hh:|
00002410 6d 6d 3a 73 73 20 75 70 20 74 6f 0a 20 20 20 20 |mm:ss up to. |
00002420 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
00002430 20 20 20 20 20 20 20 20 20 20 20 20 61 20 6d 61 | a ma|
00002440 78 69 6d 75 6d 20 76 61 6c 75 65 20 6f 66 20 32 |ximum value of 2|
00002450 33 3a 35 39 3a 35 39 2e 0a 20 20 20 20 20 20 20 |3:59:59.. |
00002460 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
00002470 20 20 20 20 20 20 20 20 20 0a 41 73 20 61 6e 20 | .As an |
00002480 61 6c 74 65 72 6e 61 74 69 76 65 20 74 6f 20 74 |alternative to t|
00002490 68 65 20 22 62 75 6d 70 22 20 69 63 6f 6e 73 20 |he "bump" icons |
000024a0 79 6f 75 20 6d 61 79 20 63 6c 69 63 6b 20 77 69 |you may click wi|
000024b0 74 68 20 53 45 4c 45 43 54 20 6f 72 20 4d 45 4e |th SELECT or MEN|
000024c0 55 20 6f 6e 0a 74 68 65 20 72 69 67 68 74 2d 70 |U on.the right-p|
000024d0 6f 69 6e 74 69 6e 67 20 61 72 72 6f 77 20 74 6f |ointing arrow to|
000024e0 20 74 68 65 20 72 69 67 68 74 20 6f 66 20 74 68 | the right of th|
000024f0 65 20 66 69 65 6c 64 2d 74 79 70 65 20 69 63 6f |e field-type ico|
00002500 6e 2e 20 54 68 69 73 20 64 69 73 70 6c 61 79 73 |n. This displays|
00002510 0a 61 20 6d 65 6e 75 20 6f 66 20 66 69 65 6c 64 |.a menu of field|
00002520 20 74 79 70 65 73 20 66 72 6f 6d 20 77 68 69 63 | types from whic|
00002530 68 20 74 6f 20 6d 61 6b 65 20 79 6f 75 72 20 63 |h to make your c|
00002540 68 6f 69 63 65 2e 20 20 20 20 20 20 20 20 20 20 |hoice. |
00002550 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
00002560 20 20 20 20 20 20 20 20 20 20 20 20 20 20 0a 57 | .W|
00002570 68 65 6e 20 27 4e 75 6d 65 72 69 63 27 20 6f 72 |hen 'Numeric' or|
00002580 20 27 43 61 6c 63 75 6c 61 74 65 64 27 20 69 73 | 'Calculated' is|
00002590 20 73 65 6c 65 63 74 65 64 2c 20 63 65 72 74 61 | selected, certa|
000025a0 69 6e 20 69 63 6f 6e 73 20 69 6e 20 74 68 65 20 |in icons in the |
000025b0 64 69 61 6c 6f 67 75 65 0a 62 6f 78 20 77 68 69 |dialogue.box whi|
000025c0 63 68 20 61 72 65 20 6e 6f 72 6d 61 6c 6c 79 20 |ch are normally |
000025d0 73 68 61 64 65 64 20 62 65 63 6f 6d 65 20 61 76 |shaded become av|
000025e0 61 69 6c 61 62 6c 65 2e 20 54 68 75 73 2c 20 79 |ailable. Thus, y|
000025f0 6f 75 20 63 61 6e 20 6d 61 6b 65 20 73 75 63 68 |ou can make such|
00002600 20 61 0a 66 69 65 6c 64 20 6f 66 20 66 69 78 65 | a.field of fixe|
00002610 64 2d 70 6f 69 6e 74 20 74 79 70 65 20 61 6e 64 |d-point type and|
00002620 20 50 6f 77 65 72 62 61 73 65 20 77 69 6c 6c 20 | Powerbase will |
00002630 6d 6f 64 69 66 79 20 77 68 61 74 65 76 65 72 20 |modify whatever |
00002640 79 6f 75 20 74 79 70 65 20 69 6e 20 73 6f 0a 74 |you type in so.t|
00002650 68 61 74 20 69 74 20 69 73 20 64 69 73 70 6c 61 |hat it is displa|
00002660 79 65 64 20 74 6f 20 74 68 65 20 73 70 65 63 69 |yed to the speci|
00002670 66 69 65 64 20 6e 75 6d 62 65 72 20 6f 66 20 64 |fied number of d|
00002680 65 63 69 6d 61 6c 20 70 6c 61 63 65 73 2e 20 46 |ecimal places. F|
00002690 6f 72 0a 27 4e 75 6d 65 72 69 63 27 20 66 69 65 |or.'Numeric' fie|
000026a0 6c 64 73 20 6f 6e 6c 79 2c 20 79 6f 75 20 6d 61 |lds only, you ma|
000026b0 79 20 61 6c 73 6f 20 73 70 65 63 69 66 79 20 61 |y also specify a|
000026c0 6e 20 75 70 70 65 72 20 61 6e 64 20 6c 6f 77 65 |n upper and lowe|
000026d0 72 20 6c 69 6d 69 74 20 66 6f 72 0a 6e 75 6d 62 |r limit for.numb|
000026e0 65 72 73 20 77 68 69 63 68 20 6d 61 79 20 62 65 |ers which may be|
000026f0 20 65 6e 74 65 72 65 64 20 69 6e 20 74 68 65 73 | entered in thes|
00002700 65 20 66 69 65 6c 64 73 2e 0a 0a 41 20 27 44 61 |e fields...A 'Da|
00002710 74 65 27 20 66 69 65 6c 64 20 73 68 6f 75 6c 64 |te' field should|
00002720 20 62 65 20 65 69 74 68 65 72 20 38 20 6f 72 20 | be either 8 or |
00002730 31 30 20 63 68 61 72 61 63 74 65 72 73 20 6c 6f |10 characters lo|
00002740 6e 67 20 69 6e 20 6f 72 64 65 72 20 74 6f 20 68 |ng in order to h|
00002750 6f 6c 64 20 74 68 65 0a 64 61 74 65 20 69 6e 20 |old the.date in |
00002760 6f 6e 65 20 6f 66 20 74 68 65 20 74 77 6f 20 66 |one of the two f|
00002770 6f 72 6d 61 74 73 20 73 70 65 63 69 66 69 65 64 |ormats specified|
00002780 20 61 62 6f 76 65 2e 20 54 68 65 20 73 65 70 61 | above. The sepa|
00002790 72 61 74 6f 72 20 69 6e 20 74 68 65 73 65 20 64 |rator in these d|
000027a0 61 74 65 73 0a 6e 65 65 64 20 6e 6f 74 20 62 65 |ates.need not be|
000027b0 20 61 20 68 79 70 68 65 6e 2e 20 4c 6f 6f 6b 20 | a hyphen. Look |
000027c0 69 6e 20 74 68 65 20 50 6f 77 65 72 62 61 73 65 |in the Powerbase|
000027d0 20 64 69 72 65 63 74 6f 72 79 20 66 6f 72 20 61 | directory for a|
000027e0 20 73 75 62 64 69 72 65 63 74 6f 72 79 0a 63 61 | subdirectory.ca|
000027f0 6c 6c 65 64 20 27 52 65 73 6f 75 72 63 65 73 27 |lled 'Resources'|
00002800 2e 20 49 6e 73 69 64 65 20 69 74 20 69 73 20 61 |. Inside it is a|
00002810 20 66 69 6c 65 20 63 61 6c 6c 65 64 20 27 43 6f | file called 'Co|
00002820 6e 66 69 67 27 2e 20 4c 6f 61 64 20 74 68 69 73 |nfig'. Load this|
00002830 20 69 6e 74 6f 0a 45 64 69 74 2e 20 54 68 65 72 | into.Edit. Ther|
00002840 65 20 69 73 20 61 20 6c 69 6e 65 20 73 70 65 63 |e is a line spec|
00002850 69 66 79 69 6e 67 20 74 68 65 20 63 68 61 72 61 |ifying the chara|
00002860 63 74 65 72 20 74 6f 20 62 65 20 75 73 65 64 20 |cter to be used |
00002870 61 73 20 61 20 64 61 74 65 0a 73 65 70 61 72 61 |as a date.separa|
00002880 74 6f 72 2e 20 49 66 20 79 6f 75 20 63 68 61 6e |tor. If you chan|
00002890 67 65 20 74 68 69 73 20 6d 61 6b 65 20 73 75 72 |ge this make sur|
000028a0 65 20 69 74 20 69 73 20 74 68 65 20 66 69 72 73 |e it is the firs|
000028b0 74 20 63 68 61 72 61 63 74 65 72 20 6f 6e 20 74 |t character on t|
000028c0 68 65 0a 6c 69 6e 65 2e 20 4e 6f 74 65 20 74 68 |he.line. Note th|
000028d0 61 74 20 74 68 65 20 61 63 74 75 61 6c 20 54 59 |at the actual TY|
000028e0 50 49 4e 47 20 49 4e 20 6f 66 20 64 61 74 65 73 |PING IN of dates|
000028f0 20 61 6c 6c 6f 77 73 20 66 61 72 20 6d 6f 72 65 | allows far more|
00002900 20 66 6c 65 78 69 62 69 6c 69 74 79 2e 0a 59 6f | flexibility..Yo|
00002910 75 20 6d 61 79 20 74 79 70 65 20 41 4e 59 20 6e |u may type ANY n|
00002920 6f 6e 2d 6e 75 6d 65 72 69 63 20 63 68 61 72 61 |on-numeric chara|
00002930 63 74 65 72 20 61 73 20 61 20 73 65 70 61 72 61 |cter as a separa|
00002940 74 6f 72 20 61 6e 64 20 50 6f 77 65 72 62 61 73 |tor and Powerbas|
00002950 65 20 77 69 6c 6c 0a 6d 61 6b 65 20 73 65 6e 73 |e will.make sens|
00002960 65 20 6f 66 20 65 6e 74 72 69 65 73 20 73 75 63 |e of entries suc|
00002970 68 20 61 73 20 34 2f 35 2f 38 37 2c 20 64 75 6c |h as 4/5/87, dul|
00002980 79 20 63 6f 6e 76 65 72 74 69 6e 67 20 69 74 20 |y converting it |
00002990 74 6f 20 30 34 2d 30 35 2d 38 37 20 77 68 65 6e |to 04-05-87 when|
000029a0 0a 79 6f 75 20 70 72 65 73 73 20 52 45 54 55 52 |.you press RETUR|
000029b0 4e 2e 0a 0a 41 20 27 43 61 6c 63 75 6c 61 74 65 |N...A 'Calculate|
000029c0 64 27 20 66 69 65 6c 64 20 69 73 20 75 73 65 64 |d' field is used|
000029d0 20 77 68 65 6e 20 79 6f 75 20 77 61 6e 74 20 74 | when you want t|
000029e0 68 65 20 72 65 63 6f 72 64 20 74 6f 20 61 75 74 |he record to aut|
000029f0 6f 6d 61 74 69 63 61 6c 6c 79 0a 64 69 73 70 6c |omatically.displ|
00002a00 61 79 20 74 68 65 20 72 65 73 75 6c 74 20 6f 66 |ay the result of|
00002a10 20 61 20 63 61 6c 63 75 6c 61 74 69 6f 6e 20 62 | a calculation b|
00002a20 61 73 65 64 20 6f 6e 20 6f 74 68 65 72 20 66 69 |ased on other fi|
00002a30 65 6c 64 73 2e 20 53 69 6d 69 6c 61 72 6c 79 2c |elds. Similarly,|
00002a40 20 61 0a 27 43 6f 6d 70 6f 73 69 74 65 27 20 66 | a.'Composite' f|
00002a50 69 65 6c 64 20 6d 69 67 68 74 20 62 65 20 75 73 |ield might be us|
00002a60 65 64 20 74 6f 20 64 69 73 70 6c 61 79 20 61 20 |ed to display a |
00002a70 70 65 72 73 6f 6e 27 73 20 6e 61 6d 65 20 69 6e |person's name in|
00002a80 20 74 68 65 20 66 6f 72 6d 0a 46 4f 52 45 4e 41 | the form.FORENA|
00002a90 4d 45 20 53 55 52 4e 41 4d 45 20 77 68 65 6e 20 |ME SURNAME when |
00002aa0 74 68 65 20 64 61 74 61 20 61 63 74 75 61 6c 6c |the data actuall|
00002ab0 79 20 74 79 70 65 64 20 69 6e 20 75 73 65 73 20 |y typed in uses |
00002ac0 73 65 70 61 72 61 74 65 20 66 69 65 6c 64 73 20 |separate fields |
00002ad0 66 6f 72 0a 53 55 52 4e 41 4d 45 20 61 6e 64 20 |for.SURNAME and |
00002ae0 46 4f 52 45 4e 41 4d 45 2e 20 59 6f 75 20 64 6f |FORENAME. You do|
00002af0 6e 27 74 20 73 70 65 63 69 66 79 20 61 74 20 74 |n't specify at t|
00002b00 68 69 73 20 73 74 61 67 65 20 68 6f 77 20 74 68 |his stage how th|
00002b10 65 20 66 69 65 6c 64 20 76 61 6c 75 65 20 69 73 |e field value is|
00002b20 0a 64 65 72 69 76 65 64 3b 20 74 68 61 74 27 73 |.derived; that's|
00002b30 20 64 6f 6e 65 20 77 68 65 6e 20 74 68 65 20 64 | done when the d|
00002b40 61 74 61 62 61 73 65 20 69 73 20 61 63 74 75 61 |atabase is actua|
00002b50 6c 6c 79 20 77 6f 72 6b 69 6e 67 2e 0a 0a 41 20 |lly working...A |
00002b60 27 54 69 6d 65 27 20 66 69 65 6c 64 20 28 6c 69 |'Time' field (li|
00002b70 6b 65 20 61 20 64 61 74 65 29 20 69 73 20 63 68 |ke a date) is ch|
00002b80 65 63 6b 65 64 20 66 6f 72 20 76 61 6c 69 64 69 |ecked for validi|
00002b90 74 79 20 61 6e 64 20 28 61 67 61 69 6e 20 6c 69 |ty and (again li|
00002ba0 6b 65 20 61 20 64 61 74 65 29 0a 79 6f 75 20 6d |ke a date).you m|
00002bb0 61 79 20 62 65 20 66 61 69 72 6c 79 20 66 6c 65 |ay be fairly fle|
00002bc0 78 69 62 6c 65 20 69 6e 20 68 6f 77 20 79 6f 75 |xible in how you|
00002bd0 20 61 63 74 75 61 6c 6c 79 20 74 79 70 65 20 74 | actually type t|
00002be0 68 65 20 76 61 6c 75 65 73 20 69 6e 2e 20 49 66 |he values in. If|
00002bf0 20 79 6f 75 0a 65 6e 74 65 72 20 33 2e 34 35 3b | you.enter 3.45;|
00002c00 39 20 69 74 20 77 69 6c 6c 20 62 65 20 72 65 66 |9 it will be ref|
00002c10 6f 72 6d 61 74 74 65 64 20 61 73 20 30 33 3a 34 |ormatted as 03:4|
00002c20 35 3a 30 39 2e 20 54 68 65 20 63 6f 6c 6f 6e 20 |5:09. The colon |
00002c30 73 65 70 61 72 61 74 6f 72 20 6d 61 79 20 62 65 |separator may be|
00002c40 0a 63 68 61 6e 67 65 64 20 62 79 20 65 64 69 74 |.changed by edit|
00002c50 69 6e 67 20 74 68 65 20 27 43 6f 6e 66 69 67 27 |ing the 'Config'|
00002c60 20 66 69 6c 65 2e 20 41 72 69 74 68 6d 65 74 69 | file. Arithmeti|
00002c70 63 20 6d 61 79 20 62 65 20 70 65 72 66 6f 72 6d |c may be perform|
00002c80 65 64 20 6f 6e 20 74 69 6d 65 73 0a 68 65 6c 64 |ed on times.held|
00002c90 20 69 6e 20 74 68 69 73 20 74 79 70 65 20 6f 66 | in this type of|
00002ca0 20 66 69 65 6c 64 20 28 73 65 65 20 27 43 61 6c | field (see 'Cal|
00002cb0 63 75 6c 61 74 65 27 29 2e 20 0a 0a 4f 74 68 65 |culate'). ..Othe|
00002cc0 72 20 66 69 65 6c 64 20 63 61 74 65 67 6f 72 69 |r field categori|
00002cd0 65 73 0a 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |es.-------------|
00002ce0 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a 4f 6e 6c 79 20 74 |---------.Only t|
00002cf0 68 65 20 27 44 61 74 61 27 20 63 61 74 65 67 6f |he 'Data' catego|
00002d00 72 79 20 6f 66 20 66 69 65 6c 64 20 68 61 73 20 |ry of field has |
00002d10 62 65 65 6e 20 64 69 73 63 75 73 73 65 64 20 73 |been discussed s|
00002d20 6f 20 66 61 72 2e 20 54 68 65 20 6f 74 68 65 72 |o far. The other|
00002d30 20 74 68 72 65 65 0a 77 69 6c 6c 20 6e 6f 77 20 | three.will now |
00002d40 62 65 20 64 65 61 6c 74 20 77 69 74 68 2e 0a 0a |be dealt with...|
00002d50 45 78 74 65 72 6e 61 6c 20 66 69 65 6c 64 73 0a |External fields.|
00002d60 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a |---------------.|
00002d70 45 78 74 65 72 6e 61 6c 20 66 69 65 6c 64 73 20 |External fields |
00002d80 61 6c 6c 6f 77 20 79 6f 75 20 74 6f 20 6c 69 6e |allow you to lin|
00002d90 6b 20 61 20 50 6f 77 65 72 62 61 73 65 20 72 65 |k a Powerbase re|
00002da0 63 6f 72 64 20 74 6f 20 70 69 65 63 65 73 20 6f |cord to pieces o|
00002db0 66 20 64 61 74 61 20 6f 66 20 61 0a 73 69 7a 65 |f data of a.size|
00002dc0 20 61 6e 64 20 74 79 70 65 20 77 68 69 63 68 20 | and type which |
00002dd0 6d 61 6b 65 20 74 68 65 6d 20 75 6e 73 75 69 74 |make them unsuit|
00002de0 61 62 6c 65 20 66 6f 72 20 69 6e 63 6c 75 73 69 |able for inclusi|
00002df0 6f 6e 20 69 6e 20 61 20 27 44 61 74 61 27 20 66 |on in a 'Data' f|
00002e00 69 65 6c 64 2e 0a 53 75 63 68 20 69 74 65 6d 73 |ield..Such items|
00002e10 20 61 72 65 20 73 6f 6d 65 74 69 6d 65 73 20 63 | are sometimes c|
00002e20 61 6c 6c 65 64 20 22 42 4c 4f 42 73 22 20 28 42 |alled "BLOBs" (B|
00002e30 69 6e 61 72 79 20 4c 61 72 67 65 20 4f 62 6a 65 |inary Large Obje|
00002e40 63 74 73 29 20 69 6e 20 74 68 65 20 50 43 0a 77 |cts) in the PC.w|
00002e50 6f 72 6c 64 2e 20 54 68 65 20 66 69 65 6c 64 20 |orld. The field |
00002e60 74 79 70 65 73 20 69 6e 20 74 68 69 73 20 63 61 |types in this ca|
00002e70 74 65 67 6f 72 79 20 61 6e 64 20 74 68 65 20 74 |tegory and the t|
00002e80 79 70 65 73 20 6f 66 20 64 61 74 61 20 74 68 65 |ypes of data the|
00002e90 79 20 22 68 6f 6c 64 22 0a 61 72 65 20 61 73 20 |y "hold".are as |
00002ea0 66 6f 6c 6c 6f 77 73 3a 2d 0a 0a 20 20 20 20 20 |follows:-.. |
00002eb0 20 20 20 28 61 29 20 54 65 78 74 20 20 20 20 20 | (a) Text |
00002ec0 20 20 20 20 20 20 20 20 20 20 20 50 6c 61 69 6e | Plain|
00002ed0 20 74 65 78 74 20 66 69 6c 65 73 2c 20 73 75 63 | text files, suc|
00002ee0 68 20 61 73 20 45 64 69 74 20 63 72 65 61 74 65 |h as Edit create|
00002ef0 73 2e 0a 20 20 20 20 20 20 20 20 28 62 29 20 53 |s.. (b) S|
00002f00 70 72 69 74 65 20 20 20 20 20 20 20 20 20 20 20 |prite |
00002f10 20 20 20 53 70 72 69 74 65 20 66 69 6c 65 73 2c | Sprite files,|
00002f20 20 73 75 63 68 20 61 73 20 50 61 69 6e 74 20 63 | such as Paint c|
00002f30 72 65 61 74 65 73 2e 0a 20 20 20 20 20 20 20 20 |reates.. |
00002f40 28 63 29 20 44 72 61 77 20 20 20 20 20 20 20 20 |(c) Draw |
00002f50 20 20 20 20 20 20 20 20 44 72 61 77 69 6e 67 73 | Drawings|
00002f60 20 73 75 63 68 20 61 73 20 44 72 61 77 20 63 72 | such as Draw cr|
00002f70 65 61 74 65 73 2e 0a 20 20 20 20 20 20 20 20 28 |eates.. (|
00002f80 64 29 20 54 65 78 74 20 62 6c 6f 63 6b 20 20 20 |d) Text block |
00002f90 20 20 20 20 20 20 20 50 6c 61 69 6e 20 74 65 78 | Plain tex|
00002fa0 74 20 66 69 6c 65 73 2c 20 61 73 20 66 6f 72 20 |t files, as for |
00002fb0 28 61 29 2e 0a 20 20 20 20 20 20 20 20 28 65 29 |(a).. (e)|
00002fc0 20 50 69 63 74 75 72 65 20 20 20 20 20 20 20 20 | Picture |
00002fd0 20 20 20 20 20 53 70 72 69 74 65 20 66 69 6c 65 | Sprite file|
00002fe0 73 2c 20 61 73 20 66 6f 72 20 28 62 29 2e 0a 0a |s, as for (b)...|
00002ff0 57 68 65 6e 20 79 6f 75 20 63 72 65 61 74 65 20 |When you create |
00003000 61 20 66 69 65 6c 64 20 6f 66 20 74 79 70 65 20 |a field of type |
00003010 27 54 65 78 74 27 2c 20 27 53 70 72 69 74 65 27 |'Text', 'Sprite'|
00003020 20 6f 72 20 27 44 72 61 77 27 20 69 74 20 61 70 | or 'Draw' it ap|
00003030 70 65 61 72 73 20 6f 6e 20 74 68 65 0a 72 65 63 |pears on the.rec|
00003040 6f 72 64 20 77 69 6e 64 6f 77 20 61 73 20 61 20 |ord window as a |
00003050 62 75 74 74 6f 6e 20 62 65 61 72 69 6e 67 20 61 |button bearing a|
00003060 20 73 6d 61 6c 6c 20 76 65 72 73 69 6f 6e 20 6f | small version o|
00003070 66 20 74 68 65 20 69 63 6f 6e 20 66 6f 72 20 45 |f the icon for E|
00003080 64 69 74 2c 0a 50 61 69 6e 74 20 6f 72 20 44 72 |dit,.Paint or Dr|
00003090 61 77 20 72 65 73 70 65 63 74 69 76 65 6c 79 2e |aw respectively.|
000030a0 20 46 69 6c 65 73 20 6f 66 20 74 68 65 20 61 70 | Files of the ap|
000030b0 70 72 6f 70 72 69 61 74 65 20 74 79 70 65 20 6d |propriate type m|
000030c0 61 79 20 62 65 20 64 72 6f 70 70 65 64 20 6f 6e |ay be dropped on|
000030d0 0a 74 68 65 73 65 20 62 75 74 74 6f 6e 73 2c 20 |.these buttons, |
000030e0 77 68 65 72 65 75 70 6f 6e 20 74 68 65 20 66 69 |whereupon the fi|
000030f0 6c 65 20 69 73 20 63 6f 70 69 65 64 20 69 6e 74 |le is copied int|
00003100 6f 20 61 20 73 70 65 63 69 61 6c 20 73 79 73 74 |o a special syst|
00003110 65 6d 20 6f 66 0a 73 75 62 64 69 72 65 63 74 6f |em of.subdirecto|
00003120 72 69 65 73 20 77 69 74 68 69 6e 20 74 68 65 20 |ries within the |
00003130 64 61 74 61 62 61 73 65 20 61 70 70 6c 69 63 61 |database applica|
00003140 74 69 6f 6e 2e 20 55 6e 6c 69 6b 65 20 66 69 65 |tion. Unlike fie|
00003150 6c 64 73 20 6f 66 20 74 68 65 20 27 44 61 74 61 |lds of the 'Data|
00003160 27 0a 63 61 74 65 67 6f 72 79 20 74 68 65 20 64 |'.category the d|
00003170 61 74 61 20 64 6f 65 73 6e 27 74 20 62 65 63 6f |ata doesn't beco|
00003180 6d 65 20 70 61 72 74 20 6f 66 20 74 68 65 20 27 |me part of the '|
00003190 44 61 74 61 62 61 73 65 27 20 66 69 6c 65 20 77 |Database' file w|
000031a0 69 74 68 69 6e 20 74 68 65 0a 61 70 70 6c 69 63 |ithin the.applic|
000031b0 61 74 69 6f 6e 3b 20 74 68 65 20 74 65 78 74 2c |ation; the text,|
000031c0 20 73 70 72 69 74 65 20 6f 72 20 64 72 61 77 66 | sprite or drawf|
000031d0 69 6c 65 20 72 65 74 61 69 6e 73 20 69 74 73 20 |ile retains its |
000031e0 69 64 65 6e 74 69 74 79 20 61 6e 64 20 6d 61 79 |identity and may|
000031f0 20 62 65 0a 65 78 70 6f 72 74 65 64 20 66 6f 72 | be.exported for|
00003200 20 65 64 69 74 69 6e 67 20 69 6e 20 74 68 65 20 | editing in the |
00003210 61 70 70 72 6f 70 72 69 61 74 65 20 61 70 70 6c |appropriate appl|
00003220 69 63 61 74 69 6f 6e 2e 20 43 6c 69 63 6b 69 6e |ication. Clickin|
00003230 67 20 6f 6e 20 74 68 65 20 62 75 74 74 6f 6e 0a |g on the button.|
00003240 69 6e 20 74 68 65 20 72 65 63 6f 72 64 20 77 69 |in the record wi|
00003250 6e 64 6f 77 20 77 69 6c 6c 20 64 69 73 70 6c 61 |ndow will displa|
00003260 79 20 74 68 65 20 66 69 6c 65 20 69 66 20 74 68 |y the file if th|
00003270 65 20 66 69 6c 65 72 20 6b 6e 6f 77 73 20 74 68 |e filer knows th|
00003280 65 0a 77 68 65 72 65 61 62 6f 75 74 73 20 6f 66 |e.whereabouts of|
00003290 20 74 68 65 20 72 65 6c 65 76 61 6e 74 20 65 64 | the relevant ed|
000032a0 69 74 6f 72 20 28 45 64 69 74 2c 20 50 61 69 6e |itor (Edit, Pain|
000032b0 74 20 6f 72 20 44 72 61 77 29 2e 0a 0a 27 54 65 |t or Draw)...'Te|
000032c0 78 74 20 62 6c 6f 63 6b 27 20 61 6e 64 20 27 50 |xt block' and 'P|
000032d0 69 63 74 75 72 65 27 20 66 69 65 6c 64 73 20 74 |icture' fields t|
000032e0 61 6b 65 20 74 68 69 73 20 61 20 73 74 65 70 20 |ake this a step |
000032f0 66 75 72 74 68 65 72 20 62 79 20 61 63 74 75 61 |further by actua|
00003300 6c 6c 79 0a 64 69 73 70 6c 61 79 69 6e 67 20 61 |lly.displaying a|
00003310 20 74 65 78 74 20 6f 72 20 73 70 72 69 74 65 20 | text or sprite |
00003320 66 69 6c 65 20 6f 6e 20 74 68 65 20 72 65 63 6f |file on the reco|
00003330 72 64 20 77 69 6e 64 6f 77 2e 20 54 68 65 20 62 |rd window. The b|
00003340 6f 75 6e 64 69 6e 67 20 62 6f 78 20 6f 66 0a 74 |ounding box of.t|
00003350 68 65 20 69 63 6f 6e 20 6e 65 65 64 73 20 74 6f |he icon needs to|
00003360 20 62 65 20 6f 66 20 73 75 69 74 61 62 6c 65 20 | be of suitable |
00003370 73 69 7a 65 20 74 6f 20 68 6f 6c 64 20 74 68 65 |size to hold the|
00003380 20 74 65 78 74 20 6f 72 20 70 69 63 74 75 72 65 | text or picture|
00003390 2e 20 49 6e 20 74 68 65 0a 63 61 73 65 20 6f 66 |. In the.case of|
000033a0 20 61 20 27 54 65 78 74 20 62 6c 6f 63 6b 27 20 | a 'Text block' |
000033b0 74 6f 6f 20 73 6d 61 6c 6c 20 61 20 62 6f 78 20 |too small a box |
000033c0 77 69 6c 6c 20 63 61 75 73 65 20 74 68 65 20 74 |will cause the t|
000033d0 65 78 74 20 74 6f 20 61 70 70 65 61 72 0a 74 72 |ext to appear.tr|
000033e0 75 6e 63 61 74 65 64 2e 20 4e 6f 6e 65 20 69 73 |uncated. None is|
000033f0 20 61 63 74 75 61 6c 6c 79 20 6c 6f 73 74 3b 20 | actually lost; |
00003400 69 74 20 6a 75 73 74 20 63 61 6e 27 74 20 61 6c |it just can't al|
00003410 6c 20 62 65 20 64 69 73 70 6c 61 79 65 64 2e 20 |l be displayed. |
00003420 54 6f 6f 20 73 6d 61 6c 6c 0a 61 20 62 6f 78 20 |Too small.a box |
00003430 66 6f 72 20 61 20 27 50 69 63 74 75 72 65 27 20 |for a 'Picture' |
00003440 66 69 65 6c 64 20 77 69 6c 6c 20 63 61 75 73 65 |field will cause|
00003450 20 74 68 65 20 73 70 72 69 74 65 20 74 6f 20 73 | the sprite to s|
00003460 70 72 65 61 64 20 62 65 79 6f 6e 64 20 69 74 73 |pread beyond its|
00003470 0a 62 6f 75 6e 64 61 72 69 65 73 2e 20 28 4e 2e |.boundaries. (N.|
00003480 42 2e 20 54 6f 20 64 69 73 70 6c 61 79 20 74 68 |B. To display th|
00003490 65 20 73 61 6d 65 20 73 70 72 69 74 65 20 6f 6e |e same sprite on|
000034a0 20 65 61 63 68 20 72 65 63 6f 72 64 2c 20 65 2e | each record, e.|
000034b0 67 2e 20 61 20 63 6f 6d 70 61 6e 79 0a 6c 6f 67 |g. a company.log|
000034c0 6f 2c 20 64 65 66 69 6e 65 20 74 68 65 20 66 69 |o, define the fi|
000034d0 65 6c 64 20 61 73 20 6f 66 20 74 79 70 65 20 27 |eld as of type '|
000034e0 4c 6f 67 6f 27 2c 20 6e 6f 74 20 27 50 69 63 74 |Logo', not 'Pict|
000034f0 75 72 65 27 2e 20 54 68 65 20 69 6e 63 6c 75 73 |ure'. The inclus|
00003500 69 6f 6e 20 6f 66 0a 6c 6f 67 6f 73 20 69 73 20 |ion of.logos is |
00003510 64 65 73 63 72 69 62 65 64 20 69 6e 20 74 68 65 |described in the|
00003520 20 66 69 6c 65 20 27 43 61 6c 63 75 6c 61 74 65 | file 'Calculate|
00003530 27 20 77 68 63 69 68 20 6d 61 79 20 73 65 65 6d |' whcih may seem|
00003540 20 61 6e 20 6f 64 64 20 70 6c 61 63 65 20 66 6f | an odd place fo|
00003550 72 0a 69 74 20 62 75 74 20 74 68 65 72 65 20 69 |r.it but there i|
00003560 73 20 61 20 72 65 61 73 6f 6e 21 29 0a 0a 43 68 |s a reason!)..Ch|
00003570 65 63 6b 2d 62 6f 78 20 66 69 65 6c 64 73 0a 2d |eck-box fields.-|
00003580 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a |---------------.|
00003590 54 68 65 73 65 20 61 72 65 20 66 69 65 6c 64 73 |These are fields|
000035a0 20 77 68 6f 73 65 20 73 74 61 74 75 73 20 61 6c | whose status al|
000035b0 74 65 72 6e 61 74 65 73 20 62 65 74 77 65 65 6e |ternates between|
000035c0 20 74 77 6f 20 76 61 6c 75 65 73 20 77 68 65 6e | two values when|
000035d0 20 63 6c 69 63 6b 65 64 0a 6f 76 65 72 20 77 69 | clicked.over wi|
000035e0 74 68 20 53 45 4c 45 43 54 2e 20 54 68 72 65 65 |th SELECT. Three|
000035f0 20 74 79 70 65 73 20 61 72 65 20 64 65 66 69 6e | types are defin|
00003600 65 64 3a 2d 0a 0a 20 20 20 20 20 20 20 20 28 61 |ed:-.. (a|
00003610 29 20 43 72 6f 73 73 2f 74 69 63 6b 20 20 44 69 |) Cross/tick Di|
00003620 73 70 6c 61 79 73 20 61 20 63 72 6f 73 73 20 62 |splays a cross b|
00003630 79 20 64 65 66 61 75 6c 74 2e 20 41 20 63 6c 69 |y default. A cli|
00003640 63 6b 20 63 68 61 6e 67 65 73 20 69 74 20 74 6f |ck changes it to|
00003650 20 61 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 | a. |
00003660 20 20 20 20 20 20 20 20 20 20 20 74 69 63 6b 2e | tick.|
00003670 20 41 20 73 65 63 6f 6e 64 20 63 6c 69 63 6b 20 | A second click |
00003680 63 68 61 6e 67 65 73 20 69 74 20 62 61 63 6b 20 |changes it back |
00003690 74 6f 20 61 20 63 72 6f 73 73 2e 0a 20 20 20 20 |to a cross.. |
000036a0 20 20 20 20 28 62 29 20 4e 75 6c 6c 2f 74 69 63 | (b) Null/tic|
000036b0 6b 20 20 20 53 69 6d 69 6c 61 72 20 74 6f 20 28 |k Similar to (|
000036c0 61 29 2c 20 62 75 74 20 66 69 72 73 74 20 73 74 |a), but first st|
000036d0 61 74 65 20 69 73 20 61 6e 20 65 6d 70 74 79 20 |ate is an empty |
000036e0 62 6f 78 2e 0a 20 20 20 20 20 20 20 20 28 63 29 |box.. (c)|
000036f0 20 4e 75 6c 6c 2f 73 74 61 72 20 20 20 53 69 6d | Null/star Sim|
00003700 69 6c 61 72 20 74 6f 20 28 62 29 2c 20 62 75 74 |ilar to (b), but|
00003710 20 73 65 63 6f 6e 64 20 73 74 61 74 65 20 69 73 | second state is|
00003720 20 61 20 73 74 61 72 2e 0a 0a 43 68 65 63 6b 2d | a star...Check-|
00003730 62 6f 78 65 73 20 70 72 6f 76 69 64 65 20 74 68 |boxes provide th|
00003740 65 20 66 61 73 74 65 73 74 20 77 61 79 20 6f 66 |e fastest way of|
00003750 20 65 6e 74 65 72 69 6e 67 20 74 72 75 65 2f 66 | entering true/f|
00003760 61 6c 73 65 20 6f 72 20 79 65 73 2f 6e 6f 20 74 |alse or yes/no t|
00003770 79 70 65 0a 64 61 74 61 2e 20 49 66 20 79 6f 75 |ype.data. If you|
00003780 20 65 78 61 6d 69 6e 65 20 74 68 65 20 27 56 61 | examine the 'Va|
00003790 6c 53 74 72 69 6e 67 73 27 20 66 69 6c 65 20 69 |lStrings' file i|
000037a0 6e 73 69 64 65 20 74 68 65 20 50 6f 77 65 72 62 |nside the Powerb|
000037b0 61 73 65 20 64 69 72 65 63 74 6f 72 79 0a 79 6f |ase directory.yo|
000037c0 75 20 77 69 6c 6c 20 66 69 6e 64 20 73 74 72 69 |u will find stri|
000037d0 6e 67 73 20 61 73 73 6f 63 69 61 74 65 64 20 77 |ngs associated w|
000037e0 69 74 68 20 65 61 63 68 20 6f 66 20 74 68 65 73 |ith each of thes|
000037f0 65 20 74 68 72 65 65 20 74 79 70 65 73 20 74 68 |e three types th|
00003800 65 20 6c 61 74 74 65 72 0a 70 61 72 74 73 20 6f |e latter.parts o|
00003810 66 20 77 68 69 63 68 20 72 65 61 64 2c 20 72 65 |f which read, re|
00003820 73 70 65 63 74 69 76 65 6c 79 3a 2d 0a 0a 20 20 |spectively:-.. |
00003830 20 20 20 20 20 20 20 20 20 20 20 20 20 20 51 4e | QN|
00003840 6f 2c 59 65 73 0a 20 20 20 20 20 20 20 20 20 20 |o,Yes. |
00003850 20 20 20 20 20 20 51 20 2c 59 65 73 0a 20 20 20 | Q ,Yes. |
00003860 20 20 20 20 20 20 20 20 20 20 20 20 20 51 20 2c | Q ,|
00003870 2a 0a 0a 54 68 65 73 65 20 73 70 65 63 69 66 79 |*..These specify|
00003880 20 77 68 61 74 20 77 69 6c 6c 20 61 63 74 75 61 | what will actua|
00003890 6c 6c 79 20 61 70 70 65 61 72 20 69 6e 20 61 20 |lly appear in a |
000038a0 70 72 69 6e 74 2d 6f 75 74 20 77 68 65 6e 20 61 |print-out when a|
000038b0 20 63 68 65 63 6b 2d 62 6f 78 0a 66 69 65 6c 64 | check-box.field|
000038c0 20 69 73 20 69 6e 63 6c 75 64 65 64 20 69 6e 20 | is included in |
000038d0 61 20 71 75 65 72 79 2e 20 59 6f 75 20 6d 61 79 |a query. You may|
000038e0 20 63 68 61 6e 67 65 20 74 68 65 6d 20 69 66 20 | change them if |
000038f0 79 6f 75 20 77 69 73 68 2c 20 62 75 74 20 64 6f |you wish, but do|
00003900 6e 27 74 0a 6f 6d 69 74 20 74 68 65 20 69 6e 69 |n't.omit the ini|
00003910 74 69 61 6c 20 51 20 61 6e 64 20 74 61 6b 65 20 |tial Q and take |
00003920 63 61 72 65 20 6e 6f 74 20 74 6f 20 61 6c 74 65 |care not to alte|
00003930 72 20 74 68 65 20 72 65 6d 61 69 64 65 72 20 6f |r the remaider o|
00003940 66 20 74 68 65 20 73 74 72 69 6e 67 2e 0a 0a 53 |f the string...S|
00003950 74 61 6d 70 20 66 69 65 6c 64 73 0a 2d 2d 2d 2d |tamp fields.----|
00003960 2d 2d 2d 2d 2d 2d 2d 2d 0a 54 68 65 73 65 20 61 |--------.These a|
00003970 72 65 20 6f 66 20 74 68 65 20 66 6f 6c 6c 6f 77 |re of the follow|
00003980 69 6e 67 20 74 79 70 65 73 3a 0a 0a 20 20 20 20 |ing types:.. |
00003990 20 20 20 20 28 61 29 20 52 65 63 6f 72 64 20 6e | (a) Record n|
000039a0 75 6d 62 65 72 20 20 20 20 20 20 20 44 61 74 61 |umber Data|
000039b0 62 61 73 65 20 72 65 63 6f 72 64 20 6e 75 6d 62 |base record numb|
000039c0 65 72 2e 0a 20 20 20 20 20 20 20 20 28 62 29 20 |er.. (b) |
000039d0 53 65 71 75 65 6e 63 65 20 6e 75 6d 62 65 72 20 |Sequence number |
000039e0 20 20 20 20 41 20 75 6e 69 71 75 65 20 76 61 6c | A unique val|
000039f0 75 65 20 77 68 69 63 68 20 69 73 20 6e 75 6d 62 |ue which is numb|
00003a00 65 72 65 64 20 75 70 77 61 72 64 73 20 0a 20 20 |ered upwards . |
00003a10 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
00003a20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 66 72 | fr|
00003a30 6f 6d 20 61 20 62 61 73 65 20 76 61 6c 75 65 20 |om a base value |
00003a40 73 65 74 20 62 79 20 74 68 65 20 75 73 65 72 2e |set by the user.|
00003a50 0a 20 20 20 20 20 20 20 20 28 63 29 20 54 69 6d |. (c) Tim|
00003a60 65 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 |e |
00003a70 20 54 69 6d 65 20 61 74 20 77 68 69 63 68 20 72 | Time at which r|
00003a80 65 63 6f 72 64 20 77 61 73 20 63 72 65 61 74 65 |ecord was create|
00003a90 64 2e 0a 20 20 20 20 20 20 20 20 28 64 29 20 44 |d.. (d) D|
00003aa0 61 74 65 20 20 20 20 20 20 20 20 20 20 20 20 20 |ate |
00003ab0 20 20 20 44 61 74 65 20 6f 6e 20 77 68 69 63 68 | Date on which|
00003ac0 20 72 65 63 6f 72 64 20 77 61 73 20 63 72 65 61 | record was crea|
00003ad0 74 65 64 2e 0a 20 20 20 20 20 20 20 20 28 65 29 |ted.. (e)|
00003ae0 20 44 61 74 65 20 61 6e 64 20 74 69 6d 65 20 20 | Date and time |
00003af0 20 20 20 20 20 44 61 74 65 20 61 6e 64 20 74 69 | Date and ti|
00003b00 6d 65 20 6f 66 20 72 65 63 6f 72 64 20 63 72 65 |me of record cre|
00003b10 61 74 69 6f 6e 2e 0a 20 20 20 20 20 20 20 20 28 |ation.. (|
00003b20 66 29 20 44 61 79 20 20 20 20 20 20 20 20 20 20 |f) Day |
00003b30 20 20 20 20 20 20 20 44 61 79 20 6f 6e 20 77 68 | Day on wh|
00003b40 69 63 68 20 72 65 63 6f 72 64 20 77 61 73 20 63 |ich record was c|
00003b50 72 65 61 74 65 64 20 28 69 6e 20 74 68 65 20 66 |reated (in the f|
00003b60 6f 72 6d 0a 20 20 20 20 20 20 20 20 20 20 20 20 |orm. |
00003b70 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
00003b80 20 20 20 20 4d 6f 6e 2c 54 75 65 20 65 74 63 20 | Mon,Tue etc |
00003b90 6f 72 20 64 61 79 20 6f 66 20 6d 6f 6e 74 68 20 |or day of month |
00003ba0 61 73 20 31 30 2c 32 34 20 65 74 63 29 2e 0a 20 |as 10,24 etc).. |
00003bb0 20 20 20 20 20 20 20 28 67 29 20 4d 6f 6e 74 68 | (g) Month|
00003bc0 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 4d | M|
00003bd0 6f 6e 74 68 20 69 6e 20 77 68 69 63 68 20 72 65 |onth in which re|
00003be0 63 6f 72 64 20 77 61 73 20 63 72 65 61 74 65 64 |cord was created|
00003bf0 20 28 61 73 20 65 69 74 68 65 72 0a 20 20 20 20 | (as either. |
00003c00 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
00003c10 20 20 20 20 20 20 20 20 20 20 20 20 61 20 73 74 | a st|
00003c20 72 69 6e 67 3b 20 4a 61 6e 2c 46 65 62 20 65 74 |ring; Jan,Feb et|
00003c30 63 20 6f 72 20 61 20 6e 75 6d 62 65 72 3b 20 31 |c or a number; 1|
00003c40 2c 32 20 65 74 63 29 2e 0a 20 20 20 20 20 20 20 |,2 etc).. |
00003c50 20 28 68 29 20 59 65 61 72 20 20 20 20 20 20 20 | (h) Year |
00003c60 20 20 20 20 20 20 20 20 20 59 65 61 72 20 69 6e | Year in|
00003c70 20 77 68 69 63 68 20 72 65 63 6f 72 64 20 77 61 | which record wa|
00003c80 73 20 63 72 65 61 74 65 64 20 28 61 73 20 61 20 |s created (as a |
00003c90 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 |. |
00003ca0 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
00003cb0 20 66 6f 75 72 2d 64 69 67 69 74 20 6e 75 6d 62 | four-digit numb|
00003cc0 65 72 2c 20 65 2e 67 2e 20 31 39 39 33 29 2e 0a |er, e.g. 1993)..|
00003cd0 0a 4c 69 6b 65 20 27 43 61 6c 63 75 6c 61 74 65 |.Like 'Calculate|
00003ce0 64 27 20 61 6e 64 20 27 43 6f 6d 70 6f 73 69 74 |d' and 'Composit|
00003cf0 65 27 20 66 69 65 6c 64 73 20 6e 6f 6e 65 20 6f |e' fields none o|
00003d00 66 20 74 68 65 20 61 62 6f 76 65 20 69 73 20 65 |f the above is e|
00003d10 64 69 74 61 62 6c 65 20 62 79 0a 74 68 65 20 75 |ditable by.the u|
00003d20 73 65 72 3b 20 61 6c 6c 20 61 72 65 20 61 75 74 |ser; all are aut|
00003d30 6f 6d 61 74 69 63 61 6c 6c 79 20 22 73 74 61 6d |omatically "stam|
00003d40 70 65 64 22 20 62 79 20 50 6f 77 65 72 62 61 73 |ped" by Powerbas|
00003d50 65 20 61 74 20 74 68 65 20 74 69 6d 65 20 61 20 |e at the time a |
00003d60 72 65 63 6f 72 64 0a 69 73 20 66 69 72 73 74 20 |record.is first |
00003d70 65 6e 74 65 72 65 64 2e 20 57 68 65 6e 20 75 73 |entered. When us|
00003d80 69 6e 67 20 28 61 29 20 6f 72 20 28 62 29 20 6d |ing (a) or (b) m|
00003d90 61 6b 65 20 73 75 72 65 20 74 68 65 20 27 44 61 |ake sure the 'Da|
00003da0 74 61 20 6c 65 6e 67 74 68 27 20 66 69 6c 6c 2d |ta length' fill-|
00003db0 69 6e 0a 62 6f 78 20 63 6f 6e 74 61 69 6e 73 20 |in.box contains |
00003dc0 61 20 6c 61 72 67 65 20 65 6e 6f 75 67 68 20 76 |a large enough v|
00003dd0 61 6c 75 65 20 74 6f 20 61 63 63 6f 6d 6d 6f 64 |alue to accommod|
00003de0 61 74 65 20 74 68 65 20 6c 6f 6e 67 65 73 74 20 |ate the longest |
00003df0 6e 75 6d 62 65 72 20 77 68 69 63 68 0a 77 69 6c |number which.wil|
00003e00 6c 20 62 65 20 65 6e 63 6f 75 6e 74 65 72 65 64 |l be encountered|
00003e10 2e 20 49 6e 20 74 68 65 20 63 61 73 65 20 6f 66 |. In the case of|
00003e20 20 28 62 29 20 74 68 65 20 62 61 73 65 20 76 61 | (b) the base va|
00003e30 6c 75 65 20 66 72 6f 6d 20 77 68 69 63 68 20 74 |lue from which t|
00003e40 68 65 0a 73 65 71 75 65 6e 63 65 20 6e 75 6d 62 |he.sequence numb|
00003e50 65 72 73 20 62 65 67 69 6e 20 69 73 20 65 6e 74 |ers begin is ent|
00003e60 65 72 65 64 20 69 6e 20 74 68 65 20 27 4e 75 6d |ered in the 'Num|
00003e70 65 72 69 63 20 6d 69 6e 27 20 62 6f 78 2e 20 46 |eric min' box. F|
00003e80 6f 72 20 74 68 65 20 6f 74 68 65 72 0a 74 79 70 |or the other.typ|
00003e90 65 73 20 74 68 65 20 72 65 71 75 69 72 65 64 20 |es the required |
00003ea0 66 69 65 6c 64 20 6c 65 6e 67 74 68 20 69 73 20 |field length is |
00003eb0 61 6c 72 65 61 64 79 20 6b 6e 6f 77 6e 20 62 79 |already known by|
00003ec0 20 50 6f 77 65 72 62 61 73 65 20 61 6e 64 20 74 | Powerbase and t|
00003ed0 68 65 0a 27 44 61 74 61 20 6c 65 6e 67 74 68 27 |he.'Data length'|
00003ee0 20 62 6f 78 20 69 73 20 74 68 65 72 65 66 6f 72 | box is therefor|
00003ef0 65 20 73 68 61 64 65 64 2e 0a 0a 54 79 70 65 20 |e shaded...Type |
00003f00 28 64 29 20 66 69 65 6c 64 73 20 6d 61 79 20 64 |(d) fields may d|
00003f10 69 73 70 6c 61 79 20 74 68 65 20 64 61 74 65 20 |isplay the date |
00003f20 69 6e 20 61 6e 79 20 6f 66 20 74 68 72 65 65 20 |in any of three |
00003f30 66 6f 72 6d 61 74 73 3a 0a 0a 20 20 20 20 20 20 |formats:.. |
00003f40 20 20 28 69 29 20 20 20 20 20 53 75 6e 2c 30 31 | (i) Sun,01|
00003f50 20 41 75 67 20 31 39 39 33 20 20 20 20 20 20 20 | Aug 1993 |
00003f60 20 20 28 63 61 6c 6c 65 64 20 22 44 61 74 65 20 | (called "Date |
00003f70 73 74 61 6d 70 22 29 0a 20 20 20 20 20 20 20 20 |stamp"). |
00003f80 28 69 69 29 20 20 20 20 30 31 2d 30 38 2d 39 33 |(ii) 01-08-93|
00003f90 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
00003fa0 28 63 61 6c 6c 65 64 20 22 44 61 74 65 20 73 74 |(called "Date st|
00003fb0 61 6d 70 38 22 29 0a 20 20 20 20 20 20 20 20 28 |amp8"). (|
00003fc0 69 69 69 29 20 20 20 30 31 2d 30 38 2d 31 39 39 |iii) 01-08-199|
00003fd0 33 20 20 20 20 20 20 20 20 20 20 20 20 20 20 28 |3 (|
00003fe0 63 61 6c 6c 65 64 20 22 44 61 74 65 20 73 74 61 |called "Date sta|
00003ff0 6d 70 31 30 22 29 0a 0a 28 69 69 29 20 61 6e 64 |mp10")..(ii) and|
00004000 20 28 69 69 69 29 20 61 72 65 20 69 64 65 6e 74 | (iii) are ident|
00004010 69 63 61 6c 20 74 6f 20 74 68 65 20 66 6f 72 6d |ical to the form|
00004020 61 74 73 20 69 6e 20 77 68 69 63 68 20 50 6f 77 |ats in which Pow|
00004030 65 72 62 61 73 65 20 64 69 73 70 6c 61 79 73 0a |erbase displays.|
00004040 64 61 74 65 73 20 6f 66 20 74 68 65 20 6f 72 64 |dates of the ord|
00004050 69 6e 61 72 79 20 65 64 69 74 61 62 6c 65 2d 64 |inary editable-d|
00004060 61 74 61 20 74 79 70 65 20 28 73 65 65 20 22 4f |ata type (see "O|
00004070 74 68 65 72 20 74 79 70 65 73 20 6f 66 20 64 61 |ther types of da|
00004080 74 61 20 66 69 65 6c 64 22 2c 0a 61 62 6f 76 65 |ta field",.above|
00004090 29 2e 20 54 68 65 20 6e 75 6d 62 65 72 73 20 72 |). The numbers r|
000040a0 65 66 65 72 20 74 6f 20 74 68 65 20 66 69 65 6c |efer to the fiel|
000040b0 64 20 6c 65 6e 67 74 68 20 6f 63 63 75 70 69 65 |d length occupie|
000040c0 64 20 62 79 20 74 68 65 20 64 61 74 65 20 73 74 |d by the date st|
000040d0 61 6d 70 2e 0a 0a 42 75 74 74 6f 6e 20 66 69 65 |amp...Button fie|
000040e0 6c 64 73 0a 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |lds.------------|
000040f0 2d 0a 41 6e 79 20 6f 72 20 61 6c 6c 20 6f 66 20 |-.Any or all of |
00004100 74 68 65 20 63 6f 6e 74 72 6f 6c 20 62 75 74 74 |the control butt|
00004110 6f 6e 73 20 6f 6e 20 74 68 65 20 50 6f 77 65 72 |ons on the Power|
00004120 62 61 73 65 20 6b 65 79 70 61 64 20 6d 61 79 20 |base keypad may |
00004130 62 65 20 6d 61 64 65 20 74 6f 0a 61 70 70 65 61 |be made to.appea|
00004140 72 20 6f 6e 20 74 68 65 20 72 65 63 6f 72 64 20 |r on the record |
00004150 77 69 6e 64 6f 77 20 69 74 73 65 6c 66 2e 20 54 |window itself. T|
00004160 68 65 79 20 68 61 76 65 20 65 78 61 63 74 6c 79 |hey have exactly|
00004170 20 74 68 65 20 73 61 6d 65 20 66 75 6e 63 74 69 | the same functi|
00004180 6f 6e 73 20 61 73 0a 74 68 65 69 72 20 6b 65 79 |ons as.their key|
00004190 70 61 64 20 65 71 75 69 76 61 6c 65 6e 74 73 2e |pad equivalents.|
000041a0 20 54 68 65 72 65 20 61 72 65 20 61 6c 73 6f 20 | There are also |
000041b0 61 20 66 65 77 20 65 78 74 72 61 73 20 28 50 72 |a few extras (Pr|
000041c0 69 6e 74 2c 20 45 78 69 74 2c 20 51 75 69 74 20 |int, Exit, Quit |
000041d0 61 6e 64 0a 44 69 72 65 63 74 6f 72 79 29 20 77 |and.Directory) w|
000041e0 68 69 63 68 20 68 61 76 65 20 6e 6f 20 6b 65 79 |hich have no key|
000041f0 70 61 64 20 65 71 75 69 76 61 6c 65 6e 74 2e 20 |pad equivalent. |
00004200 54 68 65 20 66 69 72 73 74 20 74 68 72 65 65 20 |The first three |
00004210 64 75 70 6c 69 63 61 74 65 20 74 68 65 0a 61 63 |duplicate the.ac|
00004220 74 69 6f 6e 73 20 6f 66 20 27 50 72 69 6e 74 27 |tions of 'Print'|
00004230 20 6f 6e 20 74 68 65 20 6d 61 69 6e 20 6d 65 6e | on the main men|
00004240 75 20 61 6e 64 20 27 43 6c 6f 73 65 20 64 61 74 |u and 'Close dat|
00004250 61 62 61 73 65 27 20 61 6e 64 20 27 51 75 69 74 |abase' and 'Quit|
00004260 27 20 6f 6e 20 74 68 65 0a 69 63 6f 6e 20 62 61 |' on the.icon ba|
00004270 72 20 6d 65 6e 75 2e 20 27 44 69 72 65 63 74 6f |r menu. 'Directo|
00004280 72 79 27 20 65 6e 61 62 6c 65 73 20 79 6f 75 20 |ry' enables you |
00004290 74 6f 20 6f 70 65 6e 20 61 20 66 69 6c 65 72 20 |to open a filer |
000042a0 77 69 6e 64 6f 77 20 62 79 0a 63 6c 69 63 6b 69 |window by.clicki|
000042b0 6e 67 20 6f 6e 20 74 68 65 20 62 75 74 74 6f 6e |ng on the button|
000042c0 2e 20 54 68 65 20 64 65 73 63 72 69 70 74 6f 72 |. The descriptor|
000042d0 20 6d 61 79 20 62 65 20 75 73 65 64 20 74 6f 20 | may be used to |
000042e0 67 69 76 65 20 74 68 65 20 6e 61 6d 65 20 6f 66 |give the name of|
000042f0 0a 74 68 65 20 61 73 73 6f 63 69 61 74 65 64 20 |.the associated |
00004300 64 69 72 65 63 74 6f 72 79 20 61 6e 64 20 74 68 |directory and th|
00004310 65 20 6c 69 6e 6b 20 69 73 20 65 73 74 61 62 6c |e link is establ|
00004320 69 73 68 65 64 20 62 79 20 64 72 6f 70 70 69 6e |ished by droppin|
00004330 67 20 74 68 65 0a 64 69 72 65 63 74 6f 72 79 20 |g the.directory |
00004340 6f 6e 74 6f 20 74 68 65 20 62 75 74 74 6f 6e 20 |onto the button |
00004350 69 6e 20 74 68 65 20 73 61 6d 65 20 77 61 79 20 |in the same way |
00004360 74 68 61 74 20 66 69 6c 65 73 20 61 72 65 20 6c |that files are l|
00004370 69 6e 6b 65 64 20 74 6f 0a 66 69 65 6c 64 73 20 |inked to.fields |
00004380 6f 66 20 27 45 78 74 65 72 6e 61 6c 27 20 74 79 |of 'External' ty|
00004390 70 65 2e 20 54 68 65 73 65 20 62 75 74 74 6f 6e |pe. These button|
000043a0 20 66 69 65 6c 64 73 20 61 6c 6c 6f 77 20 79 6f | fields allow yo|
000043b0 75 20 74 6f 20 62 75 69 6c 64 20 61 0a 63 75 73 |u to build a.cus|
000043c0 74 6f 6d 69 73 65 64 20 64 61 74 61 62 61 73 65 |tomised database|
000043d0 20 77 68 69 63 68 20 6c 65 74 73 20 74 68 65 20 | which lets the |
000043e0 75 73 65 72 20 75 73 65 20 6f 6e 6c 79 20 74 68 |user use only th|
000043f0 65 20 66 65 61 74 75 72 65 73 20 79 6f 75 20 77 |e features you w|
00004400 61 6e 74 0a 68 69 6d 2f 68 65 72 20 74 6f 20 68 |ant.him/her to h|
00004410 61 76 65 20 61 63 63 65 73 73 20 74 6f 2c 20 73 |ave access to, s|
00004420 69 6e 63 65 20 74 68 65 20 6b 65 79 70 61 64 20 |ince the keypad |
00004430 61 6e 64 20 6d 65 6e 75 73 20 63 61 6e 20 74 68 |and menus can th|
00004440 65 6e 20 62 65 0a 73 75 70 70 72 65 73 73 65 64 |en be.suppressed|
00004450 2e 0a 0a 53 70 65 63 69 66 79 69 6e 67 20 74 68 |...Specifying th|
00004460 65 20 64 61 74 61 62 61 73 65 20 73 69 7a 65 0a |e database size.|
00004470 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |================|
00004480 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 49 6d 6d |============.Imm|
00004490 65 64 69 61 74 65 6c 79 20 62 65 6e 65 61 74 68 |ediately beneath|
000044a0 20 74 68 65 20 27 44 61 74 61 20 66 69 65 6c 64 | the 'Data field|
000044b0 27 20 65 6e 74 72 79 20 6f 6e 20 74 68 65 20 6d |' entry on the m|
000044c0 65 6e 75 20 69 73 20 6f 6e 65 20 63 61 6c 6c 65 |enu is one calle|
000044d0 64 0a 27 44 65 66 61 75 6c 74 20 64 61 74 61 62 |d.'Default datab|
000044e0 61 73 65 27 2e 20 43 68 6f 6f 73 69 6e 67 20 74 |ase'. Choosing t|
000044f0 68 69 73 20 69 73 20 62 79 20 66 61 72 20 74 68 |his is by far th|
00004500 65 20 66 61 73 74 65 73 74 20 77 61 79 20 6f 66 |e fastest way of|
00004510 20 67 65 74 74 69 6e 67 20 61 0a 64 61 74 61 62 | getting a.datab|
00004520 61 73 65 20 75 70 20 61 6e 64 20 72 75 6e 6e 69 |ase up and runni|
00004530 6e 67 2e 20 49 74 73 20 61 63 74 69 6f 6e 20 69 |ng. Its action i|
00004540 73 20 74 6f 20 63 72 65 61 74 65 20 74 68 72 65 |s to create thre|
00004550 65 20 66 69 6c 65 73 20 69 6e 73 69 64 65 20 74 |e files inside t|
00004560 68 65 0a 61 70 70 6c 69 63 61 74 69 6f 6e 20 64 |he.application d|
00004570 69 72 65 63 74 6f 72 79 2e 20 54 68 65 73 65 20 |irectory. These |
00004580 61 72 65 20 63 61 6c 6c 65 64 20 27 46 6f 72 6d |are called 'Form|
00004590 27 20 28 77 68 69 63 68 20 68 6f 6c 64 73 20 74 |' (which holds t|
000045a0 68 65 20 72 65 63 6f 72 64 0a 64 65 73 69 67 6e |he record.design|
000045b0 29 2c 20 27 50 72 69 6d 61 72 79 4b 65 79 27 20 |), 'PrimaryKey' |
000045c0 61 6e 64 20 27 44 61 74 61 62 61 73 65 27 20 28 |and 'Database' (|
000045d0 77 68 69 63 68 20 77 69 6c 6c 20 75 6c 74 69 6d |which will ultim|
000045e0 61 74 65 6c 79 20 63 6f 6e 74 61 69 6e 20 74 68 |ately contain th|
000045f0 65 0a 65 6e 74 65 72 65 64 20 72 65 63 6f 72 64 |e.entered record|
00004600 73 29 2e 20 54 68 65 20 6e 75 6d 62 65 72 20 6f |s). The number o|
00004610 66 20 72 65 63 6f 72 64 73 20 69 6e 20 74 68 65 |f records in the|
00004620 20 64 61 74 61 62 61 73 65 20 69 73 20 73 65 74 | database is set|
00004630 20 74 6f 20 31 30 30 2c 20 77 69 74 68 0a 32 35 | to 100, with.25|
00004640 20 61 73 20 74 68 65 20 61 6d 6f 75 6e 74 20 62 | as the amount b|
00004650 79 20 77 68 69 63 68 20 74 68 69 73 20 73 68 6f |y which this sho|
00004660 75 6c 64 20 69 6e 63 72 65 61 73 65 20 77 68 65 |uld increase whe|
00004670 6e 20 74 68 65 20 64 61 74 61 62 61 73 65 20 62 |n the database b|
00004680 65 63 6f 6d 65 73 0a 66 75 6c 6c 2e 20 54 68 65 |ecomes.full. The|
00004690 20 70 72 69 6d 61 72 79 20 6b 65 79 20 69 73 20 | primary key is |
000046a0 64 65 66 69 6e 65 64 20 61 73 20 74 68 65 20 66 |defined as the f|
000046b0 69 72 73 74 20 66 6f 75 72 20 63 68 61 72 61 63 |irst four charac|
000046c0 74 65 72 73 20 6f 66 20 74 68 65 20 66 69 72 73 |ters of the firs|
000046d0 74 0a 77 72 69 74 61 62 6c 65 20 66 69 65 6c 64 |t.writable field|
000046e0 2e 20 54 68 65 20 64 61 74 61 62 61 73 65 20 69 |. The database i|
000046f0 73 20 6f 70 65 6e 65 64 20 61 6e 64 20 61 20 62 |s opened and a b|
00004700 6c 61 6e 6b 20 72 65 63 6f 72 64 20 64 69 73 70 |lank record disp|
00004710 6c 61 79 65 64 20 72 65 61 64 79 0a 66 6f 72 20 |layed ready.for |
00004720 64 61 74 61 20 65 6e 74 72 79 2e 0a 20 20 20 20 |data entry.. |
00004730 20 20 0a 53 69 6e 63 65 20 79 6f 75 20 63 61 6e | .Since you can|
00004740 20 61 6c 77 61 79 73 20 61 6c 74 65 72 20 73 75 | always alter su|
00004750 63 68 20 74 68 69 6e 67 73 20 61 73 20 74 68 65 |ch things as the|
00004760 20 64 61 74 61 62 61 73 65 20 73 69 7a 65 20 61 | database size a|
00004770 6e 64 20 70 72 69 6d 61 72 79 20 6b 65 79 0a 73 |nd primary key.s|
00004780 74 72 75 63 74 75 72 65 20 6c 61 74 65 72 2c 20 |tructure later, |
00004790 79 6f 75 20 6d 69 67 68 74 20 77 69 73 68 20 74 |you might wish t|
000047a0 6f 20 75 73 65 20 74 68 65 73 65 20 64 65 66 61 |o use these defa|
000047b0 75 6c 74 73 20 77 68 69 6c 65 20 79 6f 75 20 65 |ults while you e|
000047c0 78 70 65 72 69 6d 65 6e 74 0a 77 69 74 68 20 74 |xperiment.with t|
000047d0 68 65 20 64 61 74 61 62 61 73 65 2e 20 49 66 2c |he database. If,|
000047e0 20 68 6f 77 65 76 65 72 2c 20 79 6f 75 20 77 61 | however, you wa|
000047f0 6e 74 20 74 6f 20 73 65 74 20 74 68 65 20 64 61 |nt to set the da|
00004800 74 61 62 61 73 65 20 73 69 7a 65 20 79 6f 75 72 |tabase size your|
00004810 73 65 6c 66 0a 61 74 20 74 68 69 73 20 73 74 61 |self.at this sta|
00004820 67 65 20 70 72 6f 63 65 65 64 20 61 73 20 66 6f |ge proceed as fo|
00004830 6c 6c 6f 77 73 3a 2d 0a 0a 28 31 29 20 53 61 76 |llows:-..(1) Sav|
00004840 65 20 74 68 65 20 27 46 6f 72 6d 27 20 66 69 6c |e the 'Form' fil|
00004850 65 20 62 79 20 66 6f 6c 6c 6f 77 69 6e 67 20 74 |e by following t|
00004860 68 65 20 6d 65 6e 75 20 6f 70 74 69 6f 6e 20 61 |he menu option a|
00004870 6e 64 20 63 6c 69 63 6b 69 6e 67 20 6f 6e 20 27 |nd clicking on '|
00004880 4f 4b 27 0a 6f 72 20 74 79 70 69 6e 67 20 52 45 |OK'.or typing RE|
00004890 54 55 52 4e 20 77 68 65 6e 20 74 68 65 20 73 61 |TURN when the sa|
000048a0 76 65 20 62 6f 78 20 61 70 70 65 61 72 73 2e 20 |ve box appears. |
000048b0 54 68 65 20 70 61 74 68 6e 61 6d 65 20 69 73 20 |The pathname is |
000048c0 63 6f 72 72 65 63 74 6c 79 20 73 65 74 0a 66 6f |correctly set.fo|
000048d0 72 20 73 61 76 69 6e 67 20 74 68 65 20 66 69 6c |r saving the fil|
000048e0 65 20 69 6e 73 69 64 65 20 79 6f 75 72 20 64 61 |e inside your da|
000048f0 74 61 62 61 73 65 20 61 70 70 6c 69 63 61 74 69 |tabase applicati|
00004900 6f 6e 2e 0a 0a 28 32 29 20 59 6f 75 20 77 69 6c |on...(2) You wil|
00004910 6c 20 6e 6f 77 20 73 65 65 20 74 68 61 74 20 74 |l now see that t|
00004920 68 65 20 27 44 61 74 61 62 61 73 65 20 73 69 7a |he 'Database siz|
00004930 65 27 20 63 68 6f 69 63 65 20 69 73 20 6e 6f 20 |e' choice is no |
00004940 6c 6f 6e 67 65 72 20 73 68 61 64 65 64 20 61 6e |longer shaded an|
00004950 64 0a 6d 61 79 20 62 65 20 75 73 65 64 20 74 6f |d.may be used to|
00004960 20 72 65 61 63 68 20 74 68 65 20 64 69 61 6c 6f | reach the dialo|
00004970 67 75 65 20 62 6f 78 20 69 6e 20 77 68 69 63 68 |gue box in which|
00004980 20 79 6f 75 20 73 70 65 63 69 66 79 20 74 68 65 | you specify the|
00004990 20 6e 75 6d 62 65 72 20 6f 66 0a 72 65 63 6f 72 | number of.recor|
000049a0 64 73 20 69 6e 20 74 68 65 20 64 61 74 61 62 61 |ds in the databa|
000049b0 73 65 20 61 6e 64 20 74 68 65 20 69 6e 63 72 65 |se and the incre|
000049c0 6d 65 6e 74 20 66 6f 72 20 65 78 70 61 6e 64 69 |ment for expandi|
000049d0 6e 67 20 74 68 65 20 64 61 74 61 62 61 73 65 20 |ng the database |
000049e0 77 68 65 6e 20 69 74 0a 62 65 63 6f 6d 65 73 20 |when it.becomes |
000049f0 66 75 6c 6c 2e 0a 0a 53 70 65 63 69 66 79 69 6e |full...Specifyin|
00004a00 67 20 74 68 65 20 70 72 69 6d 61 72 79 20 6b 65 |g the primary ke|
00004a10 79 0a 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |y.==============|
00004a20 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 54 68 65 |============.The|
00004a30 20 70 72 69 6d 61 72 79 20 6b 65 79 20 28 6f 72 | primary key (or|
00004a40 20 61 6e 79 20 6f 74 68 65 72 20 6b 65 79 29 20 | any other key) |
00004a50 69 73 20 64 65 72 69 76 65 64 20 66 72 6f 6d 20 |is derived from |
00004a60 61 20 72 65 63 6f 72 64 20 66 69 65 6c 64 20 63 |a record field c|
00004a70 61 6c 6c 65 64 20 61 0a 6b 65 79 20 66 69 65 6c |alled a.key fiel|
00004a80 64 2e 20 54 68 65 20 6b 65 79 20 66 69 65 6c 64 |d. The key field|
00004a90 20 69 73 20 73 65 6c 65 63 74 65 64 20 62 79 20 | is selected by |
00004aa0 65 69 74 68 65 72 20 63 6c 69 63 6b 69 6e 67 20 |either clicking |
00004ab0 6f 6e 20 74 68 65 20 22 62 75 6d 70 22 20 69 63 |on the "bump" ic|
00004ac0 6f 6e 73 0a 77 68 69 63 68 20 61 6c 6c 6f 77 20 |ons.which allow |
00004ad0 79 6f 75 20 74 6f 20 63 79 63 6c 65 20 74 68 72 |you to cycle thr|
00004ae0 6f 75 67 68 20 74 68 65 20 66 69 65 6c 64 20 74 |ough the field t|
00004af0 61 67 73 2c 20 6f 72 20 62 79 20 63 68 6f 6f 73 |ags, or by choos|
00004b00 69 6e 67 20 66 72 6f 6d 20 61 20 6d 65 6e 75 2e |ing from a menu.|
00004b10 0a 0a 4b 65 79 20 66 69 65 6c 64 73 20 6e 65 65 |..Key fields nee|
00004b20 64 20 74 6f 20 62 65 20 63 68 6f 73 65 6e 20 77 |d to be chosen w|
00004b30 69 74 68 20 63 61 72 65 2e 20 41 6e 20 69 64 65 |ith care. An ide|
00004b40 61 6c 20 6b 65 79 20 66 69 65 6c 64 20 69 73 20 |al key field is |
00004b50 6f 6e 65 20 77 68 6f 73 65 0a 63 6f 6e 74 65 6e |one whose.conten|
00004b60 74 73 20 77 6f 75 6c 64 20 6e 65 76 65 72 20 62 |ts would never b|
00004b70 65 20 72 65 70 65 61 74 65 64 20 69 6e 20 61 6e |e repeated in an|
00004b80 6f 74 68 65 72 20 72 65 63 6f 72 64 2e 20 50 6f |other record. Po|
00004b90 77 65 72 62 61 73 65 20 61 6c 6c 6f 77 73 20 79 |werbase allows y|
00004ba0 6f 75 20 74 6f 0a 65 6e 66 6f 72 63 65 20 74 68 |ou to.enforce th|
00004bb0 69 73 20 63 6f 6e 64 69 74 69 6f 6e 20 69 66 20 |is condition if |
00004bc0 79 6f 75 20 77 69 73 68 20 28 73 65 65 20 22 50 |you wish (see "P|
00004bd0 61 73 73 77 6f 72 64 73 22 29 2e 20 4f 63 63 61 |asswords"). Occa|
00004be0 73 69 6f 6e 61 6c 20 72 65 70 65 74 69 74 69 6f |sional repetitio|
00004bf0 6e 73 0a 6e 65 65 64 20 6e 6f 74 20 62 65 20 73 |ns.need not be s|
00004c00 65 72 69 6f 75 73 2c 20 62 75 74 20 61 20 66 69 |erious, but a fi|
00004c10 65 6c 64 20 77 68 69 63 68 20 63 61 6e 20 68 61 |eld which can ha|
00004c20 76 65 20 6f 6e 6c 79 20 61 20 66 65 77 20 22 76 |ve only a few "v|
00004c30 61 6c 75 65 73 22 20 69 73 0a 75 73 75 61 6c 6c |alues" is.usuall|
00004c40 79 20 61 20 70 6f 6f 72 20 63 68 6f 69 63 65 2e |y a poor choice.|
00004c50 20 41 20 63 75 73 74 6f 6d 65 72 20 6e 75 6d 62 | A customer numb|
00004c60 65 72 20 6f 72 20 6d 65 6d 62 65 72 73 68 69 70 |er or membership|
00004c70 20 6e 75 6d 62 65 72 20 69 73 20 74 68 65 20 73 | number is the s|
00004c80 6f 72 74 20 6f 66 0a 74 68 69 6e 67 20 77 65 20 |ort of.thing we |
00004c90 61 72 65 20 6c 6f 6f 6b 69 6e 67 20 66 6f 72 2c |are looking for,|
00004ca0 20 62 75 74 20 79 6f 75 72 20 64 61 74 61 62 61 | but your databa|
00004cb0 73 65 20 6d 61 79 20 6e 6f 74 20 63 6f 6e 74 61 |se may not conta|
00004cc0 69 6e 20 61 6e 79 74 68 69 6e 67 20 6c 69 6b 65 |in anything like|
00004cd0 0a 74 68 61 74 2e 20 20 49 6e 20 61 20 64 61 74 |.that. In a dat|
00004ce0 61 62 61 73 65 20 6f 66 20 73 63 68 6f 6f 6c 20 |abase of school |
00004cf0 70 75 70 69 6c 73 20 74 68 65 20 70 75 70 69 6c |pupils the pupil|
00004d00 27 73 20 6e 61 6d 65 20 77 6f 75 6c 64 20 62 65 |'s name would be|
00004d10 20 61 20 67 6f 6f 64 0a 63 68 6f 69 63 65 20 6f | a good.choice o|
00004d20 66 20 6b 65 79 2c 20 62 75 74 20 74 68 65 20 66 |f key, but the f|
00004d30 6f 72 6d 20 74 65 61 63 68 65 72 27 73 20 6e 61 |orm teacher's na|
00004d40 6d 65 20 77 6f 75 6c 64 20 6e 6f 74 2c 20 73 69 |me would not, si|
00004d50 6e 63 65 20 6f 6e 6c 79 20 61 20 73 6d 61 6c 6c |nce only a small|
00004d60 0a 6e 75 6d 62 65 72 20 6f 66 20 6e 61 6d 65 73 |.number of names|
00004d70 20 77 6f 75 6c 64 20 62 65 20 69 6e 76 6f 6c 76 | would be involv|
00004d80 65 64 2c 20 65 61 63 68 20 61 70 70 65 61 72 69 |ed, each appeari|
00004d90 6e 67 20 6f 6e 20 74 68 65 20 72 65 63 6f 72 64 |ng on the record|
00004da0 20 6f 66 20 6d 61 6e 79 0a 70 75 70 69 6c 73 2e | of many.pupils.|
00004db0 0a 0a 53 75 70 70 6f 73 65 20 77 65 20 64 65 63 |..Suppose we dec|
00004dc0 69 64 65 20 74 6f 20 75 73 65 20 61 20 70 65 72 |ide to use a per|
00004dd0 73 6f 6e 27 73 20 6e 61 6d 65 2c 20 73 74 6f 72 |son's name, stor|
00004de0 65 64 20 73 75 72 6e 61 6d 65 20 66 69 72 73 74 |ed surname first|
00004df0 2c 20 61 73 20 61 20 6b 65 79 2e 20 57 65 0a 63 |, as a key. We.c|
00004e00 61 6e 20 68 61 72 64 6c 79 20 75 73 65 20 74 68 |an hardly use th|
00004e10 65 20 77 68 6f 6c 65 20 6e 61 6d 65 3b 20 69 74 |e whole name; it|
00004e20 20 77 6f 75 6c 64 20 62 65 20 66 61 72 20 74 6f | would be far to|
00004e30 6f 20 6c 6f 6e 67 2e 20 54 68 65 20 66 69 72 73 |o long. The firs|
00004e40 74 20 66 6f 75 72 0a 6c 65 74 74 65 72 73 20 77 |t four.letters w|
00004e50 6f 75 6c 64 20 62 65 20 6d 6f 72 65 20 61 70 70 |ould be more app|
00004e60 72 6f 70 72 69 61 74 65 20 62 75 74 2c 20 73 69 |ropriate but, si|
00004e70 6e 63 65 20 74 68 69 73 20 69 73 20 74 68 65 20 |nce this is the |
00004e80 73 74 61 72 74 20 6f 66 20 74 68 65 0a 73 75 72 |start of the.sur|
00004e90 6e 61 6d 65 2c 20 77 65 20 6d 69 67 68 74 20 68 |name, we might h|
00004ea0 61 76 65 20 61 20 6c 6f 74 20 6f 66 20 53 6d 69 |ave a lot of Smi|
00004eb0 74 68 73 20 6f 72 2c 20 69 6e 20 57 61 6c 65 73 |ths or, in Wales|
00004ec0 2c 20 61 20 56 45 52 59 20 6c 61 72 67 65 20 6e |, a VERY large n|
00004ed0 75 6d 62 65 72 20 6f 66 0a 72 65 70 65 74 69 74 |umber of.repetit|
00004ee0 69 6f 6e 73 20 6f 66 20 4a 6f 6e 65 73 20 6f 72 |ions of Jones or|
00004ef0 20 45 76 61 6e 73 21 20 54 6f 20 67 65 74 20 72 | Evans! To get r|
00004f00 6f 75 6e 64 20 74 68 69 73 20 70 72 6f 62 6c 65 |ound this proble|
00004f10 6d 2c 20 50 6f 77 65 72 62 61 73 65 20 61 6c 6c |m, Powerbase all|
00004f20 6f 77 73 0a 79 6f 75 20 74 6f 20 63 6f 6e 73 74 |ows.you to const|
00004f30 72 75 63 74 20 61 6e 20 61 6c 70 68 61 6e 75 6d |ruct an alphanum|
00004f40 65 72 69 63 20 6b 65 79 20 66 72 6f 6d 20 63 68 |eric key from ch|
00004f50 61 72 61 63 74 65 72 73 20 74 61 6b 65 6e 20 66 |aracters taken f|
00004f60 72 6f 6d 20 75 70 20 74 6f 20 66 6f 75 72 0a 73 |rom up to four.s|
00004f70 75 63 63 65 73 73 69 76 65 20 77 6f 72 64 73 2e |uccessive words.|
00004f80 20 59 6f 75 20 77 69 6c 6c 20 73 65 6c 64 6f 6d | You will seldom|
00004f90 20 6e 65 65 64 20 74 6f 20 67 6f 20 61 73 20 66 | need to go as f|
00004fa0 61 72 20 61 73 20 74 68 69 73 2e 20 49 6e 20 74 |ar as this. In t|
00004fb0 68 65 20 61 62 6f 76 65 0a 65 78 61 6d 70 6c 65 |he above.example|
00004fc0 2c 20 61 20 66 69 76 65 2d 6c 65 74 74 65 72 20 |, a five-letter |
00004fd0 6b 65 79 20 6d 61 64 65 20 75 70 20 66 72 6f 6d |key made up from|
00004fe0 20 74 68 65 20 66 69 72 73 74 20 66 6f 75 72 20 | the first four |
00004ff0 6c 65 74 74 65 72 73 20 6f 66 20 74 68 65 0a 73 |letters of the.s|
00005000 75 72 6e 61 6d 65 20 61 6e 64 20 6f 6e 65 20 6c |urname and one l|
00005010 65 74 74 65 72 20 6f 66 20 74 68 65 20 66 6f 72 |etter of the for|
00005020 65 6e 61 6d 65 20 77 6f 75 6c 64 20 62 65 20 67 |ename would be g|
00005030 6f 6f 64 20 65 6e 6f 75 67 68 20 66 6f 72 20 6d |ood enough for m|
00005040 6f 73 74 0a 70 75 72 70 6f 73 65 73 2e 20 53 6d |ost.purposes. Sm|
00005050 69 74 68 20 50 65 74 65 72 20 61 6e 64 20 53 6d |ith Peter and Sm|
00005060 69 74 68 20 4a 61 6e 65 74 20 77 6f 75 6c 64 20 |ith Janet would |
00005070 68 61 76 65 20 74 68 65 20 6b 65 79 73 20 53 4d |have the keys SM|
00005080 49 54 50 20 61 6e 64 20 53 4d 49 54 4a 2e 0a 44 |ITP and SMITJ..D|
00005090 75 70 6c 69 63 61 74 69 6f 6e 20 63 61 6e 20 73 |uplication can s|
000050a0 74 69 6c 6c 20 6f 63 63 75 72 2c 20 62 75 74 20 |till occur, but |
000050b0 6e 6f 74 20 6f 66 74 65 6e 20 65 6e 6f 75 67 68 |not often enough|
000050c0 20 74 6f 20 62 65 20 61 20 73 65 72 69 6f 75 73 | to be a serious|
000050d0 20 70 72 6f 62 6c 65 6d 2e 0a 49 74 20 69 73 6e | problem..It isn|
000050e0 27 74 20 6e 6f 72 6d 61 6c 6c 79 20 73 65 6e 73 |'t normally sens|
000050f0 69 62 6c 65 20 74 6f 20 62 75 69 6c 64 20 61 20 |ible to build a |
00005100 6e 75 6d 65 72 69 63 20 6b 65 79 20 66 72 6f 6d |numeric key from|
00005110 20 73 65 76 65 72 61 6c 20 62 69 74 73 20 69 6e | several bits in|
00005120 20 74 68 69 73 0a 77 61 79 20 61 6e 64 20 50 6f | this.way and Po|
00005130 77 65 72 62 61 73 65 20 77 6f 6e 27 74 20 6c 65 |werbase won't le|
00005140 74 20 79 6f 75 20 64 6f 20 73 6f 2e 20 53 75 63 |t you do so. Suc|
00005150 68 20 61 20 6b 65 79 20 63 6f 6e 73 69 73 74 73 |h a key consists|
00005160 20 6f 66 20 74 68 65 20 6e 75 6d 65 72 69 63 0a | of the numeric.|
00005170 76 61 6c 75 65 20 6f 66 20 74 68 65 20 63 68 6f |value of the cho|
00005180 73 65 6e 20 6b 65 79 20 66 69 65 6c 64 2e 0a 0a |sen key field...|
00005190 54 68 65 72 65 20 61 72 65 20 64 61 74 61 62 61 |There are databa|
000051a0 73 65 73 20 77 68 65 72 65 20 6e 6f 20 66 69 65 |ses where no fie|
000051b0 6c 64 20 73 65 65 6d 73 20 73 75 69 74 61 62 6c |ld seems suitabl|
000051c0 65 20 61 73 20 61 20 6b 65 79 20 66 69 65 6c 64 |e as a key field|
000051d0 2e 20 43 6f 6e 73 69 64 65 72 0a 61 20 64 61 74 |. Consider.a dat|
000051e0 61 62 61 73 65 20 6f 66 20 63 6c 61 73 73 69 63 |abase of classic|
000051f0 61 6c 20 6d 75 73 69 63 2e 20 54 68 65 72 65 20 |al music. There |
00005200 77 6f 75 6c 64 20 62 65 20 61 20 66 69 65 6c 64 |would be a field|
00005210 20 66 6f 72 20 74 68 65 20 63 6f 6d 70 6f 73 65 | for the compose|
00005220 72 27 73 0a 6e 61 6d 65 20 61 6e 64 20 6f 6e 65 |r's.name and one|
00005230 20 66 6f 72 20 74 68 65 20 6e 61 6d 65 20 6f 66 | for the name of|
00005240 20 74 68 65 20 77 6f 72 6b 2e 20 4e 65 69 74 68 | the work. Neith|
00005250 65 72 20 69 73 20 6d 75 63 68 20 75 73 65 20 6f |er is much use o|
00005260 6e 20 69 74 73 20 6f 77 6e 3a 20 74 68 65 0a 66 |n its own: the.f|
00005270 6f 72 6d 65 72 20 77 6f 75 6c 64 20 63 6f 6e 74 |ormer would cont|
00005280 61 69 6e 20 70 6f 73 73 69 62 6c 79 20 68 75 6e |ain possibly hun|
00005290 64 72 65 64 73 20 6f 66 20 6f 63 63 75 72 72 65 |dreds of occurre|
000052a0 6e 63 65 73 20 6f 66 20 4d 6f 7a 61 72 74 20 61 |nces of Mozart a|
000052b0 6e 64 0a 42 65 65 74 68 6f 76 65 6e 20 61 6e 64 |nd.Beethoven and|
000052c0 20 74 68 65 20 6c 61 74 74 65 72 20 77 6f 75 6c | the latter woul|
000052d0 64 20 68 61 76 65 20 6e 75 6d 65 72 6f 75 73 20 |d have numerous |
000052e0 72 65 70 65 74 69 74 69 6f 6e 73 20 6f 66 20 53 |repetitions of S|
000052f0 79 6d 70 68 6f 6e 79 20 4e 6f 2e 35 0a 6f 72 20 |ymphony No.5.or |
00005300 53 74 72 69 6e 67 20 51 75 61 72 74 65 74 20 69 |String Quartet i|
00005310 6e 20 44 20 6d 69 6e 6f 72 2e 0a 0a 54 6f 20 64 |n D minor...To d|
00005320 65 61 6c 20 77 69 74 68 20 73 75 63 68 20 73 69 |eal with such si|
00005330 74 75 61 74 69 6f 6e 73 20 50 6f 77 65 72 62 61 |tuations Powerba|
00005340 73 65 20 61 6c 6c 6f 77 73 20 79 6f 75 20 74 6f |se allows you to|
00005350 20 75 73 65 20 61 20 63 6f 6d 70 6f 73 69 74 65 | use a composite|
00005360 0a 61 6c 70 68 61 6e 75 6d 65 72 69 63 20 6b 65 |.alphanumeric ke|
00005370 79 2c 20 62 61 73 65 64 20 6f 6e 20 74 77 6f 20 |y, based on two |
00005380 66 69 65 6c 64 73 20 69 6e 20 63 6f 6d 62 69 6e |fields in combin|
00005390 61 74 69 6f 6e 2e 20 41 20 73 65 63 6f 6e 64 20 |ation. A second |
000053a0 67 72 6f 75 70 20 6f 66 0a 69 63 6f 6e 73 20 61 |group of.icons a|
000053b0 6c 6c 6f 77 73 20 79 6f 75 20 74 6f 20 63 79 63 |llows you to cyc|
000053c0 6c 65 20 74 68 72 6f 75 67 68 20 74 68 65 20 74 |le through the t|
000053d0 61 67 73 20 66 6f 72 20 74 68 65 20 73 65 63 6f |ags for the seco|
000053e0 6e 64 20 66 69 65 6c 64 2c 20 6f 72 20 63 68 6f |nd field, or cho|
000053f0 6f 73 65 0a 69 74 20 66 72 6f 6d 20 61 20 6d 65 |ose.it from a me|
00005400 6e 75 2e 0a 0a 49 6d 61 67 69 6e 65 20 74 68 65 |nu...Imagine the|
00005410 20 74 77 6f 20 66 69 65 6c 64 73 20 70 6c 61 63 | two fields plac|
00005420 65 64 20 65 6e 64 20 74 6f 20 65 6e 64 2c 20 77 |ed end to end, w|
00005430 69 74 68 20 61 20 73 69 6e 67 6c 65 20 73 70 61 |ith a single spa|
00005440 63 65 20 62 65 74 77 65 65 6e 20 74 68 65 6d 2e |ce between them.|
00005450 0a 54 68 65 20 6b 65 79 20 6d 61 79 20 74 68 65 |.The key may the|
00005460 6e 20 62 65 20 62 61 73 65 64 20 6f 6e 20 74 68 |n be based on th|
00005470 65 20 66 69 72 73 74 20 66 6f 75 72 20 77 6f 72 |e first four wor|
00005480 64 73 20 6f 66 20 74 68 65 20 63 6f 6d 70 6f 73 |ds of the compos|
00005490 69 74 65 20 66 69 65 6c 64 2e 20 57 65 0a 6d 69 |ite field. We.mi|
000054a0 67 68 74 2c 20 66 6f 72 20 74 68 65 20 6d 75 73 |ght, for the mus|
000054b0 69 63 20 64 61 74 61 62 61 73 65 2c 20 75 73 65 |ic database, use|
000054c0 20 61 6c 6c 20 66 6f 75 72 20 77 6f 72 64 73 20 | all four words |
000054d0 61 6e 64 20 74 61 6b 65 20 34 2c 33 2c 33 2c 32 |and take 4,3,3,2|
000054e0 0a 63 68 61 72 61 63 74 65 72 73 20 72 65 73 70 |.characters resp|
000054f0 65 63 74 69 76 65 6c 79 20 66 72 6f 6d 20 74 68 |ectively from th|
00005500 65 6d 2e 20 20 54 68 65 20 66 6f 6c 6c 6f 77 69 |em. The followi|
00005510 6e 67 20 74 77 6f 20 77 6f 72 6b 73 20 74 68 65 |ng two works the|
00005520 6e 20 67 69 76 65 20 74 68 65 0a 6b 65 79 73 20 |n give the.keys |
00005530 73 68 6f 77 6e 3a 0a 0a 20 20 20 20 20 20 20 20 |shown:.. |
00005540 20 20 20 20 20 20 20 20 42 45 45 54 48 4f 56 45 | BEETHOVE|
00005550 4e 20 20 53 79 6d 70 68 6f 6e 79 20 4e 6f 20 35 |N Symphony No 5|
00005560 3a 20 20 20 20 20 20 20 42 45 45 54 53 59 4d 4e |: BEETSYMN|
00005570 4f 35 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 |O5. |
00005580 20 20 20 4d 4f 5a 41 52 54 20 50 69 61 6e 6f 20 | MOZART Piano |
00005590 63 6f 6e 63 65 72 74 6f 20 32 33 3a 20 20 20 20 |concerto 23: |
000055a0 20 20 20 4d 4f 5a 41 50 49 41 43 4f 4e 32 33 0a | MOZAPIACON23.|
000055b0 0a 4e 6f 74 65 20 74 68 65 20 66 6f 6c 6c 6f 77 |.Note the follow|
000055c0 69 6e 67 20 70 6f 69 6e 74 73 20 69 6e 20 74 68 |ing points in th|
000055d0 65 73 65 20 65 78 61 6d 70 6c 65 73 3a 0a 20 20 |ese examples:. |
000055e0 20 20 20 20 20 0a 20 20 20 20 20 20 20 20 28 61 | . (a|
000055f0 29 20 49 66 20 61 20 77 6f 72 64 20 69 73 20 73 |) If a word is s|
00005600 68 6f 72 74 65 72 20 74 68 61 6e 20 74 68 65 20 |horter than the |
00005610 6e 75 6d 62 65 72 20 6f 66 20 6c 65 74 74 65 72 |number of letter|
00005620 73 20 61 73 73 69 67 6e 65 64 20 74 6f 20 69 74 |s assigned to it|
00005630 20 0a 20 20 20 20 20 20 20 20 28 22 4e 6f 22 20 | . ("No" |
00005640 69 6e 20 74 68 65 20 66 69 72 73 74 20 65 78 61 |in the first exa|
00005650 6d 70 6c 65 29 20 74 68 65 6e 20 74 68 65 20 77 |mple) then the w|
00005660 68 6f 6c 65 20 77 6f 72 64 20 69 73 20 75 73 65 |hole word is use|
00005670 64 20 62 75 74 20 6e 6f 0a 20 20 20 20 20 20 20 |d but no. |
00005680 20 70 61 64 64 69 6e 67 20 69 73 20 69 6e 73 65 | padding is inse|
00005690 72 74 65 64 2e 0a 0a 20 20 20 20 20 20 20 20 28 |rted... (|
000056a0 62 29 20 49 74 20 6d 61 79 20 62 65 20 6e 65 63 |b) It may be nec|
000056b0 65 73 73 61 72 79 20 74 6f 20 6c 65 61 76 65 20 |essary to leave |
000056c0 6f 75 74 20 61 6e 20 69 6e 73 69 67 6e 69 66 69 |out an insignifi|
000056d0 63 61 6e 74 20 77 6f 72 64 20 28 22 4e 6f 22 20 |cant word ("No" |
000056e0 69 6e 0a 20 20 20 20 20 20 20 20 74 68 65 20 73 |in. the s|
000056f0 65 63 6f 6e 64 20 65 78 61 6d 70 6c 65 2c 20 73 |econd example, s|
00005700 6f 20 74 68 61 74 20 61 20 73 69 67 6e 69 66 69 |o that a signifi|
00005710 63 61 6e 74 20 6f 6e 65 20 28 22 32 33 22 29 20 |cant one ("23") |
00005720 63 6f 6d 65 73 20 69 6e 20 74 68 65 0a 20 20 20 |comes in the. |
00005730 20 20 20 20 20 66 69 72 73 74 20 66 6f 75 72 20 | first four |
00005740 77 6f 72 64 73 20 6f 66 20 74 68 65 20 63 6f 6d |words of the com|
00005750 70 6f 73 69 74 65 20 66 69 65 6c 64 2e 0a 0a 4f |posite field...O|
00005760 6e 63 65 20 79 6f 75 20 68 61 76 65 20 64 65 63 |nce you have dec|
00005770 69 64 65 64 20 6f 6e 20 74 68 65 20 73 74 72 75 |ided on the stru|
00005780 63 74 75 72 65 20 6f 66 20 79 6f 75 72 20 70 72 |cture of your pr|
00005790 69 6d 61 72 79 20 6b 65 79 2c 20 67 6f 20 74 6f |imary key, go to|
000057a0 20 74 68 65 20 0a 64 69 61 6c 6f 67 75 65 20 62 | the .dialogue b|
000057b0 6f 78 20 66 72 6f 6d 20 74 68 65 20 27 50 72 69 |ox from the 'Pri|
000057c0 6d 61 72 79 20 6b 65 79 27 20 6d 65 6e 75 20 65 |mary key' menu e|
000057d0 6e 74 72 79 2e 20 43 6c 69 63 6b 20 6f 6e 20 74 |ntry. Click on t|
000057e0 68 65 20 66 69 72 73 74 20 69 63 6f 6e 0a 75 6e |he first icon.un|
000057f0 74 69 6c 20 74 68 65 20 74 61 67 20 6f 66 20 74 |til the tag of t|
00005800 68 65 20 72 65 71 75 69 72 65 64 20 66 69 65 6c |he required fiel|
00005810 64 20 69 73 20 73 68 6f 77 6e 2e 20 44 6f 20 74 |d is shown. Do t|
00005820 68 65 20 73 61 6d 65 20 77 69 74 68 20 74 68 65 |he same with the|
00005830 20 73 65 63 6f 6e 64 20 69 66 0a 73 70 65 63 69 | second if.speci|
00005840 66 79 69 6e 67 20 61 20 63 6f 6d 70 6f 73 69 74 |fying a composit|
00005850 65 20 6b 65 79 2e 20 45 6e 74 65 72 20 74 68 65 |e key. Enter the|
00005860 20 6e 75 6d 62 65 72 73 20 6f 66 20 6c 65 74 74 | numbers of lett|
00005870 65 72 73 20 61 73 73 69 67 6e 65 64 20 74 6f 20 |ers assigned to |
00005880 65 61 63 68 0a 77 6f 72 64 2e 20 0a 0a 41 6e 6f |each.word. ..Ano|
00005890 74 68 65 72 20 63 68 6f 69 63 65 20 74 6f 20 62 |ther choice to b|
000058a0 65 20 64 65 63 69 64 65 64 20 69 73 20 69 66 20 |e decided is if |
000058b0 74 68 65 20 69 6e 64 65 78 69 6e 67 20 69 73 20 |the indexing is |
000058c0 74 6f 20 70 61 79 20 61 6e 79 20 61 74 74 65 6e |to pay any atten|
000058d0 74 69 6f 6e 20 74 6f 0a 77 68 65 74 68 65 72 20 |tion to.whether |
000058e0 6c 65 74 74 65 72 73 20 61 72 65 20 75 70 70 65 |letters are uppe|
000058f0 72 20 6f 72 20 6c 6f 77 65 72 20 63 61 73 65 2e |r or lower case.|
00005900 20 42 79 20 64 65 66 61 75 6c 74 20 69 6e 64 65 | By default inde|
00005910 78 69 6e 67 20 69 73 20 4e 4f 54 0a 63 61 73 65 |xing is NOT.case|
00005920 2d 73 65 6e 73 69 74 69 76 65 2c 20 61 6c 6c 20 |-sensitive, all |
00005930 6b 65 79 73 20 62 65 69 6e 67 20 66 6f 72 63 65 |keys being force|
00005940 64 20 74 6f 20 75 70 70 65 72 20 63 61 73 65 20 |d to upper case |
00005950 62 65 66 6f 72 65 20 69 6e 73 65 72 74 69 6f 6e |before insertion|
00005960 20 69 6e 20 74 68 65 0a 69 6e 64 65 78 20 61 6e | in the.index an|
00005970 64 20 73 65 61 72 63 68 20 73 74 72 69 6e 67 73 |d search strings|
00005980 20 62 65 69 6e 67 20 73 69 6d 69 6c 61 72 6c 79 | being similarly|
00005990 20 66 6f 72 63 65 64 20 74 6f 20 75 70 70 65 72 | forced to upper|
000059a0 20 63 61 73 65 2e 20 54 68 75 73 20 69 66 20 61 | case. Thus if a|
000059b0 0a 72 65 63 6f 72 64 20 68 61 73 20 74 68 65 20 |.record has the |
000059c0 77 6f 72 64 20 22 48 6f 72 73 65 22 20 61 73 20 |word "Horse" as |
000059d0 74 68 65 20 63 6f 6e 74 65 6e 74 73 20 6f 66 20 |the contents of |
000059e0 61 20 6b 65 79 20 66 69 65 6c 64 20 61 6e 64 20 |a key field and |
000059f0 74 68 65 20 66 69 72 73 74 0a 66 6f 75 72 20 6c |the first.four l|
00005a00 65 74 74 65 72 73 20 61 72 65 20 75 73 65 64 20 |etters are used |
00005a10 61 73 20 74 68 65 20 6b 65 79 20 74 68 65 6e 20 |as the key then |
00005a20 74 68 65 20 65 6e 74 72 79 20 69 6e 20 74 68 65 |the entry in the|
00005a30 20 69 6e 64 65 78 20 77 69 6c 6c 20 62 65 20 22 | index will be "|
00005a40 48 4f 52 53 22 0a 61 6e 64 20 79 6f 75 20 6d 61 |HORS".and you ma|
00005a50 79 20 73 65 61 72 63 68 20 66 6f 72 20 69 74 20 |y search for it |
00005a60 62 79 20 65 6e 74 65 72 69 6e 67 20 22 48 4f 52 |by entering "HOR|
00005a70 53 22 2c 20 22 68 6f 72 73 22 2c 20 22 48 6f 72 |S", "hors", "Hor|
00005a80 73 22 2c 20 22 68 4f 72 53 22 20 65 74 63 2e 0a |s", "hOrS" etc..|
00005a90 0a 54 68 69 73 20 6d 69 67 68 74 20 6e 6f 74 20 |.This might not |
00005aa0 62 65 20 77 68 61 74 20 79 6f 75 20 77 61 6e 74 |be what you want|
00005ab0 2e 20 49 66 20 79 6f 75 20 72 65 71 75 69 72 65 |. If you require|
00005ac0 20 69 6e 64 65 78 69 6e 67 20 74 6f 20 62 65 20 | indexing to be |
00005ad0 63 61 73 65 2d 0a 73 65 6e 73 69 74 69 76 65 20 |case-.sensitive |
00005ae0 74 68 65 6e 20 73 65 6c 65 63 74 20 74 68 65 20 |then select the |
00005af0 73 77 69 74 63 68 20 6c 61 62 65 6c 6c 65 64 20 |switch labelled |
00005b00 27 43 61 73 65 20 73 65 6e 73 69 74 69 76 65 27 |'Case sensitive'|
00005b10 2e 20 54 68 65 20 66 6f 72 63 69 6e 67 20 74 6f |. The forcing to|
00005b20 0a 75 70 70 65 72 20 63 61 73 65 20 64 65 73 63 |.upper case desc|
00005b30 72 69 62 65 64 20 61 62 6f 76 65 20 64 6f 65 73 |ribed above does|
00005b40 20 6e 6f 74 20 74 68 65 6e 20 74 61 6b 65 20 70 | not then take p|
00005b50 6c 61 63 65 20 2d 20 6b 65 79 73 20 61 72 65 20 |lace - keys are |
00005b60 69 6e 73 65 72 74 65 64 20 61 6e 64 0a 73 74 72 |inserted and.str|
00005b70 69 6e 67 73 20 61 72 65 20 73 65 61 72 63 68 65 |ings are searche|
00005b80 64 20 66 6f 72 20 22 61 73 20 69 73 22 2e 20 54 |d for "as is". T|
00005b90 68 65 20 66 69 65 6c 64 20 63 6f 6e 74 61 69 6e |he field contain|
00005ba0 69 6e 67 20 22 48 6f 72 73 65 22 20 77 69 6c 6c |ing "Horse" will|
00005bb0 20 62 65 0a 69 6e 64 65 78 65 64 20 61 73 20 22 | be.indexed as "|
00005bc0 48 6f 72 73 22 20 61 6e 64 20 6f 6e 6c 79 20 74 |Hors" and only t|
00005bd0 68 61 74 20 70 72 65 63 69 73 65 20 63 6f 6d 62 |hat precise comb|
00005be0 69 6e 61 74 69 6f 6e 20 6f 66 20 75 70 70 65 72 |ination of upper|
00005bf0 20 61 6e 64 20 6c 6f 77 65 72 20 63 61 73 65 0a | and lower case.|
00005c00 6c 65 74 74 65 72 73 20 77 69 6c 6c 20 73 75 63 |letters will suc|
00005c10 63 65 73 73 66 75 6c 6c 79 20 66 69 6e 64 20 69 |cessfully find i|
00005c20 74 2e 20 41 6c 70 68 61 62 65 74 69 63 20 6b 65 |t. Alphabetic ke|
00005c30 79 73 20 77 69 6c 6c 20 62 65 20 6f 72 64 65 72 |ys will be order|
00005c40 65 64 20 61 63 63 6f 72 64 69 6e 67 0a 74 6f 20 |ed according.to |
00005c50 74 68 65 20 41 53 43 49 49 20 76 61 6c 75 65 73 |the ASCII values|
00005c60 20 6f 66 20 74 68 65 20 6c 65 74 74 65 72 73 2e | of the letters.|
00005c70 20 53 69 6e 63 65 20 6c 6f 77 65 72 2d 63 61 73 | Since lower-cas|
00005c80 65 20 6c 65 74 74 65 72 73 20 63 6f 6d 65 20 6c |e letters come l|
00005c90 61 74 65 72 20 69 6e 0a 74 68 65 20 41 53 43 49 |ater in.the ASCI|
00005ca0 49 20 74 61 62 6c 65 20 74 68 61 6e 20 75 70 70 |I table than upp|
00005cb0 65 72 2d 63 61 73 65 20 6f 6e 65 73 20 61 20 72 |er-case ones a r|
00005cc0 65 63 6f 72 64 20 63 6f 6e 74 61 69 6e 69 6e 67 |ecord containing|
00005cd0 20 22 64 6f 67 22 20 77 6f 75 6c 64 20 61 70 70 | "dog" would app|
00005ce0 65 61 72 0a 41 46 54 45 52 20 6f 6e 65 20 63 6f |ear.AFTER one co|
00005cf0 6e 74 61 69 6e 69 6e 67 20 22 48 6f 72 73 65 22 |ntaining "Horse"|
00005d00 2c 20 77 68 65 72 65 61 73 20 6f 6e 65 20 63 6f |, whereas one co|
00005d10 6e 74 61 69 6e 69 6e 67 20 22 44 6f 67 22 20 77 |ntaining "Dog" w|
00005d20 6f 75 6c 64 20 63 6f 6d 65 20 62 65 66 6f 72 65 |ould come before|
00005d30 0a 22 48 6f 72 73 65 22 2e 0a 0a 4f 6e 63 65 20 |."Horse"...Once |
00005d40 79 6f 75 20 61 72 65 20 73 61 74 69 73 66 69 65 |you are satisfie|
00005d50 64 20 63 6c 69 63 6b 20 4f 4b 20 61 6e 64 20 79 |d click OK and y|
00005d60 6f 75 72 20 64 61 74 61 62 61 73 65 20 77 69 6c |our database wil|
00005d70 6c 20 62 65 20 63 72 65 61 74 65 64 2e 20 54 68 |l be created. Th|
00005d80 65 0a 72 65 63 6f 72 64 20 77 69 6e 64 6f 77 20 |e.record window |
00005d90 69 73 20 72 65 64 72 61 77 6e 20 61 6e 64 20 79 |is redrawn and y|
00005da0 6f 75 20 6d 61 79 20 73 74 61 72 74 20 65 6e 74 |ou may start ent|
00005db0 65 72 69 6e 67 20 64 61 74 61 20 61 74 20 6f 6e |ering data at on|
00005dc0 63 65 2e 0a 0a 0a 0a 0a 0a 0a 0a 0a 0a |ce...........|
00005dcd 
.