Home » Archimedes archive » Archimedes World » AW-1994-04-Disc2.adf » Disk2Apr94 » !AWApr94/Goodies/PowerBase/PBaseDoc/MailMerge
!AWApr94/Goodies/PowerBase/PBaseDoc/MailMerge
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/MailMerge |
| Read OK: | ✔ |
| File size: | 2554 bytes |
| Load address: | 0000 |
| Exec address: | 0000 |
File contents
Mail-merging with Impression and Related Matters
================================================
Powerbase is capable of performing direct mail-merging with Impression, the
document-processor marketed by Computer Concepts. Performing this task
involves the use of a module called ImpulseII which Computer Concepts have
placed in the public domain to encourage its adoption as a standard means of
transferring data between RISC OS applications. The ImpulseII module is
included in the !System application on the Powerbase distribution disc.
How to merge Powerbase data into an Impression document
=======================================================
Although we have called this file 'MailMerge' the process to be described is
more accurately termed "data-merge" since it is by no means limited to
merging names and addresses into letters: any kind of textual data from a
Powerbase application can be merged into any kind of Impression document.
Preparing the Impression document
---------------------------------
It is probably best to create the document without worrying about the merged
data at first, then insert the necessary commands afterwards.
Wherever you want data from a Powerbase record to appear in the document
proceed as folllows:-
(1) Place the caret at the point where the data is to be inserted.
(2) Click MENU over the frame, go to the 'Misc' submenu and choose 'Merge
command...'. A dialogue box will appear.
(3) Type the following:-
:Powerbase GetField NAME
This is on the understanding that your Powerbase record contains a field
whose tag is NAME and that you want the contents of that field inserting
into the Impression document at that point. Note the spaces and the initial
colon. These are essential.
(4) Click on 'Set' or type RETURN. You will see "<Merge>" appear in the
text.
(5) Repeat for all the other Powerbase fields to be inserted in the
document. All take the form :Powerbase GetField <tag>. All the data in a
given document must come from the same database. It might be easiest if
you open the required database and arrange the desktop so that you can
see both the record window and the Impression document. Clicking MENU
over a field makes its tag appear in the second menu item.
(6) Save the the document!
When you look at the document there is nothing to distinguish one merge
command from another; they all appear as "<Merge>". To check up on what a
command actually looks like open up the 'Merge command' dialogue box again
and place the caret at the beginning of the merge command, i.e. immediately
before the initial "<". The text of the command will then appear in the
writable icon of the dialogue box.
Merging the data
----------------
(1) Make sure Impression has been "seen" by the filer. Impression doesn't
need to actually be on the icon-bar at this point but it doesn't matter
if it is.
(2) Open the Powerbase database.
(3) Drop the Impression document on the record window. If Impression isn't
already running Powerbase will run it for you. Assuming that the
document isn't loaded already it will be loaded and displayed. Finally
Powerbase's 'Data merge' dialogue box will appear. (If the document is
already loaded Impression will print a message informing you of this.
When you click on 'OK' the 'Data merge' box appears and you should then
display the Impression document with 'New view'.)
(4) The 'Data merge' window has a writable icon in which you may enter a
search formula (see '!Tutorial' and 'Print'). Clicking on 'Merge' or
typing RETURN then extracts data from the first matching record and
inserts it in the specified places in the Impression document. If no
search formula was entered the merged record will be the first.
(5) Buttons are provided for "next", "previous", "first" and "last" record.
These work just like the corresponding keypad buttons and the Impression
document displays the merged data in each case.
(6) Clicking on 'Print' will print the Impression document in its displayed
state, i.e. with the currently merged data. If you select the 'Print
all' switch then click on 'Merge' a whole series of hard copies will be
produced, one for each matching record.
(7) Note that when the mouse pointer is moved over the Impression document
it changes to a large red and blue cross which means that you cannot
edit the document. Clicking SELECT over it has no effect; the caret
doesn't appear. If you click on 'Cancel' in the dialogue box (or close
it by clicking on its 'Close' icon) the merged data is removed from the
document and normal editing is restored.
Mail-merging with other applications
====================================
Powerbase is able to mail-merge directly with Impression only because both
programs support Impulse commands. Most other DTP programs and word-
processors do not recognize such commands and mail-merging with them is
usually accomplished via a CSV (comma separated values) or similar file.
You will need to read the wordprocessor manual to find out precisely what
format the file should have and also the Powerbase documentation on CSV
files. It should be possible to create a file in whatever format is
required.
Powerbase as an 'Impulse' server
================================
The following is a description of the Impulse "methods" understood by
Powerbase, given in the standard format recommended by Computer Concepts.
{powerbase Methods:
GetPathname
Selection <string>
ParseQuery <string>
GetField <tag>
GetRecord
PutFile
ExpandCode <string>
GetExpanded <string>
Descriptions:
GetPathname
Specifies an 'object' i.e. a Powerbase database. If Powerbase has the
required database open it replies with the full pathname of the object,
otherwise it returns an error message. Example of use:
:Powerbase.!Elements GetPathname (returns pathname of !Elements)
R6 points to pathname when calling task is decoding reply.
Selection <string>
Tells Powerbase about a field, or group of fields, in which the caller is
interested. The fields are specified as a list of tags, separated by any
suitable character (e.g. / or ,). The same separator must appear at the very
end of the tag-list. Powerbase replies with the maximum data-length of the
combined fields in the selection. Example of use:
:Powerbase Selection NAME/SYM/Z/
R6 points to a string which gives data-length.
ParseQuery <string>
Informs Powerbase of the criteria to be used in selecting records to
transmit to the caller. The parameter is a standard Powerbase search
formula and Powerbase replies with the title which would normally appear
at the head of one of its printed lists. Example of use:
:Powerbase ParseQuery TYPE=T
R6 points to returned title.
GetField <tag>
Requests from Powerbase the data in the specified field of the next record
which matches the preceding ParseQuery command.
When Powerbase replies to the GetField command the calling task should
respond with an ImpulseFetchData, specifying the address and length of the
buffer to be used, and then wait for an Impulse_receive event (reason code
&204) before reading the buffer.
GetRecord [<key>]
Sent without a key it requests from Powerbase the next record which matches
the preceding ParseQuery command. If the primary key of a record in the
database is appended then Powerbase will return the record corresponding to
that key. The key must be separated from the GetRecord by a space.
The calling task must follow the procedure described above for GetField.
Powerbase will transmit the fields specified in the Selection command, using
the same separator as was used in that command. Receipt of data may be
followed by another GetRecord command, returning the next matching record
and so on, a zero-length response signifying that there are no more
matching records. If using keys to request specific records you should end
by sending *** as a key to tell Powerbase that the dialogue is finished.
This command and the one below operate only on Subfile 0 of the Powerbase
database.
PutRecord
Informs Powerbase that the caller wishes to write a record to the current
Powerbase database. It should be sent as message type &200. A Selection
command should have been previously sent to tell Powerbase what fields to
expect and what separator is to be used. Powerbase will then reply with a
GetRecord command (reason code &201) which the caller should acknowledge
with message type &202, specifying the maximum length of the data which will
be sent. Wait for event &203 which is a request by Powerbase for the caller
to transmit the data. The caller should then do so with ImpulseTransmitData,
specifying the buffer address and the length of data being sent. This may be
immediately followed by another PutRecord.
ExpandCode <string>
Requests the expanded form of a code used in a field linked to a validation
table. The parameter string consists of the code itself, then a space,
then the name of the validation table with the column number appended.
Example of use:
:Powerbase ExpandCode T Group0
GetExpanded <string>
Combines the functions of GetField and ExpandCode, i.e. it requests the
expanded form of the contents of a specified field. The parameter string is
similar to that for ExpandCode, except that the field tag is substituted for
the code.
Example of use:
:Powerbase GetExpanded GP Group0
}
00000000 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
00000010 4d 61 69 6c 2d 6d 65 72 67 69 6e 67 20 77 69 74 |Mail-merging wit|
00000020 68 20 49 6d 70 72 65 73 73 69 6f 6e 20 61 6e 64 |h Impression and|
00000030 20 52 65 6c 61 74 65 64 20 4d 61 74 74 65 72 73 | Related Matters|
00000040 0a 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 |. |
00000050 20 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d | ===============|
00000060 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |================|
*
00000080 3d 0a 0a 50 6f 77 65 72 62 61 73 65 20 69 73 20 |=..Powerbase is |
00000090 63 61 70 61 62 6c 65 20 6f 66 20 70 65 72 66 6f |capable of perfo|
000000a0 72 6d 69 6e 67 20 64 69 72 65 63 74 20 6d 61 69 |rming direct mai|
000000b0 6c 2d 6d 65 72 67 69 6e 67 20 77 69 74 68 20 49 |l-merging with I|
000000c0 6d 70 72 65 73 73 69 6f 6e 2c 20 74 68 65 0a 64 |mpression, the.d|
000000d0 6f 63 75 6d 65 6e 74 2d 70 72 6f 63 65 73 73 6f |ocument-processo|
000000e0 72 20 6d 61 72 6b 65 74 65 64 20 62 79 20 43 6f |r marketed by Co|
000000f0 6d 70 75 74 65 72 20 43 6f 6e 63 65 70 74 73 2e |mputer Concepts.|
00000100 20 50 65 72 66 6f 72 6d 69 6e 67 20 74 68 69 73 | Performing this|
00000110 20 74 61 73 6b 0a 69 6e 76 6f 6c 76 65 73 20 74 | task.involves t|
00000120 68 65 20 75 73 65 20 6f 66 20 61 20 6d 6f 64 75 |he use of a modu|
00000130 6c 65 20 63 61 6c 6c 65 64 20 49 6d 70 75 6c 73 |le called Impuls|
00000140 65 49 49 20 77 68 69 63 68 20 43 6f 6d 70 75 74 |eII which Comput|
00000150 65 72 20 43 6f 6e 63 65 70 74 73 20 68 61 76 65 |er Concepts have|
00000160 0a 70 6c 61 63 65 64 20 69 6e 20 74 68 65 20 70 |.placed in the p|
00000170 75 62 6c 69 63 20 64 6f 6d 61 69 6e 20 74 6f 20 |ublic domain to |
00000180 65 6e 63 6f 75 72 61 67 65 20 69 74 73 20 61 64 |encourage its ad|
00000190 6f 70 74 69 6f 6e 20 61 73 20 61 20 73 74 61 6e |option as a stan|
000001a0 64 61 72 64 20 6d 65 61 6e 73 20 6f 66 0a 74 72 |dard means of.tr|
000001b0 61 6e 73 66 65 72 72 69 6e 67 20 64 61 74 61 20 |ansferring data |
000001c0 62 65 74 77 65 65 6e 20 52 49 53 43 20 4f 53 20 |between RISC OS |
000001d0 61 70 70 6c 69 63 61 74 69 6f 6e 73 2e 20 54 68 |applications. Th|
000001e0 65 20 49 6d 70 75 6c 73 65 49 49 20 6d 6f 64 75 |e ImpulseII modu|
000001f0 6c 65 20 69 73 0a 69 6e 63 6c 75 64 65 64 20 69 |le is.included i|
00000200 6e 20 74 68 65 20 21 53 79 73 74 65 6d 20 61 70 |n the !System ap|
00000210 70 6c 69 63 61 74 69 6f 6e 20 6f 6e 20 74 68 65 |plication on the|
00000220 20 50 6f 77 65 72 62 61 73 65 20 64 69 73 74 72 | Powerbase distr|
00000230 69 62 75 74 69 6f 6e 20 64 69 73 63 2e 0a 0a 48 |ibution disc...H|
00000240 6f 77 20 74 6f 20 6d 65 72 67 65 20 50 6f 77 65 |ow to merge Powe|
00000250 72 62 61 73 65 20 64 61 74 61 20 69 6e 74 6f 20 |rbase data into |
00000260 61 6e 20 49 6d 70 72 65 73 73 69 6f 6e 20 64 6f |an Impression do|
00000270 63 75 6d 65 6e 74 0a 3d 3d 3d 3d 3d 3d 3d 3d 3d |cument.=========|
00000280 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |================|
*
000002a0 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 0a 41 |==============.A|
000002b0 6c 74 68 6f 75 67 68 20 77 65 20 68 61 76 65 20 |lthough we have |
000002c0 63 61 6c 6c 65 64 20 74 68 69 73 20 66 69 6c 65 |called this file|
000002d0 20 27 4d 61 69 6c 4d 65 72 67 65 27 20 74 68 65 | 'MailMerge' the|
000002e0 20 70 72 6f 63 65 73 73 20 74 6f 20 62 65 20 64 | process to be d|
000002f0 65 73 63 72 69 62 65 64 20 69 73 0a 6d 6f 72 65 |escribed is.more|
00000300 20 61 63 63 75 72 61 74 65 6c 79 20 74 65 72 6d | accurately term|
00000310 65 64 20 22 64 61 74 61 2d 6d 65 72 67 65 22 20 |ed "data-merge" |
00000320 73 69 6e 63 65 20 69 74 20 69 73 20 62 79 20 6e |since it is by n|
00000330 6f 20 6d 65 61 6e 73 20 6c 69 6d 69 74 65 64 20 |o means limited |
00000340 74 6f 0a 6d 65 72 67 69 6e 67 20 6e 61 6d 65 73 |to.merging names|
00000350 20 61 6e 64 20 61 64 64 72 65 73 73 65 73 20 69 | and addresses i|
00000360 6e 74 6f 20 6c 65 74 74 65 72 73 3a 20 61 6e 79 |nto letters: any|
00000370 20 6b 69 6e 64 20 6f 66 20 74 65 78 74 75 61 6c | kind of textual|
00000380 20 64 61 74 61 20 66 72 6f 6d 20 61 0a 50 6f 77 | data from a.Pow|
00000390 65 72 62 61 73 65 20 61 70 70 6c 69 63 61 74 69 |erbase applicati|
000003a0 6f 6e 20 63 61 6e 20 62 65 20 6d 65 72 67 65 64 |on can be merged|
000003b0 20 69 6e 74 6f 20 61 6e 79 20 6b 69 6e 64 20 6f | into any kind o|
000003c0 66 20 49 6d 70 72 65 73 73 69 6f 6e 20 64 6f 63 |f Impression doc|
000003d0 75 6d 65 6e 74 2e 0a 0a 50 72 65 70 61 72 69 6e |ument...Preparin|
000003e0 67 20 74 68 65 20 49 6d 70 72 65 73 73 69 6f 6e |g the Impression|
000003f0 20 64 6f 63 75 6d 65 6e 74 0a 2d 2d 2d 2d 2d 2d | document.------|
00000400 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d |----------------|
00000410 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 0a 49 74 20 69 |-----------.It i|
00000420 73 20 70 72 6f 62 61 62 6c 79 20 62 65 73 74 20 |s probably best |
00000430 74 6f 20 63 72 65 61 74 65 20 74 68 65 20 64 6f |to create the do|
00000440 63 75 6d 65 6e 74 20 77 69 74 68 6f 75 74 20 77 |cument without w|
00000450 6f 72 72 79 69 6e 67 20 61 62 6f 75 74 20 74 68 |orrying about th|
00000460 65 20 6d 65 72 67 65 64 0a 64 61 74 61 20 61 74 |e merged.data at|
00000470 20 66 69 72 73 74 2c 20 74 68 65 6e 20 69 6e 73 | first, then ins|
00000480 65 72 74 20 74 68 65 20 6e 65 63 65 73 73 61 72 |ert the necessar|
00000490 79 20 63 6f 6d 6d 61 6e 64 73 20 61 66 74 65 72 |y commands after|
000004a0 77 61 72 64 73 2e 20 0a 0a 57 68 65 72 65 76 65 |wards. ..Whereve|
000004b0 72 20 79 6f 75 20 77 61 6e 74 20 64 61 74 61 20 |r you want data |
000004c0 66 72 6f 6d 20 61 20 50 6f 77 65 72 62 61 73 65 |from a Powerbase|
000004d0 20 72 65 63 6f 72 64 20 74 6f 20 61 70 70 65 61 | record to appea|
000004e0 72 20 69 6e 20 74 68 65 20 64 6f 63 75 6d 65 6e |r in the documen|
000004f0 74 0a 70 72 6f 63 65 65 64 20 61 73 20 66 6f 6c |t.proceed as fol|
00000500 6c 6c 6f 77 73 3a 2d 0a 0a 28 31 29 20 50 6c 61 |llows:-..(1) Pla|
00000510 63 65 20 74 68 65 20 63 61 72 65 74 20 61 74 20 |ce the caret at |
00000520 74 68 65 20 70 6f 69 6e 74 20 77 68 65 72 65 20 |the point where |
00000530 74 68 65 20 64 61 74 61 20 69 73 20 74 6f 20 62 |the data is to b|
00000540 65 20 69 6e 73 65 72 74 65 64 2e 0a 0a 28 32 29 |e inserted...(2)|
00000550 20 43 6c 69 63 6b 20 4d 45 4e 55 20 6f 76 65 72 | Click MENU over|
00000560 20 74 68 65 20 66 72 61 6d 65 2c 20 67 6f 20 74 | the frame, go t|
00000570 6f 20 74 68 65 20 27 4d 69 73 63 27 20 73 75 62 |o the 'Misc' sub|
00000580 6d 65 6e 75 20 61 6e 64 20 63 68 6f 6f 73 65 20 |menu and choose |
00000590 27 4d 65 72 67 65 0a 63 6f 6d 6d 61 6e 64 2e 2e |'Merge.command..|
000005a0 2e 27 2e 20 41 20 64 69 61 6c 6f 67 75 65 20 62 |.'. A dialogue b|
000005b0 6f 78 20 77 69 6c 6c 20 61 70 70 65 61 72 2e 0a |ox will appear..|
000005c0 0a 28 33 29 20 54 79 70 65 20 74 68 65 20 66 6f |.(3) Type the fo|
000005d0 6c 6c 6f 77 69 6e 67 3a 2d 0a 0a 20 20 20 20 20 |llowing:-.. |
000005e0 20 20 20 20 20 20 20 20 20 20 20 3a 50 6f 77 65 | :Powe|
000005f0 72 62 61 73 65 20 47 65 74 46 69 65 6c 64 20 4e |rbase GetField N|
00000600 41 4d 45 0a 0a 54 68 69 73 20 69 73 20 6f 6e 20 |AME..This is on |
00000610 74 68 65 20 75 6e 64 65 72 73 74 61 6e 64 69 6e |the understandin|
00000620 67 20 74 68 61 74 20 79 6f 75 72 20 50 6f 77 65 |g that your Powe|
00000630 72 62 61 73 65 20 72 65 63 6f 72 64 20 63 6f 6e |rbase record con|
00000640 74 61 69 6e 73 20 61 20 66 69 65 6c 64 0a 77 68 |tains a field.wh|
00000650 6f 73 65 20 74 61 67 20 69 73 20 4e 41 4d 45 20 |ose tag is NAME |
00000660 61 6e 64 20 74 68 61 74 20 79 6f 75 20 77 61 6e |and that you wan|
00000670 74 20 74 68 65 20 63 6f 6e 74 65 6e 74 73 20 6f |t the contents o|
00000680 66 20 74 68 61 74 20 66 69 65 6c 64 20 69 6e 73 |f that field ins|
00000690 65 72 74 69 6e 67 0a 69 6e 74 6f 20 74 68 65 20 |erting.into the |
000006a0 49 6d 70 72 65 73 73 69 6f 6e 20 64 6f 63 75 6d |Impression docum|
000006b0 65 6e 74 20 61 74 20 74 68 61 74 20 70 6f 69 6e |ent at that poin|
000006c0 74 2e 20 4e 6f 74 65 20 74 68 65 20 73 70 61 63 |t. Note the spac|
000006d0 65 73 20 61 6e 64 20 74 68 65 20 69 6e 69 74 69 |es and the initi|
000006e0 61 6c 0a 63 6f 6c 6f 6e 2e 20 54 68 65 73 65 20 |al.colon. These |
000006f0 61 72 65 20 65 73 73 65 6e 74 69 61 6c 2e 0a 0a |are essential...|
00000700 28 34 29 20 43 6c 69 63 6b 20 6f 6e 20 27 53 65 |(4) Click on 'Se|
00000710 74 27 20 6f 72 20 74 79 70 65 20 52 45 54 55 52 |t' or type RETUR|
00000720 4e 2e 20 59 6f 75 20 77 69 6c 6c 20 73 65 65 20 |N. You will see |
00000730 22 3c 4d 65 72 67 65 3e 22 20 61 70 70 65 61 72 |"<Merge>" appear|
00000740 20 69 6e 20 74 68 65 0a 20 20 20 20 74 65 78 74 | in the. text|
00000750 2e 0a 0a 28 35 29 20 52 65 70 65 61 74 20 66 6f |...(5) Repeat fo|
00000760 72 20 61 6c 6c 20 74 68 65 20 6f 74 68 65 72 20 |r all the other |
00000770 50 6f 77 65 72 62 61 73 65 20 66 69 65 6c 64 73 |Powerbase fields|
00000780 20 74 6f 20 62 65 20 69 6e 73 65 72 74 65 64 20 | to be inserted |
00000790 69 6e 20 74 68 65 0a 20 20 20 20 64 6f 63 75 6d |in the. docum|
000007a0 65 6e 74 2e 20 41 6c 6c 20 74 61 6b 65 20 74 68 |ent. All take th|
000007b0 65 20 66 6f 72 6d 20 3a 50 6f 77 65 72 62 61 73 |e form :Powerbas|
000007c0 65 20 47 65 74 46 69 65 6c 64 20 3c 74 61 67 3e |e GetField <tag>|
000007d0 2e 20 41 6c 6c 20 74 68 65 20 64 61 74 61 20 69 |. All the data i|
000007e0 6e 20 61 0a 20 20 20 20 67 69 76 65 6e 20 64 6f |n a. given do|
000007f0 63 75 6d 65 6e 74 20 6d 75 73 74 20 63 6f 6d 65 |cument must come|
00000800 20 66 72 6f 6d 20 74 68 65 20 73 61 6d 65 20 64 | from the same d|
00000810 61 74 61 62 61 73 65 2e 20 49 74 20 6d 69 67 68 |atabase. It migh|
00000820 74 20 62 65 20 65 61 73 69 65 73 74 20 69 66 0a |t be easiest if.|
00000830 20 20 20 20 79 6f 75 20 6f 70 65 6e 20 74 68 65 | you open the|
00000840 20 72 65 71 75 69 72 65 64 20 64 61 74 61 62 61 | required databa|
00000850 73 65 20 61 6e 64 20 61 72 72 61 6e 67 65 20 74 |se and arrange t|
00000860 68 65 20 64 65 73 6b 74 6f 70 20 73 6f 20 74 68 |he desktop so th|
00000870 61 74 20 79 6f 75 20 63 61 6e 0a 20 20 20 20 73 |at you can. s|
00000880 65 65 20 62 6f 74 68 20 74 68 65 20 72 65 63 6f |ee both the reco|
00000890 72 64 20 77 69 6e 64 6f 77 20 61 6e 64 20 74 68 |rd window and th|
000008a0 65 20 49 6d 70 72 65 73 73 69 6f 6e 20 64 6f 63 |e Impression doc|
000008b0 75 6d 65 6e 74 2e 20 43 6c 69 63 6b 69 6e 67 20 |ument. Clicking |
000008c0 4d 45 4e 55 0a 20 20 20 20 6f 76 65 72 20 61 20 |MENU. over a |
000008d0 66 69 65 6c 64 20 6d 61 6b 65 73 20 69 74 73 20 |field makes its |
000008e0 74 61 67 20 61 70 70 65 61 72 20 69 6e 20 74 68 |tag appear in th|
000008f0 65 20 73 65 63 6f 6e 64 20 6d 65 6e 75 20 69 74 |e second menu it|
00000900 65 6d 2e 0a 0a 28 36 29 20 53 61 76 65 20 74 68 |em...(6) Save th|
00000910 65 20 74 68 65 20 64 6f 63 75 6d 65 6e 74 21 0a |e the document!.|
00000920 0a 57 68 65 6e 20 79 6f 75 20 6c 6f 6f 6b 20 61 |.When you look a|
00000930 74 20 74 68 65 20 64 6f 63 75 6d 65 6e 74 20 74 |t the document t|
00000940 68 65 72 65 20 69 73 20 6e 6f 74 68 69 6e 67 20 |here is nothing |
00000950 74 6f 20 64 69 73 74 69 6e 67 75 69 73 68 20 6f |to distinguish o|
00000960 6e 65 20 6d 65 72 67 65 0a 63 6f 6d 6d 61 6e 64 |ne merge.command|
00000970 20 66 72 6f 6d 20 61 6e 6f 74 68 65 72 3b 20 74 | from another; t|
00000980 68 65 79 20 61 6c 6c 20 61 70 70 65 61 72 20 61 |hey all appear a|
00000990 73 20 22 3c 4d 65 72 67 65 3e 22 2e 20 54 6f 20 |s "<Merge>". To |
000009a0 63 68 65 63 6b 20 75 70 20 6f 6e 20 77 68 61 74 |check up on what|
000009b0 20 61 0a 63 6f 6d 6d 61 6e 64 20 61 63 74 75 61 | a.command actua|
000009c0 6c 6c 79 20 6c 6f 6f 6b 73 20 6c 69 6b 65 20 6f |lly looks like o|
000009d0 70 65 6e 20 75 70 20 74 68 65 20 27 4d 65 72 67 |pen up the 'Merg|
000009e0 65 20 63 6f 6d 6d 61 6e 64 27 20 64 69 61 6c 6f |e command' dialo|
000009f0 67 75 65 20 62 6f 78 20 61 67 61 69 6e 0a 61 6e |gue box again.an|
00000a00 64 20 70 6c 61 63 65 20 74 68 65 20 63 61 72 65 |d place the care|
00000a10 74 20 61 74 20 74 68 65 20 62 65 67 69 6e 6e 69 |t at the beginni|
00000a20 6e 67 20 6f 66 20 74 68 65 20 6d 65 72 67 65 20 |ng of the merge |
00000a30 63 6f 6d 6d 61 6e 64 2c 20 69 2e 65 2e 20 69 6d |command, i.e. im|
00000a40 6d 65 64 69 61 74 65 6c 79 0a 62 65 66 6f 72 65 |mediately.before|
00000a50 20 74 68 65 20 69 6e 69 74 69 61 6c 20 22 3c 22 | the initial "<"|
00000a60 2e 20 54 68 65 20 74 65 78 74 20 6f 66 20 74 68 |. The text of th|
00000a70 65 20 63 6f 6d 6d 61 6e 64 20 77 69 6c 6c 20 74 |e command will t|
00000a80 68 65 6e 20 61 70 70 65 61 72 20 69 6e 20 74 68 |hen appear in th|
00000a90 65 0a 77 72 69 74 61 62 6c 65 20 69 63 6f 6e 20 |e.writable icon |
00000aa0 6f 66 20 74 68 65 20 64 69 61 6c 6f 67 75 65 20 |of the dialogue |
00000ab0 62 6f 78 2e 0a 0a 4d 65 72 67 69 6e 67 20 74 68 |box...Merging th|
00000ac0 65 20 64 61 74 61 0a 2d 2d 2d 2d 2d 2d 2d 2d 2d |e data.---------|
00000ad0 2d 2d 2d 2d 2d 2d 2d 0a 28 31 29 20 4d 61 6b 65 |-------.(1) Make|
00000ae0 20 73 75 72 65 20 49 6d 70 72 65 73 73 69 6f 6e | sure Impression|
00000af0 20 68 61 73 20 62 65 65 6e 20 22 73 65 65 6e 22 | has been "seen"|
00000b00 20 62 79 20 74 68 65 20 66 69 6c 65 72 2e 20 49 | by the filer. I|
00000b10 6d 70 72 65 73 73 69 6f 6e 20 64 6f 65 73 6e 27 |mpression doesn'|
00000b20 74 0a 20 20 20 20 6e 65 65 64 20 74 6f 20 61 63 |t. need to ac|
00000b30 74 75 61 6c 6c 79 20 62 65 20 6f 6e 20 74 68 65 |tually be on the|
00000b40 20 69 63 6f 6e 2d 62 61 72 20 61 74 20 74 68 69 | icon-bar at thi|
00000b50 73 20 70 6f 69 6e 74 20 62 75 74 20 69 74 20 64 |s point but it d|
00000b60 6f 65 73 6e 27 74 20 6d 61 74 74 65 72 0a 20 20 |oesn't matter. |
00000b70 20 20 69 66 20 69 74 20 69 73 2e 20 0a 0a 28 32 | if it is. ..(2|
00000b80 29 20 4f 70 65 6e 20 74 68 65 20 50 6f 77 65 72 |) Open the Power|
00000b90 62 61 73 65 20 64 61 74 61 62 61 73 65 2e 0a 0a |base database...|
00000ba0 28 33 29 20 44 72 6f 70 20 74 68 65 20 49 6d 70 |(3) Drop the Imp|
00000bb0 72 65 73 73 69 6f 6e 20 64 6f 63 75 6d 65 6e 74 |ression document|
00000bc0 20 6f 6e 20 74 68 65 20 72 65 63 6f 72 64 20 77 | on the record w|
00000bd0 69 6e 64 6f 77 2e 20 49 66 20 49 6d 70 72 65 73 |indow. If Impres|
00000be0 73 69 6f 6e 20 69 73 6e 27 74 0a 20 20 20 20 61 |sion isn't. a|
00000bf0 6c 72 65 61 64 79 20 72 75 6e 6e 69 6e 67 20 50 |lready running P|
00000c00 6f 77 65 72 62 61 73 65 20 77 69 6c 6c 20 72 75 |owerbase will ru|
00000c10 6e 20 69 74 20 66 6f 72 20 79 6f 75 2e 20 41 73 |n it for you. As|
00000c20 73 75 6d 69 6e 67 20 74 68 61 74 20 74 68 65 0a |suming that the.|
00000c30 20 20 20 20 64 6f 63 75 6d 65 6e 74 20 69 73 6e | document isn|
00000c40 27 74 20 6c 6f 61 64 65 64 20 61 6c 72 65 61 64 |'t loaded alread|
00000c50 79 20 69 74 20 77 69 6c 6c 20 62 65 20 6c 6f 61 |y it will be loa|
00000c60 64 65 64 20 61 6e 64 20 64 69 73 70 6c 61 79 65 |ded and displaye|
00000c70 64 2e 20 46 69 6e 61 6c 6c 79 0a 20 20 20 20 50 |d. Finally. P|
00000c80 6f 77 65 72 62 61 73 65 27 73 20 27 44 61 74 61 |owerbase's 'Data|
00000c90 20 6d 65 72 67 65 27 20 64 69 61 6c 6f 67 75 65 | merge' dialogue|
00000ca0 20 62 6f 78 20 77 69 6c 6c 20 61 70 70 65 61 72 | box will appear|
00000cb0 2e 20 28 49 66 20 74 68 65 20 64 6f 63 75 6d 65 |. (If the docume|
00000cc0 6e 74 20 69 73 0a 20 20 20 20 61 6c 72 65 61 64 |nt is. alread|
00000cd0 79 20 6c 6f 61 64 65 64 20 49 6d 70 72 65 73 73 |y loaded Impress|
00000ce0 69 6f 6e 20 77 69 6c 6c 20 70 72 69 6e 74 20 61 |ion will print a|
00000cf0 20 6d 65 73 73 61 67 65 20 69 6e 66 6f 72 6d 69 | message informi|
00000d00 6e 67 20 79 6f 75 20 6f 66 20 74 68 69 73 2e 0a |ng you of this..|
00000d10 20 20 20 20 57 68 65 6e 20 79 6f 75 20 63 6c 69 | When you cli|
00000d20 63 6b 20 6f 6e 20 27 4f 4b 27 20 74 68 65 20 27 |ck on 'OK' the '|
00000d30 44 61 74 61 20 6d 65 72 67 65 27 20 62 6f 78 20 |Data merge' box |
00000d40 61 70 70 65 61 72 73 20 61 6e 64 20 79 6f 75 20 |appears and you |
00000d50 73 68 6f 75 6c 64 20 74 68 65 6e 0a 20 20 20 20 |should then. |
00000d60 64 69 73 70 6c 61 79 20 74 68 65 20 49 6d 70 72 |display the Impr|
00000d70 65 73 73 69 6f 6e 20 64 6f 63 75 6d 65 6e 74 20 |ession document |
00000d80 77 69 74 68 20 27 4e 65 77 20 76 69 65 77 27 2e |with 'New view'.|
00000d90 29 0a 0a 28 34 29 20 54 68 65 20 27 44 61 74 61 |)..(4) The 'Data|
00000da0 20 6d 65 72 67 65 27 20 77 69 6e 64 6f 77 20 68 | merge' window h|
00000db0 61 73 20 61 20 77 72 69 74 61 62 6c 65 20 69 63 |as a writable ic|
00000dc0 6f 6e 20 69 6e 20 77 68 69 63 68 20 79 6f 75 20 |on in which you |
00000dd0 6d 61 79 20 65 6e 74 65 72 20 61 0a 20 20 20 20 |may enter a. |
00000de0 73 65 61 72 63 68 20 66 6f 72 6d 75 6c 61 20 28 |search formula (|
00000df0 73 65 65 20 27 21 54 75 74 6f 72 69 61 6c 27 20 |see '!Tutorial' |
00000e00 61 6e 64 20 27 50 72 69 6e 74 27 29 2e 20 43 6c |and 'Print'). Cl|
00000e10 69 63 6b 69 6e 67 20 6f 6e 20 27 4d 65 72 67 65 |icking on 'Merge|
00000e20 27 20 6f 72 0a 20 20 20 20 74 79 70 69 6e 67 20 |' or. typing |
00000e30 52 45 54 55 52 4e 20 74 68 65 6e 20 65 78 74 72 |RETURN then extr|
00000e40 61 63 74 73 20 64 61 74 61 20 66 72 6f 6d 20 74 |acts data from t|
00000e50 68 65 20 66 69 72 73 74 20 6d 61 74 63 68 69 6e |he first matchin|
00000e60 67 20 72 65 63 6f 72 64 20 61 6e 64 0a 20 20 20 |g record and. |
00000e70 20 69 6e 73 65 72 74 73 20 69 74 20 69 6e 20 74 | inserts it in t|
00000e80 68 65 20 73 70 65 63 69 66 69 65 64 20 70 6c 61 |he specified pla|
00000e90 63 65 73 20 69 6e 20 74 68 65 20 49 6d 70 72 65 |ces in the Impre|
00000ea0 73 73 69 6f 6e 20 64 6f 63 75 6d 65 6e 74 2e 20 |ssion document. |
00000eb0 49 66 20 6e 6f 0a 20 20 20 20 73 65 61 72 63 68 |If no. search|
00000ec0 20 66 6f 72 6d 75 6c 61 20 77 61 73 20 65 6e 74 | formula was ent|
00000ed0 65 72 65 64 20 74 68 65 20 6d 65 72 67 65 64 20 |ered the merged |
00000ee0 72 65 63 6f 72 64 20 77 69 6c 6c 20 62 65 20 74 |record will be t|
00000ef0 68 65 20 66 69 72 73 74 2e 0a 0a 28 35 29 20 42 |he first...(5) B|
00000f00 75 74 74 6f 6e 73 20 61 72 65 20 70 72 6f 76 69 |uttons are provi|
00000f10 64 65 64 20 66 6f 72 20 22 6e 65 78 74 22 2c 20 |ded for "next", |
00000f20 22 70 72 65 76 69 6f 75 73 22 2c 20 22 66 69 72 |"previous", "fir|
00000f30 73 74 22 20 61 6e 64 20 22 6c 61 73 74 22 20 72 |st" and "last" r|
00000f40 65 63 6f 72 64 2e 0a 20 20 20 20 54 68 65 73 65 |ecord.. These|
00000f50 20 77 6f 72 6b 20 6a 75 73 74 20 6c 69 6b 65 20 | work just like |
00000f60 74 68 65 20 63 6f 72 72 65 73 70 6f 6e 64 69 6e |the correspondin|
00000f70 67 20 6b 65 79 70 61 64 20 62 75 74 74 6f 6e 73 |g keypad buttons|
00000f80 20 61 6e 64 20 74 68 65 20 49 6d 70 72 65 73 73 | and the Impress|
00000f90 69 6f 6e 0a 20 20 20 20 64 6f 63 75 6d 65 6e 74 |ion. document|
00000fa0 20 64 69 73 70 6c 61 79 73 20 74 68 65 20 6d 65 | displays the me|
00000fb0 72 67 65 64 20 64 61 74 61 20 69 6e 20 65 61 63 |rged data in eac|
00000fc0 68 20 63 61 73 65 2e 0a 0a 28 36 29 20 43 6c 69 |h case...(6) Cli|
00000fd0 63 6b 69 6e 67 20 6f 6e 20 27 50 72 69 6e 74 27 |cking on 'Print'|
00000fe0 20 77 69 6c 6c 20 70 72 69 6e 74 20 74 68 65 20 | will print the |
00000ff0 49 6d 70 72 65 73 73 69 6f 6e 20 64 6f 63 75 6d |Impression docum|
00001000 65 6e 74 20 69 6e 20 69 74 73 20 64 69 73 70 6c |ent in its displ|
00001010 61 79 65 64 0a 20 20 20 20 73 74 61 74 65 2c 20 |ayed. state, |
00001020 69 2e 65 2e 20 77 69 74 68 20 74 68 65 20 63 75 |i.e. with the cu|
00001030 72 72 65 6e 74 6c 79 20 6d 65 72 67 65 64 20 64 |rrently merged d|
00001040 61 74 61 2e 20 49 66 20 79 6f 75 20 73 65 6c 65 |ata. If you sele|
00001050 63 74 20 74 68 65 20 27 50 72 69 6e 74 0a 20 20 |ct the 'Print. |
00001060 20 20 61 6c 6c 27 20 73 77 69 74 63 68 20 74 68 | all' switch th|
00001070 65 6e 20 63 6c 69 63 6b 20 6f 6e 20 27 4d 65 72 |en click on 'Mer|
00001080 67 65 27 20 61 20 77 68 6f 6c 65 20 73 65 72 69 |ge' a whole seri|
00001090 65 73 20 6f 66 20 68 61 72 64 20 63 6f 70 69 65 |es of hard copie|
000010a0 73 20 77 69 6c 6c 20 62 65 0a 20 20 20 20 70 72 |s will be. pr|
000010b0 6f 64 75 63 65 64 2c 20 6f 6e 65 20 66 6f 72 20 |oduced, one for |
000010c0 65 61 63 68 20 6d 61 74 63 68 69 6e 67 20 72 65 |each matching re|
000010d0 63 6f 72 64 2e 0a 0a 28 37 29 20 4e 6f 74 65 20 |cord...(7) Note |
000010e0 74 68 61 74 20 77 68 65 6e 20 74 68 65 20 6d 6f |that when the mo|
000010f0 75 73 65 20 70 6f 69 6e 74 65 72 20 69 73 20 6d |use pointer is m|
00001100 6f 76 65 64 20 6f 76 65 72 20 74 68 65 20 49 6d |oved over the Im|
00001110 70 72 65 73 73 69 6f 6e 20 64 6f 63 75 6d 65 6e |pression documen|
00001120 74 0a 20 20 20 20 69 74 20 63 68 61 6e 67 65 73 |t. it changes|
00001130 20 74 6f 20 61 20 6c 61 72 67 65 20 72 65 64 20 | to a large red |
00001140 61 6e 64 20 62 6c 75 65 20 63 72 6f 73 73 20 77 |and blue cross w|
00001150 68 69 63 68 20 6d 65 61 6e 73 20 74 68 61 74 20 |hich means that |
00001160 79 6f 75 20 63 61 6e 6e 6f 74 0a 20 20 20 20 65 |you cannot. e|
00001170 64 69 74 20 74 68 65 20 64 6f 63 75 6d 65 6e 74 |dit the document|
00001180 2e 20 43 6c 69 63 6b 69 6e 67 20 53 45 4c 45 43 |. Clicking SELEC|
00001190 54 20 6f 76 65 72 20 69 74 20 68 61 73 20 6e 6f |T over it has no|
000011a0 20 65 66 66 65 63 74 3b 20 74 68 65 20 63 61 72 | effect; the car|
000011b0 65 74 0a 20 20 20 20 64 6f 65 73 6e 27 74 20 61 |et. doesn't a|
000011c0 70 70 65 61 72 2e 20 49 66 20 79 6f 75 20 63 6c |ppear. If you cl|
000011d0 69 63 6b 20 6f 6e 20 27 43 61 6e 63 65 6c 27 20 |ick on 'Cancel' |
000011e0 69 6e 20 74 68 65 20 64 69 61 6c 6f 67 75 65 20 |in the dialogue |
000011f0 62 6f 78 20 28 6f 72 20 63 6c 6f 73 65 0a 20 20 |box (or close. |
00001200 20 20 69 74 20 62 79 20 63 6c 69 63 6b 69 6e 67 | it by clicking|
00001210 20 6f 6e 20 69 74 73 20 27 43 6c 6f 73 65 27 20 | on its 'Close' |
00001220 69 63 6f 6e 29 20 74 68 65 20 6d 65 72 67 65 64 |icon) the merged|
00001230 20 64 61 74 61 20 69 73 20 72 65 6d 6f 76 65 64 | data is removed|
00001240 20 66 72 6f 6d 20 74 68 65 0a 20 20 20 20 64 6f | from the. do|
00001250 63 75 6d 65 6e 74 20 61 6e 64 20 6e 6f 72 6d 61 |cument and norma|
00001260 6c 20 65 64 69 74 69 6e 67 20 69 73 20 72 65 73 |l editing is res|
00001270 74 6f 72 65 64 2e 0a 0a 4d 61 69 6c 2d 6d 65 72 |tored...Mail-mer|
00001280 67 69 6e 67 20 77 69 74 68 20 6f 74 68 65 72 20 |ging with other |
00001290 61 70 70 6c 69 63 61 74 69 6f 6e 73 0a 3d 3d 3d |applications.===|
000012a0 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |================|
*
000012c0 3d 0a 50 6f 77 65 72 62 61 73 65 20 69 73 20 61 |=.Powerbase is a|
000012d0 62 6c 65 20 74 6f 20 6d 61 69 6c 2d 6d 65 72 67 |ble to mail-merg|
000012e0 65 20 64 69 72 65 63 74 6c 79 20 77 69 74 68 20 |e directly with |
000012f0 49 6d 70 72 65 73 73 69 6f 6e 20 6f 6e 6c 79 20 |Impression only |
00001300 62 65 63 61 75 73 65 20 62 6f 74 68 0a 70 72 6f |because both.pro|
00001310 67 72 61 6d 73 20 73 75 70 70 6f 72 74 20 49 6d |grams support Im|
00001320 70 75 6c 73 65 20 63 6f 6d 6d 61 6e 64 73 2e 20 |pulse commands. |
00001330 4d 6f 73 74 20 6f 74 68 65 72 20 44 54 50 20 70 |Most other DTP p|
00001340 72 6f 67 72 61 6d 73 20 61 6e 64 20 77 6f 72 64 |rograms and word|
00001350 2d 0a 70 72 6f 63 65 73 73 6f 72 73 20 64 6f 20 |-.processors do |
00001360 6e 6f 74 20 72 65 63 6f 67 6e 69 7a 65 20 73 75 |not recognize su|
00001370 63 68 20 63 6f 6d 6d 61 6e 64 73 20 61 6e 64 20 |ch commands and |
00001380 6d 61 69 6c 2d 6d 65 72 67 69 6e 67 20 77 69 74 |mail-merging wit|
00001390 68 20 74 68 65 6d 20 69 73 0a 75 73 75 61 6c 6c |h them is.usuall|
000013a0 79 20 61 63 63 6f 6d 70 6c 69 73 68 65 64 20 76 |y accomplished v|
000013b0 69 61 20 61 20 43 53 56 20 28 63 6f 6d 6d 61 20 |ia a CSV (comma |
000013c0 20 73 65 70 61 72 61 74 65 64 20 76 61 6c 75 65 | separated value|
000013d0 73 29 20 6f 72 20 73 69 6d 69 6c 61 72 20 66 69 |s) or similar fi|
000013e0 6c 65 2e 0a 59 6f 75 20 77 69 6c 6c 20 6e 65 65 |le..You will nee|
000013f0 64 20 74 6f 20 72 65 61 64 20 74 68 65 20 77 6f |d to read the wo|
00001400 72 64 70 72 6f 63 65 73 73 6f 72 20 6d 61 6e 75 |rdprocessor manu|
00001410 61 6c 20 74 6f 20 66 69 6e 64 20 6f 75 74 20 70 |al to find out p|
00001420 72 65 63 69 73 65 6c 79 20 77 68 61 74 0a 66 6f |recisely what.fo|
00001430 72 6d 61 74 20 74 68 65 20 66 69 6c 65 20 73 68 |rmat the file sh|
00001440 6f 75 6c 64 20 68 61 76 65 20 61 6e 64 20 61 6c |ould have and al|
00001450 73 6f 20 74 68 65 20 50 6f 77 65 72 62 61 73 65 |so the Powerbase|
00001460 20 64 6f 63 75 6d 65 6e 74 61 74 69 6f 6e 20 6f | documentation o|
00001470 6e 20 43 53 56 0a 66 69 6c 65 73 2e 20 49 74 20 |n CSV.files. It |
00001480 73 68 6f 75 6c 64 20 62 65 20 70 6f 73 73 69 62 |should be possib|
00001490 6c 65 20 74 6f 20 63 72 65 61 74 65 20 61 20 66 |le to create a f|
000014a0 69 6c 65 20 69 6e 20 77 68 61 74 65 76 65 72 20 |ile in whatever |
000014b0 66 6f 72 6d 61 74 20 69 73 0a 72 65 71 75 69 72 |format is.requir|
000014c0 65 64 2e 0a 0a 50 6f 77 65 72 62 61 73 65 20 61 |ed...Powerbase a|
000014d0 73 20 61 6e 20 27 49 6d 70 75 6c 73 65 27 20 73 |s an 'Impulse' s|
000014e0 65 72 76 65 72 0a 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |erver.==========|
000014f0 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d 3d |================|
00001500 3d 3d 3d 3d 3d 3d 0a 54 68 65 20 66 6f 6c 6c 6f |======.The follo|
00001510 77 69 6e 67 20 69 73 20 61 20 64 65 73 63 72 69 |wing is a descri|
00001520 70 74 69 6f 6e 20 6f 66 20 74 68 65 20 49 6d 70 |ption of the Imp|
00001530 75 6c 73 65 20 22 6d 65 74 68 6f 64 73 22 20 75 |ulse "methods" u|
00001540 6e 64 65 72 73 74 6f 6f 64 20 62 79 0a 50 6f 77 |nderstood by.Pow|
00001550 65 72 62 61 73 65 2c 20 67 69 76 65 6e 20 69 6e |erbase, given in|
00001560 20 74 68 65 20 73 74 61 6e 64 61 72 64 20 66 6f | the standard fo|
00001570 72 6d 61 74 20 72 65 63 6f 6d 6d 65 6e 64 65 64 |rmat recommended|
00001580 20 62 79 20 43 6f 6d 70 75 74 65 72 20 43 6f 6e | by Computer Con|
00001590 63 65 70 74 73 2e 0a 20 20 20 20 0a 7b 70 6f 77 |cepts.. .{pow|
000015a0 65 72 62 61 73 65 20 4d 65 74 68 6f 64 73 3a 0a |erbase Methods:.|
000015b0 20 20 20 20 20 20 20 20 47 65 74 50 61 74 68 6e | GetPathn|
000015c0 61 6d 65 0a 20 20 20 20 20 20 20 20 53 65 6c 65 |ame. Sele|
000015d0 63 74 69 6f 6e 20 3c 73 74 72 69 6e 67 3e 0a 20 |ction <string>. |
000015e0 20 20 20 20 20 20 20 50 61 72 73 65 51 75 65 72 | ParseQuer|
000015f0 79 20 3c 73 74 72 69 6e 67 3e 0a 20 20 20 20 20 |y <string>. |
00001600 20 20 20 47 65 74 46 69 65 6c 64 20 3c 74 61 67 | GetField <tag|
00001610 3e 0a 20 20 20 20 20 20 20 20 47 65 74 52 65 63 |>. GetRec|
00001620 6f 72 64 0a 20 20 20 20 20 20 20 20 50 75 74 46 |ord. PutF|
00001630 69 6c 65 0a 20 20 20 20 20 20 20 20 45 78 70 61 |ile. Expa|
00001640 6e 64 43 6f 64 65 20 3c 73 74 72 69 6e 67 3e 0a |ndCode <string>.|
00001650 20 20 20 20 20 20 20 20 47 65 74 45 78 70 61 6e | GetExpan|
00001660 64 65 64 20 3c 73 74 72 69 6e 67 3e 0a 0a 44 65 |ded <string>..De|
00001670 73 63 72 69 70 74 69 6f 6e 73 3a 0a 47 65 74 50 |scriptions:.GetP|
00001680 61 74 68 6e 61 6d 65 0a 0a 53 70 65 63 69 66 69 |athname..Specifi|
00001690 65 73 20 61 6e 20 27 6f 62 6a 65 63 74 27 20 69 |es an 'object' i|
000016a0 2e 65 2e 20 61 20 50 6f 77 65 72 62 61 73 65 20 |.e. a Powerbase |
000016b0 64 61 74 61 62 61 73 65 2e 20 49 66 20 50 6f 77 |database. If Pow|
000016c0 65 72 62 61 73 65 20 68 61 73 20 74 68 65 0a 72 |erbase has the.r|
000016d0 65 71 75 69 72 65 64 20 64 61 74 61 62 61 73 65 |equired database|
000016e0 20 6f 70 65 6e 20 69 74 20 72 65 70 6c 69 65 73 | open it replies|
000016f0 20 77 69 74 68 20 74 68 65 20 66 75 6c 6c 20 70 | with the full p|
00001700 61 74 68 6e 61 6d 65 20 6f 66 20 74 68 65 20 6f |athname of the o|
00001710 62 6a 65 63 74 2c 0a 6f 74 68 65 72 77 69 73 65 |bject,.otherwise|
00001720 20 69 74 20 72 65 74 75 72 6e 73 20 61 6e 20 65 | it returns an e|
00001730 72 72 6f 72 20 6d 65 73 73 61 67 65 2e 20 45 78 |rror message. Ex|
00001740 61 6d 70 6c 65 20 6f 66 20 75 73 65 3a 0a 0a 20 |ample of use:.. |
00001750 20 3a 50 6f 77 65 72 62 61 73 65 2e 21 45 6c 65 | :Powerbase.!Ele|
00001760 6d 65 6e 74 73 20 47 65 74 50 61 74 68 6e 61 6d |ments GetPathnam|
00001770 65 20 20 28 72 65 74 75 72 6e 73 20 70 61 74 68 |e (returns path|
00001780 6e 61 6d 65 20 6f 66 20 21 45 6c 65 6d 65 6e 74 |name of !Element|
00001790 73 29 0a 0a 52 36 20 70 6f 69 6e 74 73 20 74 6f |s)..R6 points to|
000017a0 20 70 61 74 68 6e 61 6d 65 20 77 68 65 6e 20 63 | pathname when c|
000017b0 61 6c 6c 69 6e 67 20 74 61 73 6b 20 69 73 20 64 |alling task is d|
000017c0 65 63 6f 64 69 6e 67 20 72 65 70 6c 79 2e 0a 0a |ecoding reply...|
000017d0 53 65 6c 65 63 74 69 6f 6e 20 3c 73 74 72 69 6e |Selection <strin|
000017e0 67 3e 0a 0a 54 65 6c 6c 73 20 50 6f 77 65 72 62 |g>..Tells Powerb|
000017f0 61 73 65 20 61 62 6f 75 74 20 61 20 66 69 65 6c |ase about a fiel|
00001800 64 2c 20 6f 72 20 67 72 6f 75 70 20 6f 66 20 66 |d, or group of f|
00001810 69 65 6c 64 73 2c 20 69 6e 20 77 68 69 63 68 20 |ields, in which |
00001820 74 68 65 20 63 61 6c 6c 65 72 20 69 73 0a 69 6e |the caller is.in|
00001830 74 65 72 65 73 74 65 64 2e 20 54 68 65 20 66 69 |terested. The fi|
00001840 65 6c 64 73 20 61 72 65 20 73 70 65 63 69 66 69 |elds are specifi|
00001850 65 64 20 61 73 20 61 20 6c 69 73 74 20 6f 66 20 |ed as a list of |
00001860 74 61 67 73 2c 20 73 65 70 61 72 61 74 65 64 20 |tags, separated |
00001870 62 79 20 61 6e 79 0a 73 75 69 74 61 62 6c 65 20 |by any.suitable |
00001880 63 68 61 72 61 63 74 65 72 20 28 65 2e 67 2e 20 |character (e.g. |
00001890 2f 20 6f 72 20 2c 29 2e 20 54 68 65 20 73 61 6d |/ or ,). The sam|
000018a0 65 20 73 65 70 61 72 61 74 6f 72 20 6d 75 73 74 |e separator must|
000018b0 20 61 70 70 65 61 72 20 61 74 20 74 68 65 20 76 | appear at the v|
000018c0 65 72 79 0a 65 6e 64 20 6f 66 20 74 68 65 20 74 |ery.end of the t|
000018d0 61 67 2d 6c 69 73 74 2e 20 20 50 6f 77 65 72 62 |ag-list. Powerb|
000018e0 61 73 65 20 72 65 70 6c 69 65 73 20 77 69 74 68 |ase replies with|
000018f0 20 74 68 65 20 6d 61 78 69 6d 75 6d 20 64 61 74 | the maximum dat|
00001900 61 2d 6c 65 6e 67 74 68 20 6f 66 20 74 68 65 0a |a-length of the.|
00001910 63 6f 6d 62 69 6e 65 64 20 66 69 65 6c 64 73 20 |combined fields |
00001920 69 6e 20 74 68 65 20 73 65 6c 65 63 74 69 6f 6e |in the selection|
00001930 2e 20 45 78 61 6d 70 6c 65 20 6f 66 20 75 73 65 |. Example of use|
00001940 3a 0a 0a 20 20 3a 50 6f 77 65 72 62 61 73 65 20 |:.. :Powerbase |
00001950 53 65 6c 65 63 74 69 6f 6e 20 4e 41 4d 45 2f 53 |Selection NAME/S|
00001960 59 4d 2f 5a 2f 0a 0a 52 36 20 70 6f 69 6e 74 73 |YM/Z/..R6 points|
00001970 20 74 6f 20 61 20 73 74 72 69 6e 67 20 77 68 69 | to a string whi|
00001980 63 68 20 67 69 76 65 73 20 64 61 74 61 2d 6c 65 |ch gives data-le|
00001990 6e 67 74 68 2e 0a 0a 50 61 72 73 65 51 75 65 72 |ngth...ParseQuer|
000019a0 79 20 3c 73 74 72 69 6e 67 3e 0a 0a 49 6e 66 6f |y <string>..Info|
000019b0 72 6d 73 20 50 6f 77 65 72 62 61 73 65 20 6f 66 |rms Powerbase of|
000019c0 20 74 68 65 20 63 72 69 74 65 72 69 61 20 74 6f | the criteria to|
000019d0 20 62 65 20 75 73 65 64 20 69 6e 20 73 65 6c 65 | be used in sele|
000019e0 63 74 69 6e 67 20 72 65 63 6f 72 64 73 20 74 6f |cting records to|
000019f0 0a 74 72 61 6e 73 6d 69 74 20 74 6f 20 74 68 65 |.transmit to the|
00001a00 20 63 61 6c 6c 65 72 2e 20 20 54 68 65 20 70 61 | caller. The pa|
00001a10 72 61 6d 65 74 65 72 20 69 73 20 61 20 73 74 61 |rameter is a sta|
00001a20 6e 64 61 72 64 20 50 6f 77 65 72 62 61 73 65 20 |ndard Powerbase |
00001a30 73 65 61 72 63 68 0a 66 6f 72 6d 75 6c 61 20 61 |search.formula a|
00001a40 6e 64 20 50 6f 77 65 72 62 61 73 65 20 72 65 70 |nd Powerbase rep|
00001a50 6c 69 65 73 20 77 69 74 68 20 74 68 65 20 74 69 |lies with the ti|
00001a60 74 6c 65 20 77 68 69 63 68 20 77 6f 75 6c 64 20 |tle which would |
00001a70 6e 6f 72 6d 61 6c 6c 79 20 61 70 70 65 61 72 0a |normally appear.|
00001a80 61 74 20 74 68 65 20 68 65 61 64 20 6f 66 20 6f |at the head of o|
00001a90 6e 65 20 6f 66 20 69 74 73 20 70 72 69 6e 74 65 |ne of its printe|
00001aa0 64 20 6c 69 73 74 73 2e 20 45 78 61 6d 70 6c 65 |d lists. Example|
00001ab0 20 6f 66 20 75 73 65 3a 0a 0a 20 20 3a 50 6f 77 | of use:.. :Pow|
00001ac0 65 72 62 61 73 65 20 50 61 72 73 65 51 75 65 72 |erbase ParseQuer|
00001ad0 79 20 54 59 50 45 3d 54 0a 0a 52 36 20 70 6f 69 |y TYPE=T..R6 poi|
00001ae0 6e 74 73 20 74 6f 20 72 65 74 75 72 6e 65 64 20 |nts to returned |
00001af0 74 69 74 6c 65 2e 0a 0a 47 65 74 46 69 65 6c 64 |title...GetField|
00001b00 20 3c 74 61 67 3e 0a 0a 52 65 71 75 65 73 74 73 | <tag>..Requests|
00001b10 20 66 72 6f 6d 20 50 6f 77 65 72 62 61 73 65 20 | from Powerbase |
00001b20 74 68 65 20 64 61 74 61 20 69 6e 20 74 68 65 20 |the data in the |
00001b30 73 70 65 63 69 66 69 65 64 20 66 69 65 6c 64 20 |specified field |
00001b40 6f 66 20 74 68 65 20 6e 65 78 74 20 72 65 63 6f |of the next reco|
00001b50 72 64 0a 77 68 69 63 68 20 6d 61 74 63 68 65 73 |rd.which matches|
00001b60 20 74 68 65 20 70 72 65 63 65 64 69 6e 67 20 50 | the preceding P|
00001b70 61 72 73 65 51 75 65 72 79 20 63 6f 6d 6d 61 6e |arseQuery comman|
00001b80 64 2e 0a 0a 57 68 65 6e 20 50 6f 77 65 72 62 61 |d...When Powerba|
00001b90 73 65 20 72 65 70 6c 69 65 73 20 74 6f 20 74 68 |se replies to th|
00001ba0 65 20 47 65 74 46 69 65 6c 64 20 63 6f 6d 6d 61 |e GetField comma|
00001bb0 6e 64 20 74 68 65 20 63 61 6c 6c 69 6e 67 20 74 |nd the calling t|
00001bc0 61 73 6b 20 73 68 6f 75 6c 64 0a 72 65 73 70 6f |ask should.respo|
00001bd0 6e 64 20 77 69 74 68 20 61 6e 20 49 6d 70 75 6c |nd with an Impul|
00001be0 73 65 46 65 74 63 68 44 61 74 61 2c 20 73 70 65 |seFetchData, spe|
00001bf0 63 69 66 79 69 6e 67 20 74 68 65 20 61 64 64 72 |cifying the addr|
00001c00 65 73 73 20 61 6e 64 20 6c 65 6e 67 74 68 20 6f |ess and length o|
00001c10 66 20 74 68 65 0a 62 75 66 66 65 72 20 74 6f 20 |f the.buffer to |
00001c20 62 65 20 75 73 65 64 2c 20 61 6e 64 20 74 68 65 |be used, and the|
00001c30 6e 20 77 61 69 74 20 66 6f 72 20 61 6e 20 49 6d |n wait for an Im|
00001c40 70 75 6c 73 65 5f 72 65 63 65 69 76 65 20 65 76 |pulse_receive ev|
00001c50 65 6e 74 20 28 72 65 61 73 6f 6e 20 63 6f 64 65 |ent (reason code|
00001c60 0a 26 32 30 34 29 20 62 65 66 6f 72 65 20 72 65 |.&204) before re|
00001c70 61 64 69 6e 67 20 74 68 65 20 62 75 66 66 65 72 |ading the buffer|
00001c80 2e 20 0a 0a 47 65 74 52 65 63 6f 72 64 20 5b 3c |. ..GetRecord [<|
00001c90 6b 65 79 3e 5d 0a 0a 53 65 6e 74 20 77 69 74 68 |key>]..Sent with|
00001ca0 6f 75 74 20 61 20 6b 65 79 20 69 74 20 72 65 71 |out a key it req|
00001cb0 75 65 73 74 73 20 66 72 6f 6d 20 50 6f 77 65 72 |uests from Power|
00001cc0 62 61 73 65 20 74 68 65 20 6e 65 78 74 20 72 65 |base the next re|
00001cd0 63 6f 72 64 20 77 68 69 63 68 20 6d 61 74 63 68 |cord which match|
00001ce0 65 73 0a 74 68 65 20 70 72 65 63 65 64 69 6e 67 |es.the preceding|
00001cf0 20 50 61 72 73 65 51 75 65 72 79 20 63 6f 6d 6d | ParseQuery comm|
00001d00 61 6e 64 2e 20 49 66 20 74 68 65 20 70 72 69 6d |and. If the prim|
00001d10 61 72 79 20 6b 65 79 20 6f 66 20 61 20 72 65 63 |ary key of a rec|
00001d20 6f 72 64 20 69 6e 20 74 68 65 0a 64 61 74 61 62 |ord in the.datab|
00001d30 61 73 65 20 69 73 20 61 70 70 65 6e 64 65 64 20 |ase is appended |
00001d40 74 68 65 6e 20 50 6f 77 65 72 62 61 73 65 20 77 |then Powerbase w|
00001d50 69 6c 6c 20 72 65 74 75 72 6e 20 74 68 65 20 72 |ill return the r|
00001d60 65 63 6f 72 64 20 63 6f 72 72 65 73 70 6f 6e 64 |ecord correspond|
00001d70 69 6e 67 20 74 6f 0a 74 68 61 74 20 6b 65 79 2e |ing to.that key.|
00001d80 20 54 68 65 20 6b 65 79 20 6d 75 73 74 20 62 65 | The key must be|
00001d90 20 73 65 70 61 72 61 74 65 64 20 66 72 6f 6d 20 | separated from |
00001da0 74 68 65 20 47 65 74 52 65 63 6f 72 64 20 62 79 |the GetRecord by|
00001db0 20 61 20 73 70 61 63 65 2e 20 0a 0a 54 68 65 20 | a space. ..The |
00001dc0 63 61 6c 6c 69 6e 67 20 74 61 73 6b 20 6d 75 73 |calling task mus|
00001dd0 74 20 66 6f 6c 6c 6f 77 20 74 68 65 20 70 72 6f |t follow the pro|
00001de0 63 65 64 75 72 65 20 64 65 73 63 72 69 62 65 64 |cedure described|
00001df0 20 61 62 6f 76 65 20 66 6f 72 20 47 65 74 46 69 | above for GetFi|
00001e00 65 6c 64 2e 0a 50 6f 77 65 72 62 61 73 65 20 77 |eld..Powerbase w|
00001e10 69 6c 6c 20 74 72 61 6e 73 6d 69 74 20 74 68 65 |ill transmit the|
00001e20 20 66 69 65 6c 64 73 20 73 70 65 63 69 66 69 65 | fields specifie|
00001e30 64 20 69 6e 20 74 68 65 20 53 65 6c 65 63 74 69 |d in the Selecti|
00001e40 6f 6e 20 63 6f 6d 6d 61 6e 64 2c 20 75 73 69 6e |on command, usin|
00001e50 67 0a 74 68 65 20 73 61 6d 65 20 73 65 70 61 72 |g.the same separ|
00001e60 61 74 6f 72 20 61 73 20 77 61 73 20 75 73 65 64 |ator as was used|
00001e70 20 69 6e 20 74 68 61 74 20 63 6f 6d 6d 61 6e 64 | in that command|
00001e80 2e 20 52 65 63 65 69 70 74 20 6f 66 20 64 61 74 |. Receipt of dat|
00001e90 61 20 6d 61 79 20 62 65 0a 66 6f 6c 6c 6f 77 65 |a may be.followe|
00001ea0 64 20 62 79 20 61 6e 6f 74 68 65 72 20 47 65 74 |d by another Get|
00001eb0 52 65 63 6f 72 64 20 63 6f 6d 6d 61 6e 64 2c 20 |Record command, |
00001ec0 72 65 74 75 72 6e 69 6e 67 20 74 68 65 20 6e 65 |returning the ne|
00001ed0 78 74 20 6d 61 74 63 68 69 6e 67 20 72 65 63 6f |xt matching reco|
00001ee0 72 64 0a 61 6e 64 20 73 6f 20 6f 6e 2c 20 61 20 |rd.and so on, a |
00001ef0 7a 65 72 6f 2d 6c 65 6e 67 74 68 20 72 65 73 70 |zero-length resp|
00001f00 6f 6e 73 65 20 73 69 67 6e 69 66 79 69 6e 67 20 |onse signifying |
00001f10 74 68 61 74 20 74 68 65 72 65 20 61 72 65 20 6e |that there are n|
00001f20 6f 20 6d 6f 72 65 0a 6d 61 74 63 68 69 6e 67 20 |o more.matching |
00001f30 72 65 63 6f 72 64 73 2e 20 49 66 20 75 73 69 6e |records. If usin|
00001f40 67 20 6b 65 79 73 20 74 6f 20 72 65 71 75 65 73 |g keys to reques|
00001f50 74 20 73 70 65 63 69 66 69 63 20 72 65 63 6f 72 |t specific recor|
00001f60 64 73 20 79 6f 75 20 73 68 6f 75 6c 64 20 65 6e |ds you should en|
00001f70 64 0a 62 79 20 73 65 6e 64 69 6e 67 20 2a 2a 2a |d.by sending ***|
00001f80 20 61 73 20 61 20 6b 65 79 20 74 6f 20 74 65 6c | as a key to tel|
00001f90 6c 20 50 6f 77 65 72 62 61 73 65 20 74 68 61 74 |l Powerbase that|
00001fa0 20 74 68 65 20 64 69 61 6c 6f 67 75 65 20 69 73 | the dialogue is|
00001fb0 20 66 69 6e 69 73 68 65 64 2e 0a 54 68 69 73 20 | finished..This |
00001fc0 63 6f 6d 6d 61 6e 64 20 61 6e 64 20 74 68 65 20 |command and the |
00001fd0 6f 6e 65 20 62 65 6c 6f 77 20 6f 70 65 72 61 74 |one below operat|
00001fe0 65 20 6f 6e 6c 79 20 6f 6e 20 53 75 62 66 69 6c |e only on Subfil|
00001ff0 65 20 30 20 6f 66 20 74 68 65 20 50 6f 77 65 72 |e 0 of the Power|
00002000 62 61 73 65 0a 64 61 74 61 62 61 73 65 2e 20 0a |base.database. .|
00002010 0a 50 75 74 52 65 63 6f 72 64 0a 0a 49 6e 66 6f |.PutRecord..Info|
00002020 72 6d 73 20 50 6f 77 65 72 62 61 73 65 20 74 68 |rms Powerbase th|
00002030 61 74 20 74 68 65 20 63 61 6c 6c 65 72 20 77 69 |at the caller wi|
00002040 73 68 65 73 20 74 6f 20 77 72 69 74 65 20 61 20 |shes to write a |
00002050 72 65 63 6f 72 64 20 74 6f 20 74 68 65 20 63 75 |record to the cu|
00002060 72 72 65 6e 74 0a 50 6f 77 65 72 62 61 73 65 20 |rrent.Powerbase |
00002070 64 61 74 61 62 61 73 65 2e 20 49 74 20 73 68 6f |database. It sho|
00002080 75 6c 64 20 62 65 20 73 65 6e 74 20 61 73 20 6d |uld be sent as m|
00002090 65 73 73 61 67 65 20 74 79 70 65 20 26 32 30 30 |essage type &200|
000020a0 2e 20 41 20 53 65 6c 65 63 74 69 6f 6e 0a 63 6f |. A Selection.co|
000020b0 6d 6d 61 6e 64 20 73 68 6f 75 6c 64 20 68 61 76 |mmand should hav|
000020c0 65 20 62 65 65 6e 20 70 72 65 76 69 6f 75 73 6c |e been previousl|
000020d0 79 20 73 65 6e 74 20 74 6f 20 74 65 6c 6c 20 50 |y sent to tell P|
000020e0 6f 77 65 72 62 61 73 65 20 77 68 61 74 20 66 69 |owerbase what fi|
000020f0 65 6c 64 73 20 74 6f 0a 65 78 70 65 63 74 20 61 |elds to.expect a|
00002100 6e 64 20 77 68 61 74 20 73 65 70 61 72 61 74 6f |nd what separato|
00002110 72 20 69 73 20 74 6f 20 62 65 20 75 73 65 64 2e |r is to be used.|
00002120 20 50 6f 77 65 72 62 61 73 65 20 77 69 6c 6c 20 | Powerbase will |
00002130 74 68 65 6e 20 72 65 70 6c 79 20 77 69 74 68 20 |then reply with |
00002140 61 0a 47 65 74 52 65 63 6f 72 64 20 63 6f 6d 6d |a.GetRecord comm|
00002150 61 6e 64 20 28 72 65 61 73 6f 6e 20 63 6f 64 65 |and (reason code|
00002160 20 26 32 30 31 29 20 77 68 69 63 68 20 74 68 65 | &201) which the|
00002170 20 63 61 6c 6c 65 72 20 73 68 6f 75 6c 64 20 61 | caller should a|
00002180 63 6b 6e 6f 77 6c 65 64 67 65 0a 77 69 74 68 20 |cknowledge.with |
00002190 6d 65 73 73 61 67 65 20 74 79 70 65 20 26 32 30 |message type &20|
000021a0 32 2c 20 73 70 65 63 69 66 79 69 6e 67 20 74 68 |2, specifying th|
000021b0 65 20 6d 61 78 69 6d 75 6d 20 6c 65 6e 67 74 68 |e maximum length|
000021c0 20 6f 66 20 74 68 65 20 64 61 74 61 20 77 68 69 | of the data whi|
000021d0 63 68 20 77 69 6c 6c 0a 62 65 20 73 65 6e 74 2e |ch will.be sent.|
000021e0 20 57 61 69 74 20 66 6f 72 20 65 76 65 6e 74 20 | Wait for event |
000021f0 26 32 30 33 20 77 68 69 63 68 20 69 73 20 61 20 |&203 which is a |
00002200 72 65 71 75 65 73 74 20 62 79 20 50 6f 77 65 72 |request by Power|
00002210 62 61 73 65 20 66 6f 72 20 74 68 65 20 63 61 6c |base for the cal|
00002220 6c 65 72 0a 74 6f 20 74 72 61 6e 73 6d 69 74 20 |ler.to transmit |
00002230 74 68 65 20 64 61 74 61 2e 20 54 68 65 20 63 61 |the data. The ca|
00002240 6c 6c 65 72 20 73 68 6f 75 6c 64 20 74 68 65 6e |ller should then|
00002250 20 64 6f 20 73 6f 20 77 69 74 68 20 49 6d 70 75 | do so with Impu|
00002260 6c 73 65 54 72 61 6e 73 6d 69 74 44 61 74 61 2c |lseTransmitData,|
00002270 0a 73 70 65 63 69 66 79 69 6e 67 20 74 68 65 20 |.specifying the |
00002280 62 75 66 66 65 72 20 61 64 64 72 65 73 73 20 61 |buffer address a|
00002290 6e 64 20 74 68 65 20 6c 65 6e 67 74 68 20 6f 66 |nd the length of|
000022a0 20 64 61 74 61 20 62 65 69 6e 67 20 73 65 6e 74 | data being sent|
000022b0 2e 20 54 68 69 73 20 6d 61 79 20 62 65 0a 69 6d |. This may be.im|
000022c0 6d 65 64 69 61 74 65 6c 79 20 66 6f 6c 6c 6f 77 |mediately follow|
000022d0 65 64 20 62 79 20 20 61 6e 6f 74 68 65 72 20 50 |ed by another P|
000022e0 75 74 52 65 63 6f 72 64 2e 0a 0a 45 78 70 61 6e |utRecord...Expan|
000022f0 64 43 6f 64 65 20 3c 73 74 72 69 6e 67 3e 0a 0a |dCode <string>..|
00002300 52 65 71 75 65 73 74 73 20 74 68 65 20 65 78 70 |Requests the exp|
00002310 61 6e 64 65 64 20 66 6f 72 6d 20 6f 66 20 61 20 |anded form of a |
00002320 63 6f 64 65 20 75 73 65 64 20 69 6e 20 61 20 66 |code used in a f|
00002330 69 65 6c 64 20 6c 69 6e 6b 65 64 20 74 6f 20 61 |ield linked to a|
00002340 20 76 61 6c 69 64 61 74 69 6f 6e 0a 74 61 62 6c | validation.tabl|
00002350 65 2e 20 54 68 65 20 70 61 72 61 6d 65 74 65 72 |e. The parameter|
00002360 20 73 74 72 69 6e 67 20 63 6f 6e 73 69 73 74 73 | string consists|
00002370 20 6f 66 20 74 68 65 20 63 6f 64 65 20 69 74 73 | of the code its|
00002380 65 6c 66 2c 20 74 68 65 6e 20 61 20 73 70 61 63 |elf, then a spac|
00002390 65 2c 0a 74 68 65 6e 20 74 68 65 20 6e 61 6d 65 |e,.then the name|
000023a0 20 6f 66 20 74 68 65 20 76 61 6c 69 64 61 74 69 | of the validati|
000023b0 6f 6e 20 74 61 62 6c 65 20 77 69 74 68 20 74 68 |on table with th|
000023c0 65 20 63 6f 6c 75 6d 6e 20 6e 75 6d 62 65 72 20 |e column number |
000023d0 61 70 70 65 6e 64 65 64 2e 0a 45 78 61 6d 70 6c |appended..Exampl|
000023e0 65 20 6f 66 20 75 73 65 3a 0a 0a 20 20 3a 50 6f |e of use:.. :Po|
000023f0 77 65 72 62 61 73 65 20 45 78 70 61 6e 64 43 6f |werbase ExpandCo|
00002400 64 65 20 54 20 47 72 6f 75 70 30 20 20 20 20 20 |de T Group0 |
00002410 20 20 20 20 20 20 20 20 20 0a 0a 47 65 74 45 78 | ..GetEx|
00002420 70 61 6e 64 65 64 20 3c 73 74 72 69 6e 67 3e 0a |panded <string>.|
00002430 0a 43 6f 6d 62 69 6e 65 73 20 74 68 65 20 66 75 |.Combines the fu|
00002440 6e 63 74 69 6f 6e 73 20 6f 66 20 47 65 74 46 69 |nctions of GetFi|
00002450 65 6c 64 20 61 6e 64 20 45 78 70 61 6e 64 43 6f |eld and ExpandCo|
00002460 64 65 2c 20 69 2e 65 2e 20 69 74 20 72 65 71 75 |de, i.e. it requ|
00002470 65 73 74 73 20 74 68 65 0a 65 78 70 61 6e 64 65 |ests the.expande|
00002480 64 20 66 6f 72 6d 20 6f 66 20 74 68 65 20 63 6f |d form of the co|
00002490 6e 74 65 6e 74 73 20 6f 66 20 61 20 73 70 65 63 |ntents of a spec|
000024a0 69 66 69 65 64 20 66 69 65 6c 64 2e 20 54 68 65 |ified field. The|
000024b0 20 70 61 72 61 6d 65 74 65 72 20 73 74 72 69 6e | parameter strin|
000024c0 67 20 69 73 0a 73 69 6d 69 6c 61 72 20 74 6f 20 |g is.similar to |
000024d0 74 68 61 74 20 66 6f 72 20 45 78 70 61 6e 64 43 |that for ExpandC|
000024e0 6f 64 65 2c 20 65 78 63 65 70 74 20 74 68 61 74 |ode, except that|
000024f0 20 74 68 65 20 66 69 65 6c 64 20 74 61 67 20 69 | the field tag i|
00002500 73 20 73 75 62 73 74 69 74 75 74 65 64 20 66 6f |s substituted fo|
00002510 72 0a 74 68 65 20 63 6f 64 65 2e 20 0a 45 78 61 |r.the code. .Exa|
00002520 6d 70 6c 65 20 6f 66 20 75 73 65 3a 0a 0a 20 20 |mple of use:.. |
00002530 3a 50 6f 77 65 72 62 61 73 65 20 47 65 74 45 78 |:Powerbase GetEx|
00002540 70 61 6e 64 65 64 20 47 50 20 47 72 6f 75 70 30 |panded GP Group0|
00002550 0a 0a 7d 0a |..}.|
00002554 
.