Home » Archimedes archive » Zipped Apps » Squirrel » squirrel/Errata
squirrel/Errata
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 » Zipped Apps » Squirrel |
| Filename: | squirrel/Errata |
| Read OK: | ✔ |
| File size: | 2ED8 bytes |
| Load address: | 0000 |
| Exec address: | 0000 |
File contents
Errata for Squirrel
===================
This file covers details which were erroneously omitted or incorrect in the
manual at time of print.
4.21 Default field entries
--------------------------
Facilities using system variables have been added since the manual was
printed. They enable fields and queries (see 6.26 below) to be
parameterised.
Default field entries can be defined as a system variable, which may have
been set according to the environment of the user. For example, in a
multi-user/network environment, a table could have a field which requires
the user's initials. Users can share the same table, but have different
default entries, such as:
*Set My$Initials DNF
This could be set automatically as part of the !ArmBoot file when logging on
to the file server, or as part of the !Boot file of the computer.
To set the default entry to be a system variable, precede the default entry
by an '@' symbol, e.g. @My$Initials. In create table mode, use the default
entry option in the sub-menu of the Validation menu found in the Field
details dialogue box.
If you require a default entry to actually start with an '@' symbol, the
system variable evaluation can be disabled by preceding with another '@',
i.e. '@@'.
The maximum length of the evaluated variable must not exceed 255 characters,
otherwise the field will be left blank. It is also left blank if the
variable is not set.
5.9 The browse tool window
--------------------------
The manual does not indicate that this window can be made to appear or not
appear by default when loading a table. This can be configured from
create/edit table mode by turning the field type tool window on or off
according to the state prefered. When the table is re-saved, the state of
the tool window will be remembered and will dictate the state of the browse
tool window.
5.10 List mode
--------------
The manual is incorrect about the default number of rows being 10 (page
5.10): it has been changed to be calculated automatically to fit the screen
size, indicated by the text 'Auto' in the 'Number of rows' writable icon in
the List mode dialogue box. If required, a number can be specified by
deleting the 'Auto' text from this icon.
5.13 Tool window browse control buttons in Data mode
----------------------------------------------------
The browse buttons index by the field containing the caret - like the PAGE
UP and PAGE DOWN keys. If the window does not contain the caret, then it
will index by the first field, or the last field that the caret was in if it
is not in another data mode or query mode window.
5.18 Data entry comparing against validation list
-------------------------------------------------
The manual does not indicate that abbreviated entries are accepted and the
field contents are replaced with the nearest match in the validation list,
for example:
Validation list is:
Blue
Green
Orange
Grey
If the user enters
gr
then this will be replaced by
Green
If 'Green' and 'Grey' are swapped in the validation list, then 'gr' will be
replaced by 'Grey'.
Note a problem in the following case:
Validation list is :
Room
Chairman
Chair
Table
If the user enters
Chair
then this will be replaced by
Chairman
The solution to this is to ensure that the validation list is in
alphabetical order, or if this is not desired, ensure that the shorter word
is in the list before the longer word, hence the following list would work
OK:
Room
Chair
Chairman
Table
6.4 List format in query data mode
----------------------------------
The manual does not indicate that list mode is available from query data
mode, i.e. when browsing through records in a query, these can be viewed in
list format rather than just card format. There is an extra menu option in
the 'Query data' menu for achieving this.
A query can be defined to automatically display the query data in list mode
instead of card mode by pressing F8 instead of F1 to execute the query.
Auto-run queries which are configured to Execute will use the mode
displayed, when last executed, before saving the query file:
1. Create a view containing the fields you want displayed in the list mode.
2. Define the query. If the selection criteria uses fields not in the view,
then they should be specified in the filter diagram.
3. Place the caret in a field in the Query window and press F8, the List
query data will be displayed.
4. Press F4, the Query window will be displayed.
5. Choose the Batch operations Auto run menu option and select the Execute
query action, then click OK.
6. Save the query file. When reloaded and executed, the query data will be
displayed in list mode. If you need to convert it back to card mode, execute
the query by pressing F1, press F4 to bring back the Query window and save
again.
6.8 Use of the Escape key for stopping query execution
------------------------------------------------------
Screenshots of the query menu and the description of the 'Stop query'
menu item in the manual do not indicate that pressing 'Escape' has the same
effect as choosing this option.
6.12 Batch update fields
------------------------
The normal SELECT-dragging operation on a boolean field causes it to change
state, e.g. from ? to tick. This can be avoided by pressing ADJUST instead
of SELECT to drag the field.
As expressions can be used in queries and calculated fields, they can also
be used in batch update fields (see pg 8.6, 8.7 for more details). For
example, if a user has a number of tables which he/she wants to increase the
price field for them, a batch update field could be defined like this:
Field New value
----- ---------
price price * (1 + 20 / 100)
System variables can also be used, for example:
Field New value
----- ---------
price price * (1 + @My$Percent_Increase / 100)
where the system variable is set like this:
*Set My$Percent_Increase 20
Note, as in calculated fields (explained in 8.7 below), the system variable
must be followed by a space (' ') before it is followed by the rest of the
expression.
If you are updating string fields or date fields, then the 'New value' must
be preceded by an '=' to imply that it must be set from an expression (which
may contain system variables or fields), rather than the explicit string.
For example, to update a field called full_name with the contents of
first_name and surname and a date field with today's date:
Field New Value
----- ---------
full_name =first_name + ' ' + surname
date =DATE TODAY
Note that the system variable definitions must include the single quotes, as
in the query selection criteria explained in 6.26 below.
6.21 Sorting string fields in queries
-------------------------------------
When dragging a string field into the sort order window, the type of sort
performed defaults to DICTIONARY instead of ASCII as indicated in the manual.
6.26 Query selection criteria
-----------------------------
Items in the boxes of the filter window can include system variables. For
example, if a teacher wants to execute a query on a 'Students' table to find
all the pupils in his/her class, then this can be achieved in a filter box
like this:
class = @My$Class
where the system variable is set in the following way:
*Set My$Class '3B'
Note that the quotes are omitted from the filter box for string fields and
are inserted in the variable. The reason for this is so that '@' characters
are not expanded if contained within quotes in the filter box, and hence can
still be searched for. This might be a problem if you want to use a variable
which is already defined for use as a default field entry, e.g. My$Initials,
which does not have quotes, hence you would need to set a second variable
for use in the query like this:
*SetMacro My$Initials_Q '<My$Initials>'
This is then effectively the same variable but contained within quotes and
would be inserted in a filter box like this:
initials = @My$Initials_Q
The system variables can also be used as part of expressions in the filter
boxes, e.g.
age < @My$Age + 3
You may even use a system variable to specify the complete query, e.g.:
@My$Query$Staff
in the filter box and could be specified by:
*Set My$Query$Staff "(department = 'Sales' OR department = 'Development')
AND area = 'Southsea'"
The maximum length of the evaluated variable must not exceed 1023
characters.
Note: system variables cannot be used in simple queries.
6.30 Combining Simple queries and Filter queries
------------------------------------------------
In querymode, when 'Show filter' is performed, any data in the fields gets
moved to boxes in the filter diagram. A complex filter diagram can be
created (e.g. relational join) in addtion to further selection criteria which
may be specified in the simple query. The resultant query is the filter
diagram ANDed with the simple query.
7.10 Graphing
-------------
1. An option to choose 'Portrait' type graph has been added to the menu in
the Graph Plotting window.
2. A menu has been added to the Graph window to allow the graph to be saved
as a drawfile or printed.
3. The manual indicates that multiple fields can be plotted but does not
accurately explain how to achieve this: if another field is dropped in the
'Plot' box, it will replace the field that is already in there. To prevent
this from happening, a comma must be manually typed in the plot box at the
end of the existing field name before dropping in the next field.
8.7 Calculated fields
---------------------
System variables can be used as part of expressions in calculated
fields, e.g.
net_price * (1 + @My$VAT )
Note that whatever follows the system variable name (in this example, a ')')
has to be separated from the variable name by a space (' ').
9.15 Editing report layouts
---------------------------
When editing report layouts, they behave differently according to the type
of default report chosen:-
Label -
A blue label grid is displayed as a guide line to show what will fit in a
label. When the number across is specified greater than 1, the column width
is fixed to the label width, rather than the furthest right hand edge of any
item in the layout. Note also, that 'Offset from margins' is switched off
because it uses the margins defined in the label definition.
Draft -
The grid locking is forced to ON and the sizes are set to X = 18 (10
characters per inch) and Y = 30 (6 lines per inch). Items added to the
report layout default to draft font (Corpus.Medium 12 point).
Dropping items in the layout
The manual indicates that when an item is dropped in, the mouse pointer
represents the position of the top left hand corner of the item. This only
applies to files dropped in; for fields and field headings, they will be
positioned as indicated by the drag box. Beware that the field will not be
dropped in unless the pointer is in the work area of the report layout
window.
X.XX Loading tables from Waiter menu commands
---------------------------------------------
The manual does not indicate how to achieve loading of tables through the
operating command line interpreter. If you want to load a table using a
Waiter menu option, or a line in an obey file, there are two utilities which
allow this to be achieved:
1) Multi-user Network tables are loaded using the following command:
SqlFiler:NetLoad <tablename>
e.g.
SqlFiler:NetLoad <SqlServer$@DSLTables>.Dave.Countries
2) Local tables are loaded using either of the following commands:
Filer_Run <tablename> (Note: RISC OS 3 ONLY)
or
Squirrel:Start <tablename>
Note that the tablenames are case sensitive
12.XX Autoaction SqlImport
--------------------------
SqlImport can run an import process automatically if the import filename is
given as a parameter when !SqlImport is run. A command (or file) can be
specified to run on completion of the import process by specifying it as the
second parameter, for example, from an obeyfile (or Waiter option):
Run adfs::4.$.Squirrel.!SqlImport adfs::4.$.Importfile adfs::4.$.Obeyfile
00000000 45 72 72 61 74 61 20 66 6f 72 20 53 71 75 69 72 |Errata for Squir|
00000010 72 65 6c 0a 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |rel.============|
00000020 3d 3d 3d 3d 3d 3d 3d 0a 0a 54 68 69 73 20 66 69 |=======..This fi|
00000030 6c 65 20 63 6f 76 65 72 73 20 64 65 74 61 69 6c |le covers detail|
00000040 73 20 77 68 69 63 68 20 77 65 72 65 20 65 72 72 |s which were err|
00000050 6f 6e 65 6f 75 73 6c 79 20 6f 6d 69 74 74 65 64 |oneously omitted|
00000060 20 6f 72 20 69 6e 63 6f 72 72 65 63 74 20 69 6e | or incorrect in|
00000070 20 74 68 65 0a 6d 61 6e 75 61 6c 20 61 74 20 74 | the.manual at t|
00000080 69 6d 65 20 6f 66 20 70 72 69 6e 74 2e 0a 0a 34 |ime of print...4|
00000090 2e 32 31 20 44 65 66 61 75 6c 74 20 66 69 65 6c |.21 Default fiel|
000000a0 64 20 65 6e 74 72 69 65 73 0a 2d 2d 2d 2d 2d 2d |d entries.------|
000000b0 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------|
000000c0 2d 2d 2d 2d 0a 0a 46 61 63 69 6c 69 74 69 65 73 |----..Facilities|
000000d0 20 75 73 69 6e 67 20 73 79 73 74 65 6d 20 76 61 | using system va|
000000e0 72 69 61 62 6c 65 73 20 68 61 76 65 20 62 65 65 |riables have bee|
000000f0 6e 20 61 64 64 65 64 20 73 69 6e 63 65 20 74 68 |n added since th|
00000100 65 20 6d 61 6e 75 61 6c 20 77 61 73 0a 70 72 69 |e manual was.pri|
00000110 6e 74 65 64 2e 20 54 68 65 79 20 65 6e 61 62 6c |nted. They enabl|
00000120 65 20 66 69 65 6c 64 73 20 61 6e 64 20 71 75 65 |e fields and que|
00000130 72 69 65 73 20 28 73 65 65 20 36 2e 32 36 20 62 |ries (see 6.26 b|
00000140 65 6c 6f 77 29 20 74 6f 20 62 65 0a 70 61 72 61 |elow) to be.para|
00000150 6d 65 74 65 72 69 73 65 64 2e 0a 0a 44 65 66 61 |meterised...Defa|
00000160 75 6c 74 20 66 69 65 6c 64 20 65 6e 74 72 69 65 |ult field entrie|
00000170 73 20 63 61 6e 20 62 65 20 64 65 66 69 6e 65 64 |s can be defined|
00000180 20 61 73 20 61 20 73 79 73 74 65 6d 20 76 61 72 | as a system var|
00000190 69 61 62 6c 65 2c 20 77 68 69 63 68 20 6d 61 79 |iable, which may|
000001a0 20 68 61 76 65 0a 62 65 65 6e 20 73 65 74 20 61 | have.been set a|
000001b0 63 63 6f 72 64 69 6e 67 20 74 6f 20 74 68 65 20 |ccording to the |
000001c0 65 6e 76 69 72 6f 6e 6d 65 6e 74 20 6f 66 20 74 |environment of t|
000001d0 68 65 20 75 73 65 72 2e 20 46 6f 72 20 65 78 61 |he user. For exa|
000001e0 6d 70 6c 65 2c 20 69 6e 20 61 0a 6d 75 6c 74 69 |mple, in a.multi|
000001f0 2d 75 73 65 72 2f 6e 65 74 77 6f 72 6b 20 65 6e |-user/network en|
00000200 76 69 72 6f 6e 6d 65 6e 74 2c 20 61 20 74 61 62 |vironment, a tab|
00000210 6c 65 20 63 6f 75 6c 64 20 68 61 76 65 20 61 20 |le could have a |
00000220 66 69 65 6c 64 20 77 68 69 63 68 20 72 65 71 75 |field which requ|
00000230 69 72 65 73 0a 74 68 65 20 75 73 65 72 27 73 20 |ires.the user's |
00000240 69 6e 69 74 69 61 6c 73 2e 20 55 73 65 72 73 20 |initials. Users |
00000250 63 61 6e 20 73 68 61 72 65 20 74 68 65 20 73 61 |can share the sa|
00000260 6d 65 20 74 61 62 6c 65 2c 20 62 75 74 20 68 61 |me table, but ha|
00000270 76 65 20 64 69 66 66 65 72 65 6e 74 0a 64 65 66 |ve different.def|
00000280 61 75 6c 74 20 65 6e 74 72 69 65 73 2c 20 73 75 |ault entries, su|
00000290 63 68 20 61 73 3a 0a 0a 2a 53 65 74 20 4d 79 24 |ch as:..*Set My$|
000002a0 49 6e 69 74 69 61 6c 73 20 44 4e 46 0a 0a 54 68 |Initials DNF..Th|
000002b0 69 73 20 63 6f 75 6c 64 20 62 65 20 73 65 74 20 |is could be set |
000002c0 61 75 74 6f 6d 61 74 69 63 61 6c 6c 79 20 61 73 |automatically as|
000002d0 20 70 61 72 74 20 6f 66 20 74 68 65 20 21 41 72 | part of the !Ar|
000002e0 6d 42 6f 6f 74 20 66 69 6c 65 20 77 68 65 6e 20 |mBoot file when |
000002f0 6c 6f 67 67 69 6e 67 20 6f 6e 0a 74 6f 20 74 68 |logging on.to th|
00000300 65 20 66 69 6c 65 20 73 65 72 76 65 72 2c 20 6f |e file server, o|
00000310 72 20 61 73 20 70 61 72 74 20 6f 66 20 74 68 65 |r as part of the|
00000320 20 21 42 6f 6f 74 20 66 69 6c 65 20 6f 66 20 74 | !Boot file of t|
00000330 68 65 20 63 6f 6d 70 75 74 65 72 2e 0a 0a 54 6f |he computer...To|
00000340 20 73 65 74 20 74 68 65 20 64 65 66 61 75 6c 74 | set the default|
00000350 20 65 6e 74 72 79 20 74 6f 20 62 65 20 61 20 73 | entry to be a s|
00000360 79 73 74 65 6d 20 76 61 72 69 61 62 6c 65 2c 20 |ystem variable, |
00000370 70 72 65 63 65 64 65 20 74 68 65 20 64 65 66 61 |precede the defa|
00000380 75 6c 74 20 65 6e 74 72 79 0a 62 79 20 61 6e 20 |ult entry.by an |
00000390 27 40 27 20 73 79 6d 62 6f 6c 2c 20 65 2e 67 2e |'@' symbol, e.g.|
000003a0 20 40 4d 79 24 49 6e 69 74 69 61 6c 73 2e 20 49 | @My$Initials. I|
000003b0 6e 20 63 72 65 61 74 65 20 74 61 62 6c 65 20 6d |n create table m|
000003c0 6f 64 65 2c 20 75 73 65 20 74 68 65 20 64 65 66 |ode, use the def|
000003d0 61 75 6c 74 0a 65 6e 74 72 79 20 6f 70 74 69 6f |ault.entry optio|
000003e0 6e 20 69 6e 20 74 68 65 20 73 75 62 2d 6d 65 6e |n in the sub-men|
000003f0 75 20 6f 66 20 74 68 65 20 56 61 6c 69 64 61 74 |u of the Validat|
00000400 69 6f 6e 20 6d 65 6e 75 20 66 6f 75 6e 64 20 69 |ion menu found i|
00000410 6e 20 74 68 65 20 46 69 65 6c 64 0a 64 65 74 61 |n the Field.deta|
00000420 69 6c 73 20 64 69 61 6c 6f 67 75 65 20 62 6f 78 |ils dialogue box|
00000430 2e 0a 0a 49 66 20 79 6f 75 20 72 65 71 75 69 72 |...If you requir|
00000440 65 20 61 20 64 65 66 61 75 6c 74 20 65 6e 74 72 |e a default entr|
00000450 79 20 74 6f 20 61 63 74 75 61 6c 6c 79 20 73 74 |y to actually st|
00000460 61 72 74 20 77 69 74 68 20 61 6e 20 27 40 27 20 |art with an '@' |
00000470 73 79 6d 62 6f 6c 2c 20 74 68 65 0a 73 79 73 74 |symbol, the.syst|
00000480 65 6d 20 76 61 72 69 61 62 6c 65 20 65 76 61 6c |em variable eval|
00000490 75 61 74 69 6f 6e 20 63 61 6e 20 62 65 20 64 69 |uation can be di|
000004a0 73 61 62 6c 65 64 20 62 79 20 70 72 65 63 65 64 |sabled by preced|
000004b0 69 6e 67 20 77 69 74 68 20 61 6e 6f 74 68 65 72 |ing with another|
000004c0 20 27 40 27 2c 0a 69 2e 65 2e 20 27 40 40 27 2e | '@',.i.e. '@@'.|
000004d0 0a 0a 54 68 65 20 6d 61 78 69 6d 75 6d 20 6c 65 |..The maximum le|
000004e0 6e 67 74 68 20 6f 66 20 74 68 65 20 65 76 61 6c |ngth of the eval|
000004f0 75 61 74 65 64 20 76 61 72 69 61 62 6c 65 20 6d |uated variable m|
00000500 75 73 74 20 6e 6f 74 20 65 78 63 65 65 64 20 32 |ust not exceed 2|
00000510 35 35 20 63 68 61 72 61 63 74 65 72 73 2c 0a 6f |55 characters,.o|
00000520 74 68 65 72 77 69 73 65 20 74 68 65 20 66 69 65 |therwise the fie|
00000530 6c 64 20 77 69 6c 6c 20 62 65 20 6c 65 66 74 20 |ld will be left |
00000540 62 6c 61 6e 6b 2e 20 49 74 20 69 73 20 61 6c 73 |blank. It is als|
00000550 6f 20 6c 65 66 74 20 62 6c 61 6e 6b 20 69 66 20 |o left blank if |
00000560 74 68 65 0a 76 61 72 69 61 62 6c 65 20 69 73 20 |the.variable is |
00000570 6e 6f 74 20 73 65 74 2e 0a 0a 35 2e 39 20 54 68 |not set...5.9 Th|
00000580 65 20 62 72 6f 77 73 65 20 74 6f 6f 6c 20 77 69 |e browse tool wi|
00000590 6e 64 6f 77 0a 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |ndow.-----------|
000005a0 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a |---------------.|
000005b0 0a 54 68 65 20 6d 61 6e 75 61 6c 20 64 6f 65 73 |.The manual does|
000005c0 20 6e 6f 74 20 69 6e 64 69 63 61 74 65 20 74 68 | not indicate th|
000005d0 61 74 20 74 68 69 73 20 77 69 6e 64 6f 77 20 63 |at this window c|
000005e0 61 6e 20 62 65 20 6d 61 64 65 20 74 6f 20 61 70 |an be made to ap|
000005f0 70 65 61 72 20 6f 72 20 6e 6f 74 0a 61 70 70 65 |pear or not.appe|
00000600 61 72 20 62 79 20 64 65 66 61 75 6c 74 20 77 68 |ar by default wh|
00000610 65 6e 20 6c 6f 61 64 69 6e 67 20 61 20 74 61 62 |en loading a tab|
00000620 6c 65 2e 20 54 68 69 73 20 63 61 6e 20 62 65 20 |le. This can be |
00000630 63 6f 6e 66 69 67 75 72 65 64 20 66 72 6f 6d 0a |configured from.|
00000640 63 72 65 61 74 65 2f 65 64 69 74 20 74 61 62 6c |create/edit tabl|
00000650 65 20 6d 6f 64 65 20 62 79 20 74 75 72 6e 69 6e |e mode by turnin|
00000660 67 20 74 68 65 20 66 69 65 6c 64 20 74 79 70 65 |g the field type|
00000670 20 74 6f 6f 6c 20 77 69 6e 64 6f 77 20 6f 6e 20 | tool window on |
00000680 6f 72 20 6f 66 66 0a 61 63 63 6f 72 64 69 6e 67 |or off.according|
00000690 20 74 6f 20 74 68 65 20 73 74 61 74 65 20 70 72 | to the state pr|
000006a0 65 66 65 72 65 64 2e 20 57 68 65 6e 20 74 68 65 |efered. When the|
000006b0 20 74 61 62 6c 65 20 69 73 20 72 65 2d 73 61 76 | table is re-sav|
000006c0 65 64 2c 20 74 68 65 20 73 74 61 74 65 20 6f 66 |ed, the state of|
000006d0 0a 74 68 65 20 74 6f 6f 6c 20 77 69 6e 64 6f 77 |.the tool window|
000006e0 20 77 69 6c 6c 20 62 65 20 72 65 6d 65 6d 62 65 | will be remembe|
000006f0 72 65 64 20 61 6e 64 20 77 69 6c 6c 20 64 69 63 |red and will dic|
00000700 74 61 74 65 20 74 68 65 20 73 74 61 74 65 20 6f |tate the state o|
00000710 66 20 74 68 65 20 62 72 6f 77 73 65 0a 74 6f 6f |f the browse.too|
00000720 6c 20 77 69 6e 64 6f 77 2e 0a 0a 35 2e 31 30 20 |l window...5.10 |
00000730 4c 69 73 74 20 6d 6f 64 65 0a 2d 2d 2d 2d 2d 2d |List mode.------|
00000740 2d 2d 2d 2d 2d 2d 2d 2d 0a 0a 54 68 65 20 6d 61 |--------..The ma|
00000750 6e 75 61 6c 20 69 73 20 69 6e 63 6f 72 72 65 63 |nual is incorrec|
00000760 74 20 61 62 6f 75 74 20 74 68 65 20 64 65 66 61 |t about the defa|
00000770 75 6c 74 20 6e 75 6d 62 65 72 20 6f 66 20 72 6f |ult number of ro|
00000780 77 73 20 62 65 69 6e 67 20 31 30 20 28 70 61 67 |ws being 10 (pag|
00000790 65 0a 35 2e 31 30 29 3a 20 69 74 20 68 61 73 20 |e.5.10): it has |
000007a0 62 65 65 6e 20 63 68 61 6e 67 65 64 20 74 6f 20 |been changed to |
000007b0 62 65 20 63 61 6c 63 75 6c 61 74 65 64 20 61 75 |be calculated au|
000007c0 74 6f 6d 61 74 69 63 61 6c 6c 79 20 74 6f 20 66 |tomatically to f|
000007d0 69 74 20 74 68 65 20 73 63 72 65 65 6e 0a 73 69 |it the screen.si|
000007e0 7a 65 2c 20 69 6e 64 69 63 61 74 65 64 20 62 79 |ze, indicated by|
000007f0 20 74 68 65 20 74 65 78 74 20 27 41 75 74 6f 27 | the text 'Auto'|
00000800 20 69 6e 20 74 68 65 20 27 4e 75 6d 62 65 72 20 | in the 'Number |
00000810 6f 66 20 72 6f 77 73 27 20 77 72 69 74 61 62 6c |of rows' writabl|
00000820 65 20 69 63 6f 6e 20 69 6e 0a 74 68 65 20 4c 69 |e icon in.the Li|
00000830 73 74 20 6d 6f 64 65 20 64 69 61 6c 6f 67 75 65 |st mode dialogue|
00000840 20 62 6f 78 2e 20 49 66 20 72 65 71 75 69 72 65 | box. If require|
00000850 64 2c 20 61 20 6e 75 6d 62 65 72 20 63 61 6e 20 |d, a number can |
00000860 62 65 20 73 70 65 63 69 66 69 65 64 20 62 79 0a |be specified by.|
00000870 64 65 6c 65 74 69 6e 67 20 74 68 65 20 27 41 75 |deleting the 'Au|
00000880 74 6f 27 20 74 65 78 74 20 66 72 6f 6d 20 74 68 |to' text from th|
00000890 69 73 20 69 63 6f 6e 2e 0a 0a 35 2e 31 33 20 54 |is icon...5.13 T|
000008a0 6f 6f 6c 20 77 69 6e 64 6f 77 20 62 72 6f 77 73 |ool window brows|
000008b0 65 20 63 6f 6e 74 72 6f 6c 20 62 75 74 74 6f 6e |e control button|
000008c0 73 20 69 6e 20 44 61 74 61 20 6d 6f 64 65 0a 2d |s in Data mode.-|
000008d0 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------|
*
00000900 2d 2d 2d 0a 0a 54 68 65 20 62 72 6f 77 73 65 20 |---..The browse |
00000910 62 75 74 74 6f 6e 73 20 69 6e 64 65 78 20 62 79 |buttons index by|
00000920 20 74 68 65 20 66 69 65 6c 64 20 63 6f 6e 74 61 | the field conta|
00000930 69 6e 69 6e 67 20 74 68 65 20 63 61 72 65 74 20 |ining the caret |
00000940 2d 20 6c 69 6b 65 20 74 68 65 20 50 41 47 45 0a |- like the PAGE.|
00000950 55 50 20 61 6e 64 20 50 41 47 45 20 44 4f 57 4e |UP and PAGE DOWN|
00000960 20 6b 65 79 73 2e 20 49 66 20 74 68 65 20 77 69 | keys. If the wi|
00000970 6e 64 6f 77 20 64 6f 65 73 20 6e 6f 74 20 63 6f |ndow does not co|
00000980 6e 74 61 69 6e 20 74 68 65 20 63 61 72 65 74 2c |ntain the caret,|
00000990 20 74 68 65 6e 20 69 74 0a 77 69 6c 6c 20 69 6e | then it.will in|
000009a0 64 65 78 20 62 79 20 74 68 65 20 66 69 72 73 74 |dex by the first|
000009b0 20 66 69 65 6c 64 2c 20 6f 72 20 74 68 65 20 6c | field, or the l|
000009c0 61 73 74 20 66 69 65 6c 64 20 74 68 61 74 20 74 |ast field that t|
000009d0 68 65 20 63 61 72 65 74 20 77 61 73 20 69 6e 20 |he caret was in |
000009e0 69 66 20 69 74 0a 69 73 20 6e 6f 74 20 69 6e 20 |if it.is not in |
000009f0 61 6e 6f 74 68 65 72 20 64 61 74 61 20 6d 6f 64 |another data mod|
00000a00 65 20 6f 72 20 71 75 65 72 79 20 6d 6f 64 65 20 |e or query mode |
00000a10 77 69 6e 64 6f 77 2e 0a 0a 35 2e 31 38 20 44 61 |window...5.18 Da|
00000a20 74 61 20 65 6e 74 72 79 20 63 6f 6d 70 61 72 69 |ta entry compari|
00000a30 6e 67 20 61 67 61 69 6e 73 74 20 76 61 6c 69 64 |ng against valid|
00000a40 61 74 69 6f 6e 20 6c 69 73 74 0a 2d 2d 2d 2d 2d |ation list.-----|
00000a50 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------|
*
00000a70 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a 0a 54 68 |------------..Th|
00000a80 65 20 6d 61 6e 75 61 6c 20 64 6f 65 73 20 6e 6f |e manual does no|
00000a90 74 20 69 6e 64 69 63 61 74 65 20 74 68 61 74 20 |t indicate that |
00000aa0 61 62 62 72 65 76 69 61 74 65 64 20 65 6e 74 72 |abbreviated entr|
00000ab0 69 65 73 20 61 72 65 20 61 63 63 65 70 74 65 64 |ies are accepted|
00000ac0 20 61 6e 64 20 74 68 65 0a 66 69 65 6c 64 20 63 | and the.field c|
00000ad0 6f 6e 74 65 6e 74 73 20 61 72 65 20 72 65 70 6c |ontents are repl|
00000ae0 61 63 65 64 20 77 69 74 68 20 74 68 65 20 6e 65 |aced with the ne|
00000af0 61 72 65 73 74 20 6d 61 74 63 68 20 69 6e 20 74 |arest match in t|
00000b00 68 65 20 76 61 6c 69 64 61 74 69 6f 6e 20 6c 69 |he validation li|
00000b10 73 74 2c 0a 66 6f 72 20 65 78 61 6d 70 6c 65 3a |st,.for example:|
00000b20 0a 0a 56 61 6c 69 64 61 74 69 6f 6e 20 6c 69 73 |..Validation lis|
00000b30 74 20 69 73 3a 0a 20 42 6c 75 65 0a 20 47 72 65 |t is:. Blue. Gre|
00000b40 65 6e 0a 20 4f 72 61 6e 67 65 0a 20 47 72 65 79 |en. Orange. Grey|
00000b50 0a 0a 49 66 20 74 68 65 20 75 73 65 72 20 65 6e |..If the user en|
00000b60 74 65 72 73 0a 20 67 72 0a 74 68 65 6e 20 74 68 |ters. gr.then th|
00000b70 69 73 20 77 69 6c 6c 20 62 65 20 72 65 70 6c 61 |is will be repla|
00000b80 63 65 64 20 62 79 0a 20 47 72 65 65 6e 0a 0a 49 |ced by. Green..I|
00000b90 66 20 27 47 72 65 65 6e 27 20 61 6e 64 20 27 47 |f 'Green' and 'G|
00000ba0 72 65 79 27 20 61 72 65 20 73 77 61 70 70 65 64 |rey' are swapped|
00000bb0 20 69 6e 20 74 68 65 20 76 61 6c 69 64 61 74 69 | in the validati|
00000bc0 6f 6e 20 6c 69 73 74 2c 20 74 68 65 6e 20 27 67 |on list, then 'g|
00000bd0 72 27 20 77 69 6c 6c 20 62 65 0a 72 65 70 6c 61 |r' will be.repla|
00000be0 63 65 64 20 62 79 20 27 47 72 65 79 27 2e 0a 0a |ced by 'Grey'...|
00000bf0 4e 6f 74 65 20 61 20 70 72 6f 62 6c 65 6d 20 69 |Note a problem i|
00000c00 6e 20 74 68 65 20 66 6f 6c 6c 6f 77 69 6e 67 20 |n the following |
00000c10 63 61 73 65 3a 0a 56 61 6c 69 64 61 74 69 6f 6e |case:.Validation|
00000c20 20 6c 69 73 74 20 69 73 20 3a 0a 20 52 6f 6f 6d | list is :. Room|
00000c30 0a 20 43 68 61 69 72 6d 61 6e 0a 20 43 68 61 69 |. Chairman. Chai|
00000c40 72 0a 20 54 61 62 6c 65 0a 0a 49 66 20 74 68 65 |r. Table..If the|
00000c50 20 75 73 65 72 20 65 6e 74 65 72 73 0a 20 43 68 | user enters. Ch|
00000c60 61 69 72 0a 74 68 65 6e 20 74 68 69 73 20 77 69 |air.then this wi|
00000c70 6c 6c 20 62 65 20 72 65 70 6c 61 63 65 64 20 62 |ll be replaced b|
00000c80 79 0a 20 43 68 61 69 72 6d 61 6e 0a 0a 54 68 65 |y. Chairman..The|
00000c90 20 73 6f 6c 75 74 69 6f 6e 20 74 6f 20 74 68 69 | solution to thi|
00000ca0 73 20 69 73 20 74 6f 20 65 6e 73 75 72 65 20 74 |s is to ensure t|
00000cb0 68 61 74 20 74 68 65 20 76 61 6c 69 64 61 74 69 |hat the validati|
00000cc0 6f 6e 20 6c 69 73 74 20 69 73 20 69 6e 0a 61 6c |on list is in.al|
00000cd0 70 68 61 62 65 74 69 63 61 6c 20 6f 72 64 65 72 |phabetical order|
00000ce0 2c 20 6f 72 20 69 66 20 74 68 69 73 20 69 73 20 |, or if this is |
00000cf0 6e 6f 74 20 64 65 73 69 72 65 64 2c 20 65 6e 73 |not desired, ens|
00000d00 75 72 65 20 74 68 61 74 20 74 68 65 20 73 68 6f |ure that the sho|
00000d10 72 74 65 72 20 77 6f 72 64 0a 69 73 20 69 6e 20 |rter word.is in |
00000d20 74 68 65 20 6c 69 73 74 20 62 65 66 6f 72 65 20 |the list before |
00000d30 74 68 65 20 6c 6f 6e 67 65 72 20 77 6f 72 64 2c |the longer word,|
00000d40 20 68 65 6e 63 65 20 74 68 65 20 66 6f 6c 6c 6f | hence the follo|
00000d50 77 69 6e 67 20 6c 69 73 74 20 77 6f 75 6c 64 20 |wing list would |
00000d60 77 6f 72 6b 0a 4f 4b 3a 0a 20 52 6f 6f 6d 0a 20 |work.OK:. Room. |
00000d70 43 68 61 69 72 0a 20 43 68 61 69 72 6d 61 6e 0a |Chair. Chairman.|
00000d80 20 54 61 62 6c 65 0a 0a 36 2e 34 20 4c 69 73 74 | Table..6.4 List|
00000d90 20 66 6f 72 6d 61 74 20 69 6e 20 71 75 65 72 79 | format in query|
00000da0 20 64 61 74 61 20 6d 6f 64 65 0a 2d 2d 2d 2d 2d | data mode.-----|
00000db0 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------|
00000dc0 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a 0a 54 |-------------..T|
00000dd0 68 65 20 6d 61 6e 75 61 6c 20 64 6f 65 73 20 6e |he manual does n|
00000de0 6f 74 20 69 6e 64 69 63 61 74 65 20 74 68 61 74 |ot indicate that|
00000df0 20 6c 69 73 74 20 6d 6f 64 65 20 69 73 20 61 76 | list mode is av|
00000e00 61 69 6c 61 62 6c 65 20 66 72 6f 6d 20 71 75 65 |ailable from que|
00000e10 72 79 20 64 61 74 61 0a 6d 6f 64 65 2c 20 69 2e |ry data.mode, i.|
00000e20 65 2e 20 77 68 65 6e 20 62 72 6f 77 73 69 6e 67 |e. when browsing|
00000e30 20 74 68 72 6f 75 67 68 20 72 65 63 6f 72 64 73 | through records|
00000e40 20 69 6e 20 61 20 71 75 65 72 79 2c 20 74 68 65 | in a query, the|
00000e50 73 65 20 63 61 6e 20 62 65 20 76 69 65 77 65 64 |se can be viewed|
00000e60 20 69 6e 0a 6c 69 73 74 20 66 6f 72 6d 61 74 20 | in.list format |
00000e70 72 61 74 68 65 72 20 74 68 61 6e 20 6a 75 73 74 |rather than just|
00000e80 20 63 61 72 64 20 66 6f 72 6d 61 74 2e 20 54 68 | card format. Th|
00000e90 65 72 65 20 69 73 20 61 6e 20 65 78 74 72 61 20 |ere is an extra |
00000ea0 6d 65 6e 75 20 6f 70 74 69 6f 6e 20 69 6e 0a 74 |menu option in.t|
00000eb0 68 65 20 27 51 75 65 72 79 20 64 61 74 61 27 20 |he 'Query data' |
00000ec0 6d 65 6e 75 20 66 6f 72 20 61 63 68 69 65 76 69 |menu for achievi|
00000ed0 6e 67 20 74 68 69 73 2e 0a 0a 41 20 71 75 65 72 |ng this...A quer|
00000ee0 79 20 63 61 6e 20 62 65 20 64 65 66 69 6e 65 64 |y can be defined|
00000ef0 20 74 6f 20 61 75 74 6f 6d 61 74 69 63 61 6c 6c | to automaticall|
00000f00 79 20 64 69 73 70 6c 61 79 20 74 68 65 20 71 75 |y display the qu|
00000f10 65 72 79 20 64 61 74 61 20 69 6e 20 6c 69 73 74 |ery data in list|
00000f20 20 6d 6f 64 65 0a 69 6e 73 74 65 61 64 20 6f 66 | mode.instead of|
00000f30 20 63 61 72 64 20 6d 6f 64 65 20 62 79 20 70 72 | card mode by pr|
00000f40 65 73 73 69 6e 67 20 46 38 20 69 6e 73 74 65 61 |essing F8 instea|
00000f50 64 20 6f 66 20 46 31 20 74 6f 20 65 78 65 63 75 |d of F1 to execu|
00000f60 74 65 20 74 68 65 20 71 75 65 72 79 2e 0a 41 75 |te the query..Au|
00000f70 74 6f 2d 72 75 6e 20 71 75 65 72 69 65 73 20 77 |to-run queries w|
00000f80 68 69 63 68 20 61 72 65 20 63 6f 6e 66 69 67 75 |hich are configu|
00000f90 72 65 64 20 74 6f 20 45 78 65 63 75 74 65 20 77 |red to Execute w|
00000fa0 69 6c 6c 20 75 73 65 20 74 68 65 20 6d 6f 64 65 |ill use the mode|
00000fb0 0a 64 69 73 70 6c 61 79 65 64 2c 20 77 68 65 6e |.displayed, when|
00000fc0 20 6c 61 73 74 20 65 78 65 63 75 74 65 64 2c 20 | last executed, |
00000fd0 62 65 66 6f 72 65 20 73 61 76 69 6e 67 20 74 68 |before saving th|
00000fe0 65 20 71 75 65 72 79 20 66 69 6c 65 3a 0a 0a 31 |e query file:..1|
00000ff0 2e 20 43 72 65 61 74 65 20 61 20 76 69 65 77 20 |. Create a view |
00001000 63 6f 6e 74 61 69 6e 69 6e 67 20 74 68 65 20 66 |containing the f|
00001010 69 65 6c 64 73 20 79 6f 75 20 77 61 6e 74 20 64 |ields you want d|
00001020 69 73 70 6c 61 79 65 64 20 69 6e 20 74 68 65 20 |isplayed in the |
00001030 6c 69 73 74 20 6d 6f 64 65 2e 0a 0a 32 2e 20 44 |list mode...2. D|
00001040 65 66 69 6e 65 20 74 68 65 20 71 75 65 72 79 2e |efine the query.|
00001050 20 49 66 20 74 68 65 20 73 65 6c 65 63 74 69 6f | If the selectio|
00001060 6e 20 63 72 69 74 65 72 69 61 20 75 73 65 73 20 |n criteria uses |
00001070 66 69 65 6c 64 73 20 6e 6f 74 20 69 6e 20 74 68 |fields not in th|
00001080 65 20 76 69 65 77 2c 0a 74 68 65 6e 20 74 68 65 |e view,.then the|
00001090 79 20 73 68 6f 75 6c 64 20 62 65 20 73 70 65 63 |y should be spec|
000010a0 69 66 69 65 64 20 69 6e 20 74 68 65 20 66 69 6c |ified in the fil|
000010b0 74 65 72 20 64 69 61 67 72 61 6d 2e 0a 0a 33 2e |ter diagram...3.|
000010c0 20 50 6c 61 63 65 20 74 68 65 20 63 61 72 65 74 | Place the caret|
000010d0 20 69 6e 20 61 20 66 69 65 6c 64 20 69 6e 20 74 | in a field in t|
000010e0 68 65 20 51 75 65 72 79 20 77 69 6e 64 6f 77 20 |he Query window |
000010f0 61 6e 64 20 70 72 65 73 73 20 46 38 2c 20 74 68 |and press F8, th|
00001100 65 20 4c 69 73 74 0a 71 75 65 72 79 20 64 61 74 |e List.query dat|
00001110 61 20 77 69 6c 6c 20 62 65 20 64 69 73 70 6c 61 |a will be displa|
00001120 79 65 64 2e 0a 0a 34 2e 20 50 72 65 73 73 20 46 |yed...4. Press F|
00001130 34 2c 20 74 68 65 20 51 75 65 72 79 20 77 69 6e |4, the Query win|
00001140 64 6f 77 20 77 69 6c 6c 20 62 65 20 64 69 73 70 |dow will be disp|
00001150 6c 61 79 65 64 2e 0a 0a 35 2e 20 43 68 6f 6f 73 |layed...5. Choos|
00001160 65 20 74 68 65 20 42 61 74 63 68 20 6f 70 65 72 |e the Batch oper|
00001170 61 74 69 6f 6e 73 20 41 75 74 6f 20 72 75 6e 20 |ations Auto run |
00001180 6d 65 6e 75 20 6f 70 74 69 6f 6e 20 61 6e 64 20 |menu option and |
00001190 73 65 6c 65 63 74 20 74 68 65 20 45 78 65 63 75 |select the Execu|
000011a0 74 65 0a 71 75 65 72 79 20 61 63 74 69 6f 6e 2c |te.query action,|
000011b0 20 74 68 65 6e 20 63 6c 69 63 6b 20 4f 4b 2e 0a | then click OK..|
000011c0 0a 36 2e 20 53 61 76 65 20 74 68 65 20 71 75 65 |.6. Save the que|
000011d0 72 79 20 66 69 6c 65 2e 20 57 68 65 6e 20 72 65 |ry file. When re|
000011e0 6c 6f 61 64 65 64 20 61 6e 64 20 65 78 65 63 75 |loaded and execu|
000011f0 74 65 64 2c 20 74 68 65 20 71 75 65 72 79 20 64 |ted, the query d|
00001200 61 74 61 20 77 69 6c 6c 20 62 65 0a 64 69 73 70 |ata will be.disp|
00001210 6c 61 79 65 64 20 69 6e 20 6c 69 73 74 20 6d 6f |layed in list mo|
00001220 64 65 2e 20 49 66 20 79 6f 75 20 6e 65 65 64 20 |de. If you need |
00001230 74 6f 20 63 6f 6e 76 65 72 74 20 69 74 20 62 61 |to convert it ba|
00001240 63 6b 20 74 6f 20 63 61 72 64 20 6d 6f 64 65 2c |ck to card mode,|
00001250 20 65 78 65 63 75 74 65 0a 74 68 65 20 71 75 65 | execute.the que|
00001260 72 79 20 62 79 20 70 72 65 73 73 69 6e 67 20 46 |ry by pressing F|
00001270 31 2c 20 70 72 65 73 73 20 46 34 20 74 6f 20 62 |1, press F4 to b|
00001280 72 69 6e 67 20 62 61 63 6b 20 74 68 65 20 51 75 |ring back the Qu|
00001290 65 72 79 20 77 69 6e 64 6f 77 20 61 6e 64 20 73 |ery window and s|
000012a0 61 76 65 0a 61 67 61 69 6e 2e 0a 0a 36 2e 38 20 |ave.again...6.8 |
000012b0 55 73 65 20 6f 66 20 74 68 65 20 45 73 63 61 70 |Use of the Escap|
000012c0 65 20 6b 65 79 20 66 6f 72 20 73 74 6f 70 70 69 |e key for stoppi|
000012d0 6e 67 20 71 75 65 72 79 20 65 78 65 63 75 74 69 |ng query executi|
000012e0 6f 6e 0a 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |on.-------------|
000012f0 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------|
*
00001310 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a 0a 53 63 72 65 65 |---------..Scree|
00001320 6e 73 68 6f 74 73 20 6f 66 20 74 68 65 20 71 75 |nshots of the qu|
00001330 65 72 79 20 6d 65 6e 75 20 61 6e 64 20 74 68 65 |ery menu and the|
00001340 20 64 65 73 63 72 69 70 74 69 6f 6e 20 6f 66 20 | description of |
00001350 74 68 65 20 27 53 74 6f 70 20 71 75 65 72 79 27 |the 'Stop query'|
00001360 0a 6d 65 6e 75 20 69 74 65 6d 20 69 6e 20 74 68 |.menu item in th|
00001370 65 20 6d 61 6e 75 61 6c 20 64 6f 20 6e 6f 74 20 |e manual do not |
00001380 69 6e 64 69 63 61 74 65 20 74 68 61 74 20 70 72 |indicate that pr|
00001390 65 73 73 69 6e 67 20 27 45 73 63 61 70 65 27 20 |essing 'Escape' |
000013a0 68 61 73 20 74 68 65 20 73 61 6d 65 0a 65 66 66 |has the same.eff|
000013b0 65 63 74 20 61 73 20 63 68 6f 6f 73 69 6e 67 20 |ect as choosing |
000013c0 74 68 69 73 20 6f 70 74 69 6f 6e 2e 0a 0a 36 2e |this option...6.|
000013d0 31 32 20 42 61 74 63 68 20 75 70 64 61 74 65 20 |12 Batch update |
000013e0 66 69 65 6c 64 73 0a 2d 2d 2d 2d 2d 2d 2d 2d 2d |fields.---------|
000013f0 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a |---------------.|
00001400 0a 54 68 65 20 6e 6f 72 6d 61 6c 20 53 45 4c 45 |.The normal SELE|
00001410 43 54 2d 64 72 61 67 67 69 6e 67 20 6f 70 65 72 |CT-dragging oper|
00001420 61 74 69 6f 6e 20 6f 6e 20 61 20 62 6f 6f 6c 65 |ation on a boole|
00001430 61 6e 20 66 69 65 6c 64 20 63 61 75 73 65 73 20 |an field causes |
00001440 69 74 20 74 6f 20 63 68 61 6e 67 65 0a 73 74 61 |it to change.sta|
00001450 74 65 2c 20 65 2e 67 2e 20 66 72 6f 6d 20 3f 20 |te, e.g. from ? |
00001460 74 6f 20 74 69 63 6b 2e 20 54 68 69 73 20 63 61 |to tick. This ca|
00001470 6e 20 62 65 20 61 76 6f 69 64 65 64 20 62 79 20 |n be avoided by |
00001480 70 72 65 73 73 69 6e 67 20 41 44 4a 55 53 54 20 |pressing ADJUST |
00001490 69 6e 73 74 65 61 64 0a 6f 66 20 53 45 4c 45 43 |instead.of SELEC|
000014a0 54 20 74 6f 20 64 72 61 67 20 74 68 65 20 66 69 |T to drag the fi|
000014b0 65 6c 64 2e 0a 0a 41 73 20 65 78 70 72 65 73 73 |eld...As express|
000014c0 69 6f 6e 73 20 63 61 6e 20 62 65 20 75 73 65 64 |ions can be used|
000014d0 20 69 6e 20 71 75 65 72 69 65 73 20 61 6e 64 20 | in queries and |
000014e0 63 61 6c 63 75 6c 61 74 65 64 20 66 69 65 6c 64 |calculated field|
000014f0 73 2c 20 74 68 65 79 20 63 61 6e 20 61 6c 73 6f |s, they can also|
00001500 0a 62 65 20 75 73 65 64 20 69 6e 20 62 61 74 63 |.be used in batc|
00001510 68 20 75 70 64 61 74 65 20 66 69 65 6c 64 73 20 |h update fields |
00001520 28 73 65 65 20 70 67 20 38 2e 36 2c 20 38 2e 37 |(see pg 8.6, 8.7|
00001530 20 66 6f 72 20 6d 6f 72 65 20 64 65 74 61 69 6c | for more detail|
00001540 73 29 2e 20 46 6f 72 0a 65 78 61 6d 70 6c 65 2c |s). For.example,|
00001550 20 69 66 20 61 20 75 73 65 72 20 68 61 73 20 61 | if a user has a|
00001560 20 6e 75 6d 62 65 72 20 6f 66 20 74 61 62 6c 65 | number of table|
00001570 73 20 77 68 69 63 68 20 68 65 2f 73 68 65 20 77 |s which he/she w|
00001580 61 6e 74 73 20 74 6f 20 69 6e 63 72 65 61 73 65 |ants to increase|
00001590 20 74 68 65 0a 70 72 69 63 65 20 66 69 65 6c 64 | the.price field|
000015a0 20 66 6f 72 20 74 68 65 6d 2c 20 61 20 62 61 74 | for them, a bat|
000015b0 63 68 20 75 70 64 61 74 65 20 66 69 65 6c 64 20 |ch update field |
000015c0 63 6f 75 6c 64 20 62 65 20 64 65 66 69 6e 65 64 |could be defined|
000015d0 20 6c 69 6b 65 20 74 68 69 73 3a 0a 0a 46 69 65 | like this:..Fie|
000015e0 6c 64 20 4e 65 77 20 76 61 6c 75 65 0a 2d 2d 2d |ld New value.---|
000015f0 2d 2d 20 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a 70 72 69 |-- ---------.pri|
00001600 63 65 20 70 72 69 63 65 20 2a 20 28 31 20 2b 20 |ce price * (1 + |
00001610 32 30 20 2f 20 31 30 30 29 0a 0a 53 79 73 74 65 |20 / 100)..Syste|
00001620 6d 20 76 61 72 69 61 62 6c 65 73 20 63 61 6e 20 |m variables can |
00001630 61 6c 73 6f 20 62 65 20 75 73 65 64 2c 20 66 6f |also be used, fo|
00001640 72 20 65 78 61 6d 70 6c 65 3a 0a 0a 46 69 65 6c |r example:..Fiel|
00001650 64 20 4e 65 77 20 76 61 6c 75 65 0a 2d 2d 2d 2d |d New value.----|
00001660 2d 20 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a 70 72 69 63 |- ---------.pric|
00001670 65 20 70 72 69 63 65 20 2a 20 28 31 20 2b 20 40 |e price * (1 + @|
00001680 4d 79 24 50 65 72 63 65 6e 74 5f 49 6e 63 72 65 |My$Percent_Incre|
00001690 61 73 65 20 2f 20 31 30 30 29 0a 0a 77 68 65 72 |ase / 100)..wher|
000016a0 65 20 74 68 65 20 73 79 73 74 65 6d 20 76 61 72 |e the system var|
000016b0 69 61 62 6c 65 20 69 73 20 73 65 74 20 6c 69 6b |iable is set lik|
000016c0 65 20 74 68 69 73 3a 0a 0a 2a 53 65 74 20 4d 79 |e this:..*Set My|
000016d0 24 50 65 72 63 65 6e 74 5f 49 6e 63 72 65 61 73 |$Percent_Increas|
000016e0 65 20 32 30 0a 0a 4e 6f 74 65 2c 20 61 73 20 69 |e 20..Note, as i|
000016f0 6e 20 63 61 6c 63 75 6c 61 74 65 64 20 66 69 65 |n calculated fie|
00001700 6c 64 73 20 28 65 78 70 6c 61 69 6e 65 64 20 69 |lds (explained i|
00001710 6e 20 38 2e 37 20 62 65 6c 6f 77 29 2c 20 74 68 |n 8.7 below), th|
00001720 65 20 73 79 73 74 65 6d 20 76 61 72 69 61 62 6c |e system variabl|
00001730 65 0a 6d 75 73 74 20 62 65 20 66 6f 6c 6c 6f 77 |e.must be follow|
00001740 65 64 20 62 79 20 61 20 73 70 61 63 65 20 28 27 |ed by a space ('|
00001750 20 27 29 20 62 65 66 6f 72 65 20 69 74 20 69 73 | ') before it is|
00001760 20 66 6f 6c 6c 6f 77 65 64 20 62 79 20 74 68 65 | followed by the|
00001770 20 72 65 73 74 20 6f 66 20 74 68 65 0a 65 78 70 | rest of the.exp|
00001780 72 65 73 73 69 6f 6e 2e 0a 0a 49 66 20 79 6f 75 |ression...If you|
00001790 20 61 72 65 20 75 70 64 61 74 69 6e 67 20 73 74 | are updating st|
000017a0 72 69 6e 67 20 66 69 65 6c 64 73 20 6f 72 20 64 |ring fields or d|
000017b0 61 74 65 20 66 69 65 6c 64 73 2c 20 74 68 65 6e |ate fields, then|
000017c0 20 74 68 65 20 27 4e 65 77 20 76 61 6c 75 65 27 | the 'New value'|
000017d0 20 6d 75 73 74 0a 62 65 20 70 72 65 63 65 64 65 | must.be precede|
000017e0 64 20 62 79 20 61 6e 20 27 3d 27 20 74 6f 20 69 |d by an '=' to i|
000017f0 6d 70 6c 79 20 74 68 61 74 20 69 74 20 6d 75 73 |mply that it mus|
00001800 74 20 62 65 20 73 65 74 20 66 72 6f 6d 20 61 6e |t be set from an|
00001810 20 65 78 70 72 65 73 73 69 6f 6e 20 28 77 68 69 | expression (whi|
00001820 63 68 0a 6d 61 79 20 63 6f 6e 74 61 69 6e 20 73 |ch.may contain s|
00001830 79 73 74 65 6d 20 76 61 72 69 61 62 6c 65 73 20 |ystem variables |
00001840 6f 72 20 66 69 65 6c 64 73 29 2c 20 72 61 74 68 |or fields), rath|
00001850 65 72 20 74 68 61 6e 20 74 68 65 20 65 78 70 6c |er than the expl|
00001860 69 63 69 74 20 73 74 72 69 6e 67 2e 0a 0a 46 6f |icit string...Fo|
00001870 72 20 65 78 61 6d 70 6c 65 2c 20 74 6f 20 75 70 |r example, to up|
00001880 64 61 74 65 20 61 20 66 69 65 6c 64 20 63 61 6c |date a field cal|
00001890 6c 65 64 20 66 75 6c 6c 5f 6e 61 6d 65 20 77 69 |led full_name wi|
000018a0 74 68 20 74 68 65 20 63 6f 6e 74 65 6e 74 73 20 |th the contents |
000018b0 6f 66 0a 66 69 72 73 74 5f 6e 61 6d 65 20 61 6e |of.first_name an|
000018c0 64 20 73 75 72 6e 61 6d 65 20 61 6e 64 20 61 20 |d surname and a |
000018d0 64 61 74 65 20 66 69 65 6c 64 20 77 69 74 68 20 |date field with |
000018e0 74 6f 64 61 79 27 73 20 64 61 74 65 3a 0a 0a 46 |today's date:..F|
000018f0 69 65 6c 64 20 20 20 20 20 4e 65 77 20 56 61 6c |ield New Val|
00001900 75 65 0a 2d 2d 2d 2d 2d 20 20 20 20 20 2d 2d 2d |ue.----- ---|
00001910 2d 2d 2d 2d 2d 2d 0a 66 75 6c 6c 5f 6e 61 6d 65 |------.full_name|
00001920 20 3d 66 69 72 73 74 5f 6e 61 6d 65 20 2b 20 27 | =first_name + '|
00001930 20 27 20 2b 20 73 75 72 6e 61 6d 65 0a 64 61 74 | ' + surname.dat|
00001940 65 20 20 20 20 20 20 3d 44 41 54 45 20 54 4f 44 |e =DATE TOD|
00001950 41 59 0a 0a 4e 6f 74 65 20 74 68 61 74 20 74 68 |AY..Note that th|
00001960 65 20 73 79 73 74 65 6d 20 76 61 72 69 61 62 6c |e system variabl|
00001970 65 20 64 65 66 69 6e 69 74 69 6f 6e 73 20 6d 75 |e definitions mu|
00001980 73 74 20 69 6e 63 6c 75 64 65 20 74 68 65 20 73 |st include the s|
00001990 69 6e 67 6c 65 20 71 75 6f 74 65 73 2c 20 61 73 |ingle quotes, as|
000019a0 0a 69 6e 20 74 68 65 20 71 75 65 72 79 20 73 65 |.in the query se|
000019b0 6c 65 63 74 69 6f 6e 20 63 72 69 74 65 72 69 61 |lection criteria|
000019c0 20 65 78 70 6c 61 69 6e 65 64 20 69 6e 20 36 2e | explained in 6.|
000019d0 32 36 20 62 65 6c 6f 77 2e 0a 0a 36 2e 32 31 20 |26 below...6.21 |
000019e0 53 6f 72 74 69 6e 67 20 73 74 72 69 6e 67 20 66 |Sorting string f|
000019f0 69 65 6c 64 73 20 69 6e 20 71 75 65 72 69 65 73 |ields in queries|
00001a00 0a 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |.---------------|
00001a10 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------|
00001a20 2d 2d 2d 2d 2d 2d 0a 0a 57 68 65 6e 20 64 72 61 |------..When dra|
00001a30 67 67 69 6e 67 20 61 20 73 74 72 69 6e 67 20 66 |gging a string f|
00001a40 69 65 6c 64 20 69 6e 74 6f 20 74 68 65 20 73 6f |ield into the so|
00001a50 72 74 20 6f 72 64 65 72 20 77 69 6e 64 6f 77 2c |rt order window,|
00001a60 20 74 68 65 20 74 79 70 65 20 6f 66 20 73 6f 72 | the type of sor|
00001a70 74 0a 70 65 72 66 6f 72 6d 65 64 20 64 65 66 61 |t.performed defa|
00001a80 75 6c 74 73 20 74 6f 20 44 49 43 54 49 4f 4e 41 |ults to DICTIONA|
00001a90 52 59 20 69 6e 73 74 65 61 64 20 6f 66 20 41 53 |RY instead of AS|
00001aa0 43 49 49 20 61 73 20 69 6e 64 69 63 61 74 65 64 |CII as indicated|
00001ab0 20 69 6e 20 74 68 65 20 6d 61 6e 75 61 6c 2e 0a | in the manual..|
00001ac0 0a 36 2e 32 36 20 51 75 65 72 79 20 73 65 6c 65 |.6.26 Query sele|
00001ad0 63 74 69 6f 6e 20 63 72 69 74 65 72 69 61 0a 2d |ction criteria.-|
00001ae0 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------|
00001af0 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a 0a 49 74 |------------..It|
00001b00 65 6d 73 20 69 6e 20 74 68 65 20 62 6f 78 65 73 |ems in the boxes|
00001b10 20 6f 66 20 74 68 65 20 66 69 6c 74 65 72 20 77 | of the filter w|
00001b20 69 6e 64 6f 77 20 63 61 6e 20 69 6e 63 6c 75 64 |indow can includ|
00001b30 65 20 73 79 73 74 65 6d 20 76 61 72 69 61 62 6c |e system variabl|
00001b40 65 73 2e 20 46 6f 72 0a 65 78 61 6d 70 6c 65 2c |es. For.example,|
00001b50 20 69 66 20 61 20 74 65 61 63 68 65 72 20 77 61 | if a teacher wa|
00001b60 6e 74 73 20 74 6f 20 65 78 65 63 75 74 65 20 61 |nts to execute a|
00001b70 20 71 75 65 72 79 20 6f 6e 20 61 20 27 53 74 75 | query on a 'Stu|
00001b80 64 65 6e 74 73 27 20 74 61 62 6c 65 20 74 6f 20 |dents' table to |
00001b90 66 69 6e 64 0a 61 6c 6c 20 74 68 65 20 70 75 70 |find.all the pup|
00001ba0 69 6c 73 20 69 6e 20 68 69 73 2f 68 65 72 20 63 |ils in his/her c|
00001bb0 6c 61 73 73 2c 20 74 68 65 6e 20 74 68 69 73 20 |lass, then this |
00001bc0 63 61 6e 20 62 65 20 61 63 68 69 65 76 65 64 20 |can be achieved |
00001bd0 69 6e 20 61 20 66 69 6c 74 65 72 20 62 6f 78 0a |in a filter box.|
00001be0 6c 69 6b 65 20 74 68 69 73 3a 0a 0a 63 6c 61 73 |like this:..clas|
00001bf0 73 20 3d 20 40 4d 79 24 43 6c 61 73 73 0a 0a 77 |s = @My$Class..w|
00001c00 68 65 72 65 20 74 68 65 20 73 79 73 74 65 6d 20 |here the system |
00001c10 76 61 72 69 61 62 6c 65 20 69 73 20 73 65 74 20 |variable is set |
00001c20 69 6e 20 74 68 65 20 66 6f 6c 6c 6f 77 69 6e 67 |in the following|
00001c30 20 77 61 79 3a 0a 0a 2a 53 65 74 20 4d 79 24 43 | way:..*Set My$C|
00001c40 6c 61 73 73 20 27 33 42 27 0a 0a 4e 6f 74 65 20 |lass '3B'..Note |
00001c50 74 68 61 74 20 74 68 65 20 71 75 6f 74 65 73 20 |that the quotes |
00001c60 61 72 65 20 6f 6d 69 74 74 65 64 20 66 72 6f 6d |are omitted from|
00001c70 20 74 68 65 20 66 69 6c 74 65 72 20 62 6f 78 20 | the filter box |
00001c80 66 6f 72 20 73 74 72 69 6e 67 20 66 69 65 6c 64 |for string field|
00001c90 73 20 61 6e 64 0a 61 72 65 20 69 6e 73 65 72 74 |s and.are insert|
00001ca0 65 64 20 69 6e 20 74 68 65 20 76 61 72 69 61 62 |ed in the variab|
00001cb0 6c 65 2e 20 54 68 65 20 72 65 61 73 6f 6e 20 66 |le. The reason f|
00001cc0 6f 72 20 74 68 69 73 20 69 73 20 73 6f 20 74 68 |or this is so th|
00001cd0 61 74 20 27 40 27 20 63 68 61 72 61 63 74 65 72 |at '@' character|
00001ce0 73 0a 61 72 65 20 6e 6f 74 20 65 78 70 61 6e 64 |s.are not expand|
00001cf0 65 64 20 69 66 20 63 6f 6e 74 61 69 6e 65 64 20 |ed if contained |
00001d00 77 69 74 68 69 6e 20 71 75 6f 74 65 73 20 69 6e |within quotes in|
00001d10 20 74 68 65 20 66 69 6c 74 65 72 20 62 6f 78 2c | the filter box,|
00001d20 20 61 6e 64 20 68 65 6e 63 65 20 63 61 6e 0a 73 | and hence can.s|
00001d30 74 69 6c 6c 20 62 65 20 73 65 61 72 63 68 65 64 |till be searched|
00001d40 20 66 6f 72 2e 20 54 68 69 73 20 6d 69 67 68 74 | for. This might|
00001d50 20 62 65 20 61 20 70 72 6f 62 6c 65 6d 20 69 66 | be a problem if|
00001d60 20 79 6f 75 20 77 61 6e 74 20 74 6f 20 75 73 65 | you want to use|
00001d70 20 61 20 76 61 72 69 61 62 6c 65 0a 77 68 69 63 | a variable.whic|
00001d80 68 20 69 73 20 61 6c 72 65 61 64 79 20 64 65 66 |h is already def|
00001d90 69 6e 65 64 20 66 6f 72 20 75 73 65 20 61 73 20 |ined for use as |
00001da0 61 20 64 65 66 61 75 6c 74 20 66 69 65 6c 64 20 |a default field |
00001db0 65 6e 74 72 79 2c 20 65 2e 67 2e 20 4d 79 24 49 |entry, e.g. My$I|
00001dc0 6e 69 74 69 61 6c 73 2c 0a 77 68 69 63 68 20 64 |nitials,.which d|
00001dd0 6f 65 73 20 6e 6f 74 20 68 61 76 65 20 71 75 6f |oes not have quo|
00001de0 74 65 73 2c 20 68 65 6e 63 65 20 79 6f 75 20 77 |tes, hence you w|
00001df0 6f 75 6c 64 20 6e 65 65 64 20 74 6f 20 73 65 74 |ould need to set|
00001e00 20 61 20 73 65 63 6f 6e 64 20 76 61 72 69 61 62 | a second variab|
00001e10 6c 65 0a 66 6f 72 20 75 73 65 20 69 6e 20 74 68 |le.for use in th|
00001e20 65 20 71 75 65 72 79 20 6c 69 6b 65 20 74 68 69 |e query like thi|
00001e30 73 3a 0a 0a 2a 53 65 74 4d 61 63 72 6f 20 4d 79 |s:..*SetMacro My|
00001e40 24 49 6e 69 74 69 61 6c 73 5f 51 20 27 3c 4d 79 |$Initials_Q '<My|
00001e50 24 49 6e 69 74 69 61 6c 73 3e 27 0a 0a 54 68 69 |$Initials>'..Thi|
00001e60 73 20 69 73 20 74 68 65 6e 20 65 66 66 65 63 74 |s is then effect|
00001e70 69 76 65 6c 79 20 74 68 65 20 73 61 6d 65 20 76 |ively the same v|
00001e80 61 72 69 61 62 6c 65 20 62 75 74 20 63 6f 6e 74 |ariable but cont|
00001e90 61 69 6e 65 64 20 77 69 74 68 69 6e 20 71 75 6f |ained within quo|
00001ea0 74 65 73 20 61 6e 64 0a 77 6f 75 6c 64 20 62 65 |tes and.would be|
00001eb0 20 69 6e 73 65 72 74 65 64 20 69 6e 20 61 20 66 | inserted in a f|
00001ec0 69 6c 74 65 72 20 62 6f 78 20 6c 69 6b 65 20 74 |ilter box like t|
00001ed0 68 69 73 3a 0a 0a 69 6e 69 74 69 61 6c 73 20 3d |his:..initials =|
00001ee0 20 40 4d 79 24 49 6e 69 74 69 61 6c 73 5f 51 0a | @My$Initials_Q.|
00001ef0 0a 54 68 65 20 73 79 73 74 65 6d 20 76 61 72 69 |.The system vari|
00001f00 61 62 6c 65 73 20 63 61 6e 20 61 6c 73 6f 20 62 |ables can also b|
00001f10 65 20 75 73 65 64 20 61 73 20 70 61 72 74 20 6f |e used as part o|
00001f20 66 20 65 78 70 72 65 73 73 69 6f 6e 73 20 69 6e |f expressions in|
00001f30 20 74 68 65 20 66 69 6c 74 65 72 0a 62 6f 78 65 | the filter.boxe|
00001f40 73 2c 20 65 2e 67 2e 0a 0a 61 67 65 20 3c 20 40 |s, e.g...age < @|
00001f50 4d 79 24 41 67 65 20 2b 20 33 0a 0a 59 6f 75 20 |My$Age + 3..You |
00001f60 6d 61 79 20 65 76 65 6e 20 75 73 65 20 61 20 73 |may even use a s|
00001f70 79 73 74 65 6d 20 76 61 72 69 61 62 6c 65 20 74 |ystem variable t|
00001f80 6f 20 73 70 65 63 69 66 79 20 74 68 65 20 63 6f |o specify the co|
00001f90 6d 70 6c 65 74 65 20 71 75 65 72 79 2c 20 65 2e |mplete query, e.|
00001fa0 67 2e 3a 0a 0a 40 4d 79 24 51 75 65 72 79 24 53 |g.:..@My$Query$S|
00001fb0 74 61 66 66 0a 0a 69 6e 20 74 68 65 20 66 69 6c |taff..in the fil|
00001fc0 74 65 72 20 62 6f 78 20 61 6e 64 20 63 6f 75 6c |ter box and coul|
00001fd0 64 20 62 65 20 73 70 65 63 69 66 69 65 64 20 62 |d be specified b|
00001fe0 79 3a 0a 0a 2a 53 65 74 20 4d 79 24 51 75 65 72 |y:..*Set My$Quer|
00001ff0 79 24 53 74 61 66 66 20 22 28 64 65 70 61 72 74 |y$Staff "(depart|
00002000 6d 65 6e 74 20 3d 20 27 53 61 6c 65 73 27 20 4f |ment = 'Sales' O|
00002010 52 20 64 65 70 61 72 74 6d 65 6e 74 20 3d 20 27 |R department = '|
00002020 44 65 76 65 6c 6f 70 6d 65 6e 74 27 29 0a 41 4e |Development').AN|
00002030 44 20 61 72 65 61 20 3d 20 27 53 6f 75 74 68 73 |D area = 'Souths|
00002040 65 61 27 22 0a 0a 54 68 65 20 6d 61 78 69 6d 75 |ea'"..The maximu|
00002050 6d 20 6c 65 6e 67 74 68 20 6f 66 20 74 68 65 20 |m length of the |
00002060 65 76 61 6c 75 61 74 65 64 20 76 61 72 69 61 62 |evaluated variab|
00002070 6c 65 20 6d 75 73 74 20 6e 6f 74 20 65 78 63 65 |le must not exce|
00002080 65 64 20 31 30 32 33 0a 63 68 61 72 61 63 74 65 |ed 1023.characte|
00002090 72 73 2e 0a 0a 4e 6f 74 65 3a 20 73 79 73 74 65 |rs...Note: syste|
000020a0 6d 20 76 61 72 69 61 62 6c 65 73 20 63 61 6e 6e |m variables cann|
000020b0 6f 74 20 62 65 20 75 73 65 64 20 69 6e 20 73 69 |ot be used in si|
000020c0 6d 70 6c 65 20 71 75 65 72 69 65 73 2e 0a 0a 36 |mple queries...6|
000020d0 2e 33 30 20 43 6f 6d 62 69 6e 69 6e 67 20 53 69 |.30 Combining Si|
000020e0 6d 70 6c 65 20 71 75 65 72 69 65 73 20 61 6e 64 |mple queries and|
000020f0 20 46 69 6c 74 65 72 20 71 75 65 72 69 65 73 0a | Filter queries.|
00002100 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------|
*
00002130 0a 0a 49 6e 20 71 75 65 72 79 6d 6f 64 65 2c 20 |..In querymode, |
00002140 77 68 65 6e 20 27 53 68 6f 77 20 66 69 6c 74 65 |when 'Show filte|
00002150 72 27 20 69 73 20 70 65 72 66 6f 72 6d 65 64 2c |r' is performed,|
00002160 20 61 6e 79 20 64 61 74 61 20 69 6e 20 74 68 65 | any data in the|
00002170 20 66 69 65 6c 64 73 20 67 65 74 73 0a 6d 6f 76 | fields gets.mov|
00002180 65 64 20 74 6f 20 62 6f 78 65 73 20 69 6e 20 74 |ed to boxes in t|
00002190 68 65 20 66 69 6c 74 65 72 20 64 69 61 67 72 61 |he filter diagra|
000021a0 6d 2e 20 41 20 63 6f 6d 70 6c 65 78 20 66 69 6c |m. A complex fil|
000021b0 74 65 72 20 64 69 61 67 72 61 6d 20 63 61 6e 20 |ter diagram can |
000021c0 62 65 0a 63 72 65 61 74 65 64 20 28 65 2e 67 2e |be.created (e.g.|
000021d0 20 72 65 6c 61 74 69 6f 6e 61 6c 20 6a 6f 69 6e | relational join|
000021e0 29 20 69 6e 20 61 64 64 74 69 6f 6e 20 74 6f 20 |) in addtion to |
000021f0 66 75 72 74 68 65 72 20 73 65 6c 65 63 74 69 6f |further selectio|
00002200 6e 20 63 72 69 74 65 72 69 61 20 77 68 69 63 68 |n criteria which|
00002210 0a 6d 61 79 20 62 65 20 73 70 65 63 69 66 69 65 |.may be specifie|
00002220 64 20 69 6e 20 74 68 65 20 73 69 6d 70 6c 65 20 |d in the simple |
00002230 71 75 65 72 79 2e 20 54 68 65 20 72 65 73 75 6c |query. The resul|
00002240 74 61 6e 74 20 71 75 65 72 79 20 69 73 20 74 68 |tant query is th|
00002250 65 20 66 69 6c 74 65 72 0a 64 69 61 67 72 61 6d |e filter.diagram|
00002260 20 41 4e 44 65 64 20 77 69 74 68 20 74 68 65 20 | ANDed with the |
00002270 73 69 6d 70 6c 65 20 71 75 65 72 79 2e 0a 0a 37 |simple query...7|
00002280 2e 31 30 20 47 72 61 70 68 69 6e 67 0a 2d 2d 2d |.10 Graphing.---|
00002290 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a 0a 31 2e 20 41 |----------..1. A|
000022a0 6e 20 6f 70 74 69 6f 6e 20 74 6f 20 63 68 6f 6f |n option to choo|
000022b0 73 65 20 27 50 6f 72 74 72 61 69 74 27 20 74 79 |se 'Portrait' ty|
000022c0 70 65 20 67 72 61 70 68 20 68 61 73 20 62 65 65 |pe graph has bee|
000022d0 6e 20 61 64 64 65 64 20 74 6f 20 74 68 65 20 6d |n added to the m|
000022e0 65 6e 75 20 69 6e 0a 74 68 65 20 47 72 61 70 68 |enu in.the Graph|
000022f0 20 50 6c 6f 74 74 69 6e 67 20 77 69 6e 64 6f 77 | Plotting window|
00002300 2e 0a 0a 32 2e 20 41 20 6d 65 6e 75 20 68 61 73 |...2. A menu has|
00002310 20 62 65 65 6e 20 61 64 64 65 64 20 74 6f 20 74 | been added to t|
00002320 68 65 20 47 72 61 70 68 20 77 69 6e 64 6f 77 20 |he Graph window |
00002330 74 6f 20 61 6c 6c 6f 77 20 74 68 65 20 67 72 61 |to allow the gra|
00002340 70 68 20 74 6f 20 62 65 20 73 61 76 65 64 0a 61 |ph to be saved.a|
00002350 73 20 61 20 64 72 61 77 66 69 6c 65 20 6f 72 20 |s a drawfile or |
00002360 70 72 69 6e 74 65 64 2e 0a 0a 33 2e 20 54 68 65 |printed...3. The|
00002370 20 6d 61 6e 75 61 6c 20 69 6e 64 69 63 61 74 65 | manual indicate|
00002380 73 20 74 68 61 74 20 6d 75 6c 74 69 70 6c 65 20 |s that multiple |
00002390 66 69 65 6c 64 73 20 63 61 6e 20 62 65 20 70 6c |fields can be pl|
000023a0 6f 74 74 65 64 20 62 75 74 20 64 6f 65 73 20 6e |otted but does n|
000023b0 6f 74 0a 61 63 63 75 72 61 74 65 6c 79 20 65 78 |ot.accurately ex|
000023c0 70 6c 61 69 6e 20 68 6f 77 20 74 6f 20 61 63 68 |plain how to ach|
000023d0 69 65 76 65 20 74 68 69 73 3a 20 69 66 20 61 6e |ieve this: if an|
000023e0 6f 74 68 65 72 20 66 69 65 6c 64 20 69 73 20 64 |other field is d|
000023f0 72 6f 70 70 65 64 20 69 6e 20 74 68 65 0a 27 50 |ropped in the.'P|
00002400 6c 6f 74 27 20 62 6f 78 2c 20 69 74 20 77 69 6c |lot' box, it wil|
00002410 6c 20 72 65 70 6c 61 63 65 20 74 68 65 20 66 69 |l replace the fi|
00002420 65 6c 64 20 74 68 61 74 20 69 73 20 61 6c 72 65 |eld that is alre|
00002430 61 64 79 20 69 6e 20 74 68 65 72 65 2e 20 54 6f |ady in there. To|
00002440 20 70 72 65 76 65 6e 74 0a 74 68 69 73 20 66 72 | prevent.this fr|
00002450 6f 6d 20 68 61 70 70 65 6e 69 6e 67 2c 20 61 20 |om happening, a |
00002460 63 6f 6d 6d 61 20 6d 75 73 74 20 62 65 20 6d 61 |comma must be ma|
00002470 6e 75 61 6c 6c 79 20 74 79 70 65 64 20 69 6e 20 |nually typed in |
00002480 74 68 65 20 70 6c 6f 74 20 62 6f 78 20 61 74 20 |the plot box at |
00002490 74 68 65 0a 65 6e 64 20 6f 66 20 74 68 65 20 65 |the.end of the e|
000024a0 78 69 73 74 69 6e 67 20 66 69 65 6c 64 20 6e 61 |xisting field na|
000024b0 6d 65 20 62 65 66 6f 72 65 20 64 72 6f 70 70 69 |me before droppi|
000024c0 6e 67 20 69 6e 20 74 68 65 20 6e 65 78 74 20 66 |ng in the next f|
000024d0 69 65 6c 64 2e 0a 0a 38 2e 37 20 43 61 6c 63 75 |ield...8.7 Calcu|
000024e0 6c 61 74 65 64 20 66 69 65 6c 64 73 0a 2d 2d 2d |lated fields.---|
000024f0 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------|
00002500 2d 2d 0a 0a 53 79 73 74 65 6d 20 76 61 72 69 61 |--..System varia|
00002510 62 6c 65 73 20 63 61 6e 20 62 65 20 75 73 65 64 |bles can be used|
00002520 20 61 73 20 70 61 72 74 20 6f 66 20 65 78 70 72 | as part of expr|
00002530 65 73 73 69 6f 6e 73 20 69 6e 20 63 61 6c 63 75 |essions in calcu|
00002540 6c 61 74 65 64 0a 66 69 65 6c 64 73 2c 20 65 2e |lated.fields, e.|
00002550 67 2e 0a 0a 6e 65 74 5f 70 72 69 63 65 20 2a 20 |g...net_price * |
00002560 28 31 20 2b 20 40 4d 79 24 56 41 54 20 29 0a 0a |(1 + @My$VAT )..|
00002570 4e 6f 74 65 20 74 68 61 74 20 77 68 61 74 65 76 |Note that whatev|
00002580 65 72 20 66 6f 6c 6c 6f 77 73 20 74 68 65 20 73 |er follows the s|
00002590 79 73 74 65 6d 20 76 61 72 69 61 62 6c 65 20 6e |ystem variable n|
000025a0 61 6d 65 20 28 69 6e 20 74 68 69 73 20 65 78 61 |ame (in this exa|
000025b0 6d 70 6c 65 2c 20 61 20 27 29 27 29 0a 68 61 73 |mple, a ')').has|
000025c0 20 74 6f 20 62 65 20 73 65 70 61 72 61 74 65 64 | to be separated|
000025d0 20 66 72 6f 6d 20 74 68 65 20 76 61 72 69 61 62 | from the variab|
000025e0 6c 65 20 6e 61 6d 65 20 62 79 20 61 20 73 70 61 |le name by a spa|
000025f0 63 65 20 28 27 20 27 29 2e 0a 0a 39 2e 31 35 20 |ce (' ')...9.15 |
00002600 45 64 69 74 69 6e 67 20 72 65 70 6f 72 74 20 6c |Editing report l|
00002610 61 79 6f 75 74 73 0a 2d 2d 2d 2d 2d 2d 2d 2d 2d |ayouts.---------|
00002620 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------|
00002630 2d 2d 0a 0a 57 68 65 6e 20 65 64 69 74 69 6e 67 |--..When editing|
00002640 20 72 65 70 6f 72 74 20 6c 61 79 6f 75 74 73 2c | report layouts,|
00002650 20 74 68 65 79 20 62 65 68 61 76 65 20 64 69 66 | they behave dif|
00002660 66 65 72 65 6e 74 6c 79 20 61 63 63 6f 72 64 69 |ferently accordi|
00002670 6e 67 20 74 6f 20 74 68 65 20 74 79 70 65 0a 6f |ng to the type.o|
00002680 66 20 64 65 66 61 75 6c 74 20 72 65 70 6f 72 74 |f default report|
00002690 20 63 68 6f 73 65 6e 3a 2d 0a 0a 4c 61 62 65 6c | chosen:-..Label|
000026a0 20 2d 0a 0a 41 20 62 6c 75 65 20 6c 61 62 65 6c | -..A blue label|
000026b0 20 67 72 69 64 20 69 73 20 64 69 73 70 6c 61 79 | grid is display|
000026c0 65 64 20 61 73 20 61 20 67 75 69 64 65 20 6c 69 |ed as a guide li|
000026d0 6e 65 20 74 6f 20 73 68 6f 77 20 77 68 61 74 20 |ne to show what |
000026e0 77 69 6c 6c 20 66 69 74 20 69 6e 20 61 0a 6c 61 |will fit in a.la|
000026f0 62 65 6c 2e 20 57 68 65 6e 20 74 68 65 20 6e 75 |bel. When the nu|
00002700 6d 62 65 72 20 61 63 72 6f 73 73 20 69 73 20 73 |mber across is s|
00002710 70 65 63 69 66 69 65 64 20 67 72 65 61 74 65 72 |pecified greater|
00002720 20 74 68 61 6e 20 31 2c 20 74 68 65 20 63 6f 6c | than 1, the col|
00002730 75 6d 6e 20 77 69 64 74 68 0a 69 73 20 66 69 78 |umn width.is fix|
00002740 65 64 20 74 6f 20 74 68 65 20 6c 61 62 65 6c 20 |ed to the label |
00002750 77 69 64 74 68 2c 20 72 61 74 68 65 72 20 74 68 |width, rather th|
00002760 61 6e 20 74 68 65 20 66 75 72 74 68 65 73 74 20 |an the furthest |
00002770 72 69 67 68 74 20 68 61 6e 64 20 65 64 67 65 20 |right hand edge |
00002780 6f 66 20 61 6e 79 0a 69 74 65 6d 20 69 6e 20 74 |of any.item in t|
00002790 68 65 20 6c 61 79 6f 75 74 2e 20 4e 6f 74 65 20 |he layout. Note |
000027a0 61 6c 73 6f 2c 20 74 68 61 74 20 27 4f 66 66 73 |also, that 'Offs|
000027b0 65 74 20 66 72 6f 6d 20 6d 61 72 67 69 6e 73 27 |et from margins'|
000027c0 20 69 73 20 73 77 69 74 63 68 65 64 20 6f 66 66 | is switched off|
000027d0 0a 62 65 63 61 75 73 65 20 69 74 20 75 73 65 73 |.because it uses|
000027e0 20 74 68 65 20 6d 61 72 67 69 6e 73 20 64 65 66 | the margins def|
000027f0 69 6e 65 64 20 69 6e 20 74 68 65 20 6c 61 62 65 |ined in the labe|
00002800 6c 20 64 65 66 69 6e 69 74 69 6f 6e 2e 0a 0a 44 |l definition...D|
00002810 72 61 66 74 20 2d 0a 0a 54 68 65 20 67 72 69 64 |raft -..The grid|
00002820 20 6c 6f 63 6b 69 6e 67 20 69 73 20 66 6f 72 63 | locking is forc|
00002830 65 64 20 74 6f 20 4f 4e 20 61 6e 64 20 74 68 65 |ed to ON and the|
00002840 20 73 69 7a 65 73 20 61 72 65 20 73 65 74 20 74 | sizes are set t|
00002850 6f 20 58 20 3d 20 31 38 20 28 31 30 0a 63 68 61 |o X = 18 (10.cha|
00002860 72 61 63 74 65 72 73 20 70 65 72 20 69 6e 63 68 |racters per inch|
00002870 29 20 61 6e 64 20 59 20 3d 20 33 30 20 28 36 20 |) and Y = 30 (6 |
00002880 6c 69 6e 65 73 20 70 65 72 20 69 6e 63 68 29 2e |lines per inch).|
00002890 20 49 74 65 6d 73 20 61 64 64 65 64 20 74 6f 20 | Items added to |
000028a0 74 68 65 0a 72 65 70 6f 72 74 20 6c 61 79 6f 75 |the.report layou|
000028b0 74 20 64 65 66 61 75 6c 74 20 74 6f 20 64 72 61 |t default to dra|
000028c0 66 74 20 66 6f 6e 74 20 28 43 6f 72 70 75 73 2e |ft font (Corpus.|
000028d0 4d 65 64 69 75 6d 20 31 32 20 70 6f 69 6e 74 29 |Medium 12 point)|
000028e0 2e 0a 0a 44 72 6f 70 70 69 6e 67 20 69 74 65 6d |...Dropping item|
000028f0 73 20 69 6e 20 74 68 65 20 6c 61 79 6f 75 74 0a |s in the layout.|
00002900 0a 54 68 65 20 6d 61 6e 75 61 6c 20 69 6e 64 69 |.The manual indi|
00002910 63 61 74 65 73 20 74 68 61 74 20 77 68 65 6e 20 |cates that when |
00002920 61 6e 20 69 74 65 6d 20 69 73 20 64 72 6f 70 70 |an item is dropp|
00002930 65 64 20 69 6e 2c 20 74 68 65 20 6d 6f 75 73 65 |ed in, the mouse|
00002940 20 70 6f 69 6e 74 65 72 0a 72 65 70 72 65 73 65 | pointer.represe|
00002950 6e 74 73 20 74 68 65 20 70 6f 73 69 74 69 6f 6e |nts the position|
00002960 20 6f 66 20 74 68 65 20 74 6f 70 20 6c 65 66 74 | of the top left|
00002970 20 68 61 6e 64 20 63 6f 72 6e 65 72 20 6f 66 20 | hand corner of |
00002980 74 68 65 20 69 74 65 6d 2e 20 54 68 69 73 20 6f |the item. This o|
00002990 6e 6c 79 0a 61 70 70 6c 69 65 73 20 74 6f 20 66 |nly.applies to f|
000029a0 69 6c 65 73 20 64 72 6f 70 70 65 64 20 69 6e 3b |iles dropped in;|
000029b0 20 66 6f 72 20 66 69 65 6c 64 73 20 61 6e 64 20 | for fields and |
000029c0 66 69 65 6c 64 20 68 65 61 64 69 6e 67 73 2c 20 |field headings, |
000029d0 74 68 65 79 20 77 69 6c 6c 20 62 65 0a 70 6f 73 |they will be.pos|
000029e0 69 74 69 6f 6e 65 64 20 61 73 20 69 6e 64 69 63 |itioned as indic|
000029f0 61 74 65 64 20 62 79 20 74 68 65 20 64 72 61 67 |ated by the drag|
00002a00 20 62 6f 78 2e 20 42 65 77 61 72 65 20 74 68 61 | box. Beware tha|
00002a10 74 20 74 68 65 20 66 69 65 6c 64 20 77 69 6c 6c |t the field will|
00002a20 20 6e 6f 74 20 62 65 0a 64 72 6f 70 70 65 64 20 | not be.dropped |
00002a30 69 6e 20 75 6e 6c 65 73 73 20 74 68 65 20 70 6f |in unless the po|
00002a40 69 6e 74 65 72 20 69 73 20 69 6e 20 74 68 65 20 |inter is in the |
00002a50 77 6f 72 6b 20 61 72 65 61 20 6f 66 20 74 68 65 |work area of the|
00002a60 20 72 65 70 6f 72 74 20 6c 61 79 6f 75 74 0a 77 | report layout.w|
00002a70 69 6e 64 6f 77 2e 0a 0a 58 2e 58 58 20 4c 6f 61 |indow...X.XX Loa|
00002a80 64 69 6e 67 20 74 61 62 6c 65 73 20 66 72 6f 6d |ding tables from|
00002a90 20 57 61 69 74 65 72 20 6d 65 6e 75 20 63 6f 6d | Waiter menu com|
00002aa0 6d 61 6e 64 73 0a 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |mands.----------|
00002ab0 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------|
*
00002ad0 2d 2d 2d 0a 0a 54 68 65 20 6d 61 6e 75 61 6c 20 |---..The manual |
00002ae0 64 6f 65 73 20 6e 6f 74 20 69 6e 64 69 63 61 74 |does not indicat|
00002af0 65 20 68 6f 77 20 74 6f 20 61 63 68 69 65 76 65 |e how to achieve|
00002b00 20 6c 6f 61 64 69 6e 67 20 6f 66 20 74 61 62 6c | loading of tabl|
00002b10 65 73 20 74 68 72 6f 75 67 68 20 74 68 65 0a 6f |es through the.o|
00002b20 70 65 72 61 74 69 6e 67 20 63 6f 6d 6d 61 6e 64 |perating command|
00002b30 20 6c 69 6e 65 20 69 6e 74 65 72 70 72 65 74 65 | line interprete|
00002b40 72 2e 20 49 66 20 79 6f 75 20 77 61 6e 74 20 74 |r. If you want t|
00002b50 6f 20 6c 6f 61 64 20 61 20 74 61 62 6c 65 20 75 |o load a table u|
00002b60 73 69 6e 67 20 61 0a 57 61 69 74 65 72 20 6d 65 |sing a.Waiter me|
00002b70 6e 75 20 6f 70 74 69 6f 6e 2c 20 6f 72 20 61 20 |nu option, or a |
00002b80 6c 69 6e 65 20 69 6e 20 61 6e 20 6f 62 65 79 20 |line in an obey |
00002b90 66 69 6c 65 2c 20 74 68 65 72 65 20 61 72 65 20 |file, there are |
00002ba0 74 77 6f 20 75 74 69 6c 69 74 69 65 73 20 77 68 |two utilities wh|
00002bb0 69 63 68 0a 61 6c 6c 6f 77 20 74 68 69 73 20 74 |ich.allow this t|
00002bc0 6f 20 62 65 20 61 63 68 69 65 76 65 64 3a 0a 0a |o be achieved:..|
00002bd0 31 29 20 4d 75 6c 74 69 2d 75 73 65 72 20 4e 65 |1) Multi-user Ne|
00002be0 74 77 6f 72 6b 20 74 61 62 6c 65 73 20 61 72 65 |twork tables are|
00002bf0 20 6c 6f 61 64 65 64 20 75 73 69 6e 67 20 74 68 | loaded using th|
00002c00 65 20 66 6f 6c 6c 6f 77 69 6e 67 20 63 6f 6d 6d |e following comm|
00002c10 61 6e 64 3a 0a 0a 53 71 6c 46 69 6c 65 72 3a 4e |and:..SqlFiler:N|
00002c20 65 74 4c 6f 61 64 20 3c 74 61 62 6c 65 6e 61 6d |etLoad <tablenam|
00002c30 65 3e 0a 0a 65 2e 67 2e 0a 0a 53 71 6c 46 69 6c |e>..e.g...SqlFil|
00002c40 65 72 3a 4e 65 74 4c 6f 61 64 20 3c 53 71 6c 53 |er:NetLoad <SqlS|
00002c50 65 72 76 65 72 24 40 44 53 4c 54 61 62 6c 65 73 |erver$@DSLTables|
00002c60 3e 2e 44 61 76 65 2e 43 6f 75 6e 74 72 69 65 73 |>.Dave.Countries|
00002c70 0a 0a 32 29 20 4c 6f 63 61 6c 20 74 61 62 6c 65 |..2) Local table|
00002c80 73 20 61 72 65 20 6c 6f 61 64 65 64 20 75 73 69 |s are loaded usi|
00002c90 6e 67 20 65 69 74 68 65 72 20 6f 66 20 74 68 65 |ng either of the|
00002ca0 20 66 6f 6c 6c 6f 77 69 6e 67 20 63 6f 6d 6d 61 | following comma|
00002cb0 6e 64 73 3a 0a 0a 46 69 6c 65 72 5f 52 75 6e 20 |nds:..Filer_Run |
00002cc0 3c 74 61 62 6c 65 6e 61 6d 65 3e 20 28 4e 6f 74 |<tablename> (Not|
00002cd0 65 3a 20 52 49 53 43 20 4f 53 20 33 20 4f 4e 4c |e: RISC OS 3 ONL|
00002ce0 59 29 0a 0a 6f 72 0a 0a 53 71 75 69 72 72 65 6c |Y)..or..Squirrel|
00002cf0 3a 53 74 61 72 74 20 3c 74 61 62 6c 65 6e 61 6d |:Start <tablenam|
00002d00 65 3e 0a 0a 4e 6f 74 65 20 74 68 61 74 20 74 68 |e>..Note that th|
00002d10 65 20 74 61 62 6c 65 6e 61 6d 65 73 20 61 72 65 |e tablenames are|
00002d20 20 63 61 73 65 20 73 65 6e 73 69 74 69 76 65 0a | case sensitive.|
00002d30 0a 31 32 2e 58 58 20 41 75 74 6f 61 63 74 69 6f |.12.XX Autoactio|
00002d40 6e 20 53 71 6c 49 6d 70 6f 72 74 0a 2d 2d 2d 2d |n SqlImport.----|
00002d50 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------|
00002d60 2d 2d 2d 2d 2d 2d 0a 0a 53 71 6c 49 6d 70 6f 72 |------..SqlImpor|
00002d70 74 20 63 61 6e 20 72 75 6e 20 61 6e 20 69 6d 70 |t can run an imp|
00002d80 6f 72 74 20 70 72 6f 63 65 73 73 20 61 75 74 6f |ort process auto|
00002d90 6d 61 74 69 63 61 6c 6c 79 20 69 66 20 74 68 65 |matically if the|
00002da0 20 69 6d 70 6f 72 74 20 66 69 6c 65 6e 61 6d 65 | import filename|
00002db0 20 69 73 0a 67 69 76 65 6e 20 61 73 20 61 20 70 | is.given as a p|
00002dc0 61 72 61 6d 65 74 65 72 20 77 68 65 6e 20 21 53 |arameter when !S|
00002dd0 71 6c 49 6d 70 6f 72 74 20 69 73 20 72 75 6e 2e |qlImport is run.|
00002de0 20 41 20 63 6f 6d 6d 61 6e 64 20 28 6f 72 20 66 | A command (or f|
00002df0 69 6c 65 29 20 63 61 6e 20 62 65 0a 73 70 65 63 |ile) can be.spec|
00002e00 69 66 69 65 64 20 74 6f 20 72 75 6e 20 6f 6e 20 |ified to run on |
00002e10 63 6f 6d 70 6c 65 74 69 6f 6e 20 6f 66 20 74 68 |completion of th|
00002e20 65 20 69 6d 70 6f 72 74 20 70 72 6f 63 65 73 73 |e import process|
00002e30 20 62 79 20 73 70 65 63 69 66 79 69 6e 67 20 69 | by specifying i|
00002e40 74 20 61 73 20 74 68 65 0a 73 65 63 6f 6e 64 20 |t as the.second |
00002e50 70 61 72 61 6d 65 74 65 72 2c 20 66 6f 72 20 65 |parameter, for e|
00002e60 78 61 6d 70 6c 65 2c 20 66 72 6f 6d 20 61 6e 20 |xample, from an |
00002e70 6f 62 65 79 66 69 6c 65 20 28 6f 72 20 57 61 69 |obeyfile (or Wai|
00002e80 74 65 72 20 6f 70 74 69 6f 6e 29 3a 0a 0a 52 75 |ter option):..Ru|
00002e90 6e 20 61 64 66 73 3a 3a 34 2e 24 2e 53 71 75 69 |n adfs::4.$.Squi|
00002ea0 72 72 65 6c 2e 21 53 71 6c 49 6d 70 6f 72 74 20 |rrel.!SqlImport |
00002eb0 61 64 66 73 3a 3a 34 2e 24 2e 49 6d 70 6f 72 74 |adfs::4.$.Import|
00002ec0 66 69 6c 65 20 61 64 66 73 3a 3a 34 2e 24 2e 4f |file adfs::4.$.O|
00002ed0 62 65 79 66 69 6c 65 0a |beyfile.|
00002ed8 
.