home *** CD-ROM | disk | FTP | other *** search
- Powerbase v 5.06 3rd September 1994
- ================ ==================
-
- Powerbase version 5.06
- © Derek & Steven Haslam 1989-1994
-
- Powerbase Support, 112 Keighley Road, Colne, Lancashire BB8 0PH
-
- Please make cheques payable to Derek Haslam.
-
- Copyright subsists in all versions of Powerbase. We reserve the right
- to withdraw support and authorisation to distribute Powerbase.
-
- No warranty, express or implied, is made about the suitability of
- Powerbase for any purpose. We can not be held responsible for any loss
- or damage to your health, wealth or marriage due to the action or
- inaction of Powerbase.
-
- Powerbase is shareware. You are allowed to copy it freely as long as
- you do not do so for any profit, and that the application is kept
- intact and unchanged. If you find you use Powerbase on a regular
- basis, you should register your copy with us. For £10.00 you will get
- support and "free" upgrades.
-
- We are always pleased to hear from users of Powerbase and are
- grateful for the useful suggestions we have had for improvements,
- additions etc. Upgrades are supplied as needed rather than on a
- regular basis. If you encounter any problems or need an additional
- facility, please send a disc with the program and database that you
- are using and give as much information as possible about how and under
- what circumstances the program misbehaves. Additional example
- databases will be sent on request; just send a disc and tell us which
- ones you already have.
-
- Powerbase is unlikely to run from an archive or to use an archived
- database: !CDList in the Examples archive gives a buffer overflow error
- instead of loading.
-
- Contact us at:
- Powerbase Support, 112 Keighley Road, Colne, Lancashire BB8 0PH
- When registering, please send cheques payable to Derek Haslam.
- PSTN Voice: +44-(0)282-866835
- e-mail addresses deleted; Steven is at Robinson College, Cambridge
-
- The database !Elements is used extensively as an example in the
- tutorial, and !Friends is used in the quick tutorial. Other example
- databases are available to show the flexiblity of Powerbase.
-
- Major updates will be sent to Arcade BBS, and to the Datafile PD Library,
- APDL, ArchAngel, and RiscUser.
-
-
- Powerbase users should be aware that the use of a database to store
- personal details other than those of immediate family members may
- render them liable for registration/compliance with the provisions of
- the Data Protection Act. (Data Protection Registrar, Springfield
- House, Water Lane, Wilmslow, SK9 5AX. Tel. 0625-535777)
-
- Important note to existing users of versions prior to 4.93 (NOT 4.993!!)
- ========================================================================
- v.4.93 was the first to allow indices to be case sensitive. If you create
- a database using that, or a later, version and try to run it on any
- version of Powerbase prior to v.4.93 an error will occur. It is usually
- either "String too long" or "Address exception". The problem is most
- likely to afflict a user who is given a database by someone using a recent
- version and who then tries to run it on an earlier one.
-
- It is also possible for a database created with, and working
- satisfactorily with, a pre-4.93 version to suddenly start giving errors
- after being used on a later version. This will only happen if indices have
- been created, or the primary key rebuilt, under the later version.
- Deleting the contents of the Indices directory may then put matters right.
- If it doesn't then rebuilding the primary key under the older version
- will.
-
- The problem was alleviated somewhat in v.4.98. Databases created with this
- will work on earlier versions of Powerbase provided you do NOT make any
- index case-sensitive.
-
- The best solution, of course, is to send us a disc with sae (or 4 first-
- class stamps; discs don't really enjoy postal journeys) and ask for an
- upgrade. There is NO problem running databases created with a version
- EARLIER than 4.93 under a version LATER than 4.93.
- =========================================================================
-
-
- v.4.995 11 February 1994
- ========================
- Please note the following:
-
- (1) Clicking SELECT over a data field with CTRL held down enters the
- field tag into a search formula if the caret is in a search formula
- icon (e.g. in the 'Match' window).
-
- (2) Holding down SHIFT whilst moving a record to the next or previous
- subfile allows you to "follow" the record to its new location.
-
- Previous versions used ALT for both these purposes and the two uses
- were found to clash - (2) didn't work when using a customised record
- format in which the keypad buttons were on the record window itself.
- In view of this and the fact that Acorn's guidelines discourage the
- use of ALT for keyboard shortcuts the keys above were substituted.
-
- v. 4.998 6 March 1994
- =====================
- It is sometimes useful for a key to be generated from a key-field
- without paying any attention to word boundaries. e.g. If the key
- length is 8 then it is composed of the first 8 non-space characters
- regardless of how many words are involved. This facility has now been
- adopted as the default. Simply clicking on an option switch before
- creating the index returns you to the familiar "characters from up to
- four" words system.
-
- v. 4.999a 10 April 1994
- =======================
- A "Use index" button, identical in function to the one in the "Match"
- window has been added to the CSV export window.
-
- A new script command !CSV <search formula> allows the creation of a batch
- of CSV files from a script file.
-
- v. 4.999d 15 May 1994
- =====================
- In previous versions deleting a record (as opposed to shifting it into an
- adjacent subfile) only removed the keys from the indices: the actual
- record data was still present in the file 'Database' and could be
- recovered by rebuilding the primary key without reference to the existing
- one. This is sometimes undesirable so an option has now been provided in
- the 'Config' file to make deleted records blank. The option is "ON" by
- default.
-
- A switch has been added to the 'Match' window to allow the record number
- to be printed as part of a report. The switch (which is "OFF" by default)
- is accessed by toggling the 'Match' window to full size.
-
- To the "column calculations" on numeric fields (count, sum, mean, S.D.)
- maximum and miniumum have now been added.
-
- Mail merge with Computer Concepts' Impression Publisher (version 4.01
- and later) works exactly as for ImpressionII. Do NOT change the name
- of the merging application in the writable icon to "Publisher"; leave
- it as "Impression". Mail merge with Computer Concepts' Impression
- Style (version 3.03 and later) works when the name of the merging
- application in the writable icon is changed to "Style". The current
- version of Powerbase also supports the new Impression single-file
- format (&bc5).
-
- v.4.999g 20 May 1994
- ====================
- It is now possible to query Memo and Text block fields to find out if
- they contain (or do not contain) a string.
-
-
- v. 5.0 27 July 1994
- ===================
- An extra option button has been added to the key-definition window to give
- more control over situations where, for example, the key calls for four
- letters from a word but the actual word is shorter than this. The default
- action (as previously) is to use the whole word in such cases, but not add
- anything to the end. Setting the new 'Pad with spaces' switch would cause
- enough spaces to be added to make up the specified 4 characters. This can
- be especially helpful for the alphabetic ordering of personal names.
-
- v. 5.01 9 August 1994
- =====================
- The default field type when creating a new database is now Type 0
- (unrestricted) rather than Type 1 (Alphanumeric) as in previous
- versions. This field type has no list of allowed characters in its
- validation string and therefore accepts any printable character. A further
- change is that the keyboard status is not changed from its previous value
- when the caret enters a field of Type 0. Field types 2 (Upper case) and
- 4 (Yes/No) cause Caps Lock to be selected, as previously, and all other
- field types cause Caps Lock to be deselected.
-
- Note for RISC PC users
- ----------------------
- Be sure to read the file RISC_PC on the distribution disc before
- attempting to create a new database.
-
- v. 5.03 16 August 1994
- ======================
- An annoying bug in the index-creation routine sometimes caused the
- database to be scanned rapidly (with hourglass and percentage display) but
- the resulting index would be empty. It was especially apt to occur when
- indexing after making a gobal change or printing a report. This bug has
- now been fixed.
-
- v. 5.06 3 September 1994
- ========================
- Minor bug which caused check-boxes to vanish while validation was turned
- off has been fixed.
-
- NOTE for RISC OS 2 users
- ========================
- Some versions of Powerbase give an error during initialisation. This is
- apparently due to a bug in RISC OS 2 which causes corruption of the BASIC
- stack if a window template with a name shorter than 4 letters is used!
- (No, I don't understand it either!) RISC OS 3 doesn't mind such short
- template names at all. If any RISC OS 2 user experiences problems, please
- write for version 5.07 or later.
-
-
-
-
-
-