Err2:The database is now full. Either extend it or delete records if you wish to make further additions.
Err3:There's no such field.
Err4:Date not valid %0
Err5:Input not on validation list %0
Err6:Search formula too complex.
Err7:%0 is too long for field.
Err8:Unrecognized field (%0) in search formula.
Err09:Field not numeric.
Err10:New value too long.
Err11:You have entered a zero_length key!
Err12:Can't make global changes to current key field.
Err13:Operation forbidden on key fields.
Err14:Your password doesn't allow you to do this.
Err15:\Tdatabase you are currently using!
Err16:All data fields must be tagged.
Err17:Design record format first.
Err18:Colours file not found.
Err19:This is not a Form file.
Err20:Tags may not be duplicated.
Err21:The two record formats are not identical.
Err22:New form file doesn't exist.
Err23:You are already using %0 fields, which is the configured maximum. Edit line 1 of Powerbase's 'Config' file to show a value greater than %0.
Err24:Not a runnable database. Check for absence of Form/Database files.
Err25:Record is not blank.
Err26:Key cannot be longer than field(s)!
Err27:Data merge abandoned.
Err28:New application directory has no Form file.
Err29:Escape pressed. Printing abandoned.
Err30:No fields defined!
Err31:Validation table %0 not found.
Err32:You are already using %0 tables, which is the configured maximum. Edit line 3 of Powerbase's 'Config' file to show a value greater than %0.
Err33:No pathname. Drag file icon to a directory viewer.
Err34:Which fields do you wish to export? Use ADJUST to select them.
Err35:All defined data fields have a data-length of zero!
Err36:\TForm file you are currently using.
Err37:Primary key %0 already exists. Duplication not allowed.
Err38:Heading cannot be wider than column.
Err39:Data transfer failed - Receiver died.
Err40:Search formula not understood.
Err41:CSV file abandoned. File may be incomplete.
Err42:Configured maximum for table columns is %0. Edit line 5 of Powerbase's 'Config' file if you need more.
Err43:Escape pressed. Indexing abandoned.
Err44:Calculation formula too complex.
Err45:Primary key %0 already exists. 'OK' will insert record with same primary key, 'Cancel' will ignore this record.
Err46:Unknown command (%0) in script file.
Err47:Clear table? (Data can be recovered with "Undo all" from this menu provided you have not closed the table.)
Err48:Change primary key? (Cancel will leave entire record unchanged.)
Err49:Rotate files.
Err50:Index %0 already exists. Overwrite?
Err51:Delete record permanently?
Err52:Not all the records to be removed are empty. If you proceed some data will be permanently lost
Err53:Remove field.
Err54:Table must have at least one more column if specified field is to be used in a calculation.
Err55:Record %0 is not in use.
Err56:Record number for key %0 is outside file limits.
Err57:Escape pressed. Script execution aborted.
Err58:Number too small.
Err59:Number too big.
Err60:Expression following NOT must be in brackets.
Err61:Records cannot be accessed in this way because list has been sorted.
Err62:No fields defined yet. Click MENU and choose "Design field".
Err63:Closing down database on RAM disc. Changes not copied to permanent storage.
Err64:Maximum field length is 246 characters.
Err65:Longest field is too long even for vertical format.
Err66:Database full when reading CSV file.
Err67:Escape pressed. Search for duplicate primary keys aborted.
Err68:Execute script file '%0'?
Err69:You must create an empty database before you can import data into it.
Err70:Attempt to compact list abandoned.
Err71:Database size cannot be zero or negative! Defaulting to 100 records.
Err72:Increment cannot be negative! Defaulting to 25 records.
Err73:Unrecognized field in calculation formula %0.
Err74:Escape pressed. CSV file import abandoned.
Err87:Unrecognised field tag (%0) in CSV header record.
Err88:Can't make a database unless CSV file has a header which includes field data.
Err89:No field data in CSV header.
Err90:No printer driver installed.
Err91:No linked directory. To establish the link drop the directory on the button.
Err92:Left margin needs to be 9 or greater if you want to do column calculations on first selected field
Err93:Unmatched quotes in search formula.
Err94:Time not valid (%0 out of range).
Err95:You are already using %0 subsidiary indices, which is the configured maximum. Edit line 2 of Powerbase's 'Config' file to show a value greater than %0.
Err96:Too many indices. The following have not been loaded: %0
Err97:Too many validation tables. The following have not been loaded: %0
Err98:Maximum number of fields allowed in a record is 127. Where DID you get this Form file?
Err99:Unable to find log file: logging suspended.
Err100:Field %0 is used in your primary key. You may create another index on it if you wish but it is likely to confuse the user.
Err101:Time not valid (hours, minutes and seconds must be separated by a non-numeral).
Err102:(day month and year must be separated by a non-numeral).
Err103:Please give your table a name.
Err104:Please specify number of rows.
Err105:Key length cannot be zero.
Err106:%0 is the currently-active index and may not be overwritten.
Err107:This is not a working database so you can't merge from it.
Err108:Copies of password don't match.
Err109:Database length is not a multiple of record length. Click on OK and the fault will be rectified. If it occurs again with this database please contact Powerbase Support.
Err110:No room for another column of this width (maximum is %0).
Err111:Operation abandoned. At least one record would be lost because it generates a null primary key.
Err112:No columns defined!
Err113:No matching records for %0
Err114:Import CSV data into table?
Err115:Delete object? Are you sure?
Err116:Sequence number %0 must be indexed and be the currently-active key.
Err117:You are already using %0 pop-up menus, which is the configured maximum. Edit line 4 of Powerbase's 'Config' file to show a value greater than %0.
Err118:(month out of range)
Err119:(day out of range: max = %0)
Err120:(year not 2 or 4 digits)
Err121:(too long for field)
Err122:Attempt %0 to open %1 with I.D. %2 and password %3.
Err123:Remove %0 from access control list?
Err124:There's no user called %0
Err125:Null passwords are not allowed.
Err126:No user I.D. entered.
Err127:Sequence number %0 must be the currently-active key.
Err128:Sequence numbers will be re-allocated so that there are no gaps in the sequence. WARNING: this operation cannot be undone.
Err129:Sorry, you aren't allowed to call a database or file 'Powerbase'.
Err130:This is a copy of the previously displayed record. If you make no changes it will be ignored, otherwise it will be added to the file as a new record.
Err131:More CSV data in input file than there are records to modify. Operation terminated.
Err132:With this option selected no new records will be created. The database will be traversed in key order and each record modified with the supplied CSV data. USE WITH CAUTION!
Err133:Create default database? (100 records with %0 as primary key)
Err134:Customisation library from %0 is still resident. Re-start Powerbase to obtain customised features for %1.
Err135:Customisation library %0 attempts to redimension an array used in Powerbase itself. Customised features not implemented.
maindrag:Position field by dragging with \s. Change size of box by dragging with \a. Descriptor may be positioned independently.
main2:Accepts only capital letters, numerals and decimal point.
main3:Accepts only numeric data.
main4:Accepts only Y and N.
main5:Accepts only valid dates in British format (DD-MM-YY or DD-MM-YYYY).
main6/main7:Value is determined by other fields: you can't enter data directly.
main8:Only accepts a time in the form hh:mm:ss
main9/main10/main11/main12/main13/main14/main15/main16/main17/main18/main19/main20/main21/main22/main23/main24/main25/main26/main27/main28/main29/main30/main31:This is a control button. \Sproduce same effect as corresponding keypad button.
main32:\Senter a search formula for printing a report.
main33:\Sdisplay menu which may be used to enter data into field at left.
main34:\Sclose the database.
main35:\Sopen a directory on the filing system. Drop the required directory on the button to establish the link.
main36:This is an External Text field. Drop a text file here to attach it to the record. \Sedit the file.
main37:This is an External Sprite field. Drop a Sprite file here to attach it to the record. \Sedit the file.
main38:This is an External Draw field. Drop a Draw file here to attach it to the record. \Sedit the file.
main39:This is an External Text block field. Drop a text file here to display it and attach it to the record. Double-\Sedit the file.
main40:This is an External Picture field. Drop a Sprite file here to display it and attach it to the record. Double-\Sedit the file.
main41/main42/main43:Field is a check-box. \Stoggle its status.
main44:\Srun a file. Drop the required file on the button to establish the link. Text files are treated as Powerbase scripts, other files trigger relevant Run action (where defined).
main45:\Squit Powerbase
main46:Record number. Not editable.
main47:Sequence number. Not editable.
main48:Time stamp. Not editable.
main49/main50/main51:Date stamp. Not editable.
main52:Date and time. Not editable.
main53:Day of week. Not editable.
main54:Day of month. Not editable.
main55:Month. Not editable.
main56:Month number. Not editable.
main57:Year. Not editable.
main58:Date record last altered. Not editable.
main59:This is merely a logo. Not editable.
HelpList:This is a list produced by a database query. It may be saved to disc as a plain text file and also sorted if the header is restricted to the first page only. Click MENU to access these options.
HelpTable:This is a validation table. \Ainclude columns in a report. ('Expand' switch in Print Options \w must also be selected.) Double-\Senter value into record field which has the caret. Click MENU to access other options.
keypad0:\S"flip" through records in forward direction. \Areverse direction. Increase "fast forward" interval (top centre) to reduce speed.
keypad1:\Sstop automatic scan.
keypad2:\Sgo to first record in subfile. \Ago to last.
keypad3:\Sgo to last record in subfile. \Ago to first.
keypad4:\Smove forward one record. \Areverse the action.
keypad5:\Smove back one record. \Areverse the action.
keypad6:\Smove forward by number of records shown at left. \Areverse the action.
keypad7:\Smove back by number of records shown at right. \Areverse the action.
keypad8:\Smake next index active. \Areverse the action.
keypad9:\Smake previous index active. \Areverse the action.
keypad10:\Sview next subfile. \Areverse the action.
keypad11:\Sview previous subfile. \Areverse the action.
keypad13:\Ssearch for a key in current subfile. Use \a if you want to search ALL subfiles.
keypad14:\Sadd new record to current subfile. \Amake a copy of currently-displayed record.
keypad15:\Smove displayed record into next subfile, e.g. from subfile 1 to 2. \a moves it to previous subfile, e.g. from 1 to 0. Hold down Shift while clicking if you wish to "follow" the record into the new subfile.
keypad16:\Smove displayed record into previous subfile, e.g. from subfile 1 to 0. \a moves it to next subfile, e.g. from 1 to 2. Hold down Shift while clicking if you wish to "follow" the record into the new subfile.
keypad17:"Yea, from the table of my memory I'll wipe away all trivial fond records." (Hamlet Act 1, Scene 5). \Sactually DELETE the displayed record from the database. Requires confirmation.
keypad18:\Sview allowed values for the field which has the caret. Only relevant if field is linked to a validation table.
keypad19:\Ssave the displayed record and all indices and validation tables. Only really necessary as an insurance against power-loss.
keypad20:\Sstore the contents of the field which has the caret on the clipboard.
keypad21:\Sretrieve the contents of the field which has the caret from the clipboard.
keypad22:Select to make browse controls access only those records which match a certain specification.
keypad23:Enter "fast wind" interval here. (Also controls the speed of autoscan.)
keypad24/keypad25/keypad26/keypad27:"Bookmarks" If a record number is shown \Sgo to record, otherwise "remember" current record. \Aclear marker.
keypad29:\Sdisplay menu of special features for this database.
keypad30:\Sopen special \w for this database.
filter0:\Sactivate new filter.
filter1:\Scancel filter and close this \w.
filter3:\Sclose this \w leaving filter still active.
search1:Enter the key to search for and click on Find or type Return. You may also enter # followed by a record number.
search3:\Tname of the index which will be searched.
search5:Select to limit search to current subfile.
search6:Select if you want all subfiles searched. Appropriate subfile will be selected if record is found.
search7:Number of records found which match entered key will be displayed here.
search8:\Sproceed with search.
search9:\Sretrieve last key used.
search11/search12:\Schange index to be searched. This does NOT affect the "currrently-active" index as set via the keypad.
query0:Enter a search formula here and click on cream-bordered button or type Return. Wild-cards are permitted (see icon-bar menu, Preferences).
query1:Select if you want upper/lower case letters to be matched exactly. Deselect if case is to be disregarded.
query2:\Sretrieve last search formula used.
query3:\Sobtain help with entering search formulae.
query4:Select to list records in reverse order in reports and CSV files.
move2:Move matching records to next subfile (e.g. 0 to 1, 5 to 0).
move0:Move matching records to previous subfile (e.g. 1 to 0, 0 to 5).
move1:Delete matching records permanently.
move3:Collect records which match search formula from ALL subfiles and gather them in the subfile entered on the right.
move6:Number of subfile in which all records matching search formula are to be collected.
move8:Undo last move/delete operation.
move7/change3:Proceed with action defined above. (You will be asked for confirmation.)
size1:Defined number of records in database
size3:If greater than 0 database will be expanded by this number of records when it becomes full, instead of reporting an error.
help0:Use bump icons or menu to select tag of search field.
help2:Print record only if search field exactly matches target string.
help11:Print record only if search field does NOT match target string.
help5:Print record only if field contains a value greater than that of target string.
help4:Print record only if field contains a value less than that of target string.
help13:Print record only if field contains a value greater than or equal to that of target string.
help14:Print record only if field contains a value less than or equal to that of target string.
help3:Print record if target string is contained somewhere in search field.
help15:Print record if target string is not contained anywhere in search field.
help6:\Ttarget string. Comparisons are made between it and the contents of the search field to decide whether or not to print the record.
help9:\Sinclude "AND" in multi-criterion searches.
help10:\Sinclude "OR" in multi-criterion searches.
help1:\Sinvert logic of next search criterion.
help7:\Sadd defined element to search formula.
help19:\Sdisplay menu of all fields.
help21:Blank the search formula writable icon.
match0:Proceed with report (or count if 'Count only' button selected).
match1:Shows time taken to produce a report OR number of matching records found in a Count operation.
match2:\Sprint displayed record. The use of Ctrl with the 'Print' key has a related effect.
match3:Select to count matching records without generating a report.
match4:Select if you want record numbers as first column of report.
match6:Select to include selected key of each record in report.
match7:\Sdisplay order of fields selected for printing.
match5/savesub4/tabcreate3/change6/fkey7/key36/move11/acl11/link14/save3/savesub3/size5/reform5/search10/calc3/help20/grid10:\Sclose this \w without further action.
tabcreate0:Give the table a suitable name.
tabcreate1:Specify the number of table entries.
tabcreate2:Proceed with creating table as specified.
tabcreate8/tabcreate10:Enter a column number and click \s on 'Goto' to display relevant column width and heading in centre of scrolling pane at left.
tabcreate11/col11:When selected clicking on icons at right will alter foreground colours.
tabcreate12/col12:When selected clicking on icons at right will alter background colours.
tabcreate13:\Schoose colour for column headings. \Acycle in opposite direction.
tabcreate14:\Schoose colour for data in table. \Acycle in opposite direction.
change0:Specify the field value which is to be changed. A null entry causes all values to be changed.
change1:Specify value which is to replace the above. If the field is numeric you may perform simple calculations by entering "+15" or something similar. +, -, / and * may all be used.
savesub0:When Powerbase icon shows here drag it to a filer \w to create subset of records. When CSV icon shows the result will be creation of a CSV file.
savesub1:\Sexport data under the displayed pathname
savesub2:Enter filename here and drag icon to filer \w. If a full pathname is present you may simply click on Export or type Return.
save0:Enter filename below and drag icon to filer \w. If a full pathname is present you may simply click on Save or type Return.
save1:\Ssave under the displayed pathname
save2:Enter filename here and drag icon to filer \w. If a full pathname is present you may simply click on Save or type Return.
print1:Use field tags as column headings in Horizontal & Table formats or as row labels in Vertical format.
print2:Use field descriptors as column headings in Horizontal & Table formats or as row labels in Vertical format.
print5:Expanded pica
print6:Condensed
print7:Pica
print8:Elite
print10:Print title/header information on 1st page of report only. (This allows the list to be sorted and still remain useful.)
print11:Print expanded versions of coded, validated fields.
print12:Print all alphabetic output in upper case, regardless of original case.
print15:Enter number of blank columns required in table.
print16:Number of lines per page. Should be 70 for A4, 66 for US letter.
print17:Enter 2 for double-spaced, 3 for triple-spaced output.
print18:Optional title to appear at head of report.
print19:Print date and time report created at head of list.
print23:Print report in formatted table, one record per row, with columns aligned.
print24:Print report with each field on a separate line, preceded by tag or descriptor.
print25:Print report as a table with blank columns for filling in by hand.
print26:Print address labels on special stationery. (Click for label setup.)
print29:Underline all output to printer. (It will not appear underlined on the screen but will be underlined when the file is printed.)
print30:Number of blank character spaces at left edge of page.
print32:Number of blank lines at top of page.
print34:Line length used for printing External text fields in vertical format.
print38:Output appears in a \w from which it can be saved as a text file.
print39:Output goes directly to a user-specified text file.
print40:Reduce white space between columns in Horizontal format by using actual rather than allowed maximum lengths of fields.
print41:Output goes straight to printer and cannot be saved to disc.
print42:Include control characters for condensed, underline etc when report is saved.
print43:Enter separator to be printed between columns in Horizontal and Table format. A numeral means use that number of spaces; anything else is taken as a literal string.
print45:Width of blank columns in Table format.
print47:Print database name, search criteria, index used, optional date stamp and optional title at head of list.
print48:Print total of records printed.
print54:Print page number at foot of each page of report.
label0/label1/label2/label26:Select number of labels across a row.
label4/label5:Specify horizontal distance (in inches) between left edge of one label and the next.
label6/label7:Specify vertical distance (in inches) between top of label row and top of next row.
label10:Number of lines from record on label. Does not include special start or finish line, field for substitution (if any) or key (if included).
label11:When selected the last line selected from the record will be subsituted for a user specified line where the latter is blank.
label12:Line of label to replace with substitute line if the former would otherwise be blank.
label13:Select if you want the primary key to appear on the label as an aid to identification.
label16:Select if you want to suppress any blank lines in the label data.
label17:You may set this to a value greater than 1 if you want multiple copies of each label.
label20:Last line of label. Not printed unless line specified at right is blank.
label24:Text to be printed as a header line before the record-specific data on every label.
label25:Text to be printed as a footer line following all the record-specific data on every label.
passwd2:The "read" password. Permits the user to examine records and print lists, but not to make any alterations.
passwd3:The "write" password. Permits the user to add, delete and edit records, to create indices, and to create and edit validation tables.
passwd5:The "manager" password. Gives access to all Powerbase facilities including the ability to restructure the database (and to set passwords!).
passwd7:These switches enable you to enable or disable various features to control database use.
passwd9:Keypad is available when selected. Deselect to suppress keypad.
passwd10:When selected most keypad actions and many menu choices have keystroke equivalents. Deselect to suppress them.
passwd11:MENU button over main \w brings up the menu. Deselect to suppress main menu.
passwd12:MENU button over icon brings up icon-bar menu. Deselect to suppress icon-bar menu.
passwd13:When selected the user may export data as CSV files and subset databases. Deselect to prevent this.
passwd14:When selected reports may be printed. Deselect to prevent printing of reports.
passwd15:When selected primary keys may be duplicated. Deselect to enforce unique primary keys.
passwd16:When selected a log is maintained of database usage. Deselect to disable logging.
passwd17:\Senter I.D.s and personal passwords for users.
acl0:Enter name by which user will be known.
acl1:Enter password. (It will not be visible as you type.) To change an existing password re-enter I.D. above and type in new password.
acl12:Enter password again. (Checks whether you made a mistake.)
acl3:Select to remove user's I.D. from access-control list.
acl4:Select to give user read-only access.
acl5:Select to give user read and write access.
acl6:Select to give user manager access.
acl9:\Senter user in access-control list.
create28:Use bump icons or menu to select field type required. (Field types are grouped into classes which are selected using radio buttons below.)
create21:Fields in this class are all directly writable by the user.
create24:Fields in this class toggle between two states when clicked on with \s.
create23:These are duplicates of the control buttons on the keypad and are provided for users who wish to suppress the keypad and place all controls on the record \w.
create22:These are fields linked to a separate text or graphics file which is stored in the database directory.
create35:These fields are automatically "stamped" by Powerbase under appropriate circumstances. They cannot be edited by the user.
create47:Fields in this class are self-calculating
create48:These are additional buttons which have no keypad equivalent but might prove useful.
create4:Label used to identify field on screen. (May be null.)
create5:Name by which field is identified in searches. Must be unique and can only be null if field is merely a label with no associated data.
create6:Maximum number of characters which may be entered in field.
create7:x co-ordinate of lower left corner of bounding box.
create8:y co-ordinate of lower-left corner of bounding box
create9:Width of bounding box.
create10:Height of bounding box.
create15:Lowest value which may be entered in a numeric field. (Optional.)
create25:Highest value which may be entered in a numeric field. (Optional.)
create14:Select if you wish to store a numeric field in fixed-point format and enter number of decimal places at right.
create13:Number of decimal places for numbers in fixed-point format.
create30:\Sdelete the specified field.
create29:Effect alterations to existing field.
create39:\Schange field number to that entered above. Other fields will be renumbered as necessary to avoid duplication.
create40:\Sswap number of current field with that shown above. Numbers of fields other than these two are unaffected.
create42:\Smake width of bounding box correctly fit data length.
create44:\Sdisplay menu of fields. Choosing from menu displays data for chosen field.
create45:Select to round numbers to nearest integer.
create46:Select to retain numbers in floating-point format.
create49:\Ssnap all fields and descriptors to grid.
create50/create51/create52/create53:\S"nudge" fields into position. \a moves in opposite direction to arrow.
access0:This database is set up for access by specified users only. If you have been given a user I.D. type it here and your personal password in the field below.
access1:Enter password and click on "Open".
scroll:Enter width in characters and an (optional) heading for each column you require in the table. Use successive rows of this \w: avoid gaps.
prefs1:Powerbase will ensure that the character entered here is used as the day, month, year separator in all dates entered.
prefs4:Powerbase will ensure that the character entered here is used as the hrs, min, sec separator in all times entered.
prefs7:This character is used in search formulae to indicate a single character which need not be matched.
prefs10:This character is used in search formulae to indicate a group of characters which need not be matched.
prefs12:Double-clicking on a database normally closes any open one before opening the new one. Select this switch to launch another copy of Powerbase to open the new database.
prefs14:If selected then any Calculated or Composite fields for which TIME$ appears in the calculation formula will be recalculated for all subfiles on opening the database.
prefs15:Select to ensure that deleting a record destroys the actual data as well as removing its key(s) from the index(es).
prefs16:When creating a record layout deselect this switch if you wish to move fields and descriptors independently.
prefs17:Name of application which can request data from Powerbase via the ImpulseII module.
prefs19:When selected any field linked to a validation table will display its linked data to the right of the keypad.
prefs20:Select if you want to be warned before deleting external text fields or pictures.
prefs21:Data-entry validation is 'ON' if this switch selected.
prefs25:Interval in minutes at at which autosave or warning will occur.
prefs27:Save indices and tables every n minutes (n=value above).
prefs28:Warn user every n minutes but don't actually save.
prefs29:Autosave/warn OFF.
prefs30:The Case sensitive switch on the Query Panel will be selected by default if this switch is selected.
prefs31:Select to force index balancing at regular intervals.
prefs32:Index-balancing will occur every n records (n=value in this field) if switch at left is selected.
prefs34:Select if you wish to be warned before a primary key is duplicated.
prefs35/print51/csv19:Choices will be saved in current database, overriding Powerbase default.
prefs36/print50/csv18:Choices will be saved in Powerbase in place of existing default choices.
prefs37/print28/csv20:Load Powerbase default choices, overriding database's own choices (if any).
prefs38/print53/csv21:Save these choices for future use.
prefs40/print52/csv10/label19/passwd18:\Scancel changes just made to this \w, restoring the way it was when opened.
prefs41:If selected typing Return in a writable icon in a dialogue box exits with default action; otherwise this happens only in last writable icon in box.
prefs42:Select to remove "hidden" spaces at right of strings in writable icons. This happens only when using the Return key or cursor up/down arrow keys to move between icons - such spaces may still be introduced when moving with the mouse.
prefs43:If this switch is selected Powerbase remembers what record was displayed before a subfile change and displays that record on returning to the subfile. Otherwise the first record in a subfile is always displayed.
prefs44:Select if you want a CSV file of new and altered records to be created as you edit. File is called NewData and is in PrintJobs.
prefs45:The field where the caret is placed for editing may be entered here and saved with the other preferences.
prefs47:Select to remove leading spaces in strings. Only takes effect when record is written to file.
csv14:Character(s) used between items of data in exported and imported files. If a comma the file is called CSV, if a TAB it is TSV. Any character may be used, however, and all such files are referred to throughout Powerbase as CSV files.
csv15:Character(s) used to terminate each line of data in a CSV, or similar, file.
csv5:Display menu of separators. Last item allows you to specify your own.
csv6:Display menu of terminators. Last item allows you to specify your own.
csv0:Enclose each item of data in quotes. This enables you to include the separator/terminator as part of a string without it being interpreted as such. Quotes are stripped automatically on import.
csv1:Put extra line, specifying fields to which data belongs, at beginning of file.
csv2:Don't ignore fields which are blank: export/import as nulls.
csv3:Include primary key with exported data. On import write data to record with same key.
csv4:Include data about length and type of each field. File exported with this option set can be used to create a database from scratch.
csv11:When importing data, display each record.
csv13:Pathname of file dropped onto record \w.
csv16:Strip imported data of leading and trailing spaces.
csv22:Include record number with imported data. On import write data to record with same numbers.
csv23:When selected sequence numbers are assigned as if entering records by hand, i.e. ignoring values in CSV records. When deselected existing values from CSV file are used and sequence counter is not incremented.
csv24:When selected the imported data will be read into EXISTING records in key order, i.e. no new records will be created. USE WITH CAUTION!
calc0:Enter formula to calculate this field from contents of others then click on OK or type Return.
calc1:Accept formula
calc2:Scan current subfile and apply calculation to all records. If deselected only new records will be affected.
fkey0:This sprite tells you which keypad button you clicked MENU on.
fkey1:Select if you want to assign a Shifted function key.
fkey2:Select if you want to assign a function key used with Ctrl.
fkey3:The function key to be assigned to the button is displayed here.
fkey4/fkey5:Click to cycle through the allowed function keys.
fkey6:Assign the displayed key (with Shift, Ctrl, or neither) to the displayed button. Any previous assignment will be cancelled.
key0/key1/key2/key3/key4/key5/key6/key7:Click to select field tag.
key8/key9/key10/key11:\Sdisplay menu of fields - an alternative means of selection.
key12/key16/key20/key24:Selected field tag is displayed here.
key13/key17/key21/key25:Enter word number, e.g. 1 for first word in field, 2 for second.
key14/key18/key22/key26:Enter position in word. L for start of word, R for end of word, character number for other position.
key15/key19/key23/key27:Enter number of characters to be used.
key29:\Tnumber of the currently-selected key.
key30:Select if you want the indexing to take account of case.
key31:Create index based on key structure specified above.
key32:New primary key index will keep records in same subfiles as at present. Deselect to put all records in subfile 0.
key33:Take no account of old primary key index. All records will go into subfile 0 and even "deleted" records may be retrieved if they have not been blanked. Use if old index damaged or non-existent.
key35:Select if you want short keys (or segments thereof) to be padded to their defined length.
key37:Select to prevent insertion of zero-length keys into secondary indices.
link0:Name of chosen table.
link2:Column of validation table linked to field.
link3:Make/break link.
link4:Select to make link, deselect to break link.
link5/link6:Click to choose table for linking to field.
link7/link8/link11/link12:Click to choose column number.
link9:Select if you wish to have keyboard entry automatically replaced by value from the validation table.
link10:Column of validation table to substitute for keyboard entry.
link15:Deselect to allow input strings which begin with, but are longer than, the corresponding table entry. Strings shorter than the table entry are not allowed. If switch is selected the match must be exact.
link13:\Sdisplay menu of tables - alternative way to choose a table.
reform1:Drop database with new format file, or database to be merged, on this icon.
reform6:Proceed with merge or reformat operation.
reform7:Name of dropped file appears here.
reform8:When selected sequence numbers are assigned as if entering records by hand, i.e. ignoring values already in merged records. When deselected existing values from merged records are used and sequence counter is not incremented.
col0:\Schoose colour for primary key descriptor when key is selected. \Acycle in opposite direction.
col1:\Schoose colour for primary key data field when key is selected. \Acycle in opposite direction.
col2:\Schoose colour for primary key descriptor when key is deselected. \Acycle in opposite direction.
col3:\Schoose colour for primary key data field when key is deselected. \Acycle in opposite direction.
col4:\Schoose colour for secondary key descriptor when key is selected. \Acycle in opposite direction.
col5:\Schoose colour for secondary key data field when key is selected. \Acycle in opposite direction.
col6:\Schoose colour for secondary key descriptor when key is deselected. \Acycle in opposite direction.
col7:\Schoose colour for secondary key data field when key is deselected. \Acycle in opposite direction.
col8:\Schoose foreground colour for data field linked to validation table. \Acycle in opposite direction. Background colour cannot be changed.
col9:Apply colours to database but don't save.
col10:Apply colours to database and save in database directory for future use.
col15:Load default colours.
merge1:\Tname of the document into which data is to be merged.
merge3:Merge next matching record.
merge4:Print document with merged data as displayed.
merge5:Select if you want document to be printed each time a record is merged.
merge6:Start merge operation.
merge7:Close this \w and restore document to initial state.
merge8:Merge previous matching record.
merge9:Merge last matching record.
merge10:Merge first matching record.
merge11:Key field(s) of record currently being merged.
merge12:Number of documents printed in this merge session.
merge14:Name of application whose document is to receive the merged data. Should be left as Impression even when using Style or Publisher.
merge16:Make document editable and saveable with currently visible data merged. Be careful not to save with original filename or you will overwrite document containing merge commands!
grid0:Turn layout grid on or off.
grid2:\Scycle through colours for grid lines. \Ato go in opposite direction.
grid3:Use solid lines for grid.
grid4:Use dotted lines for grid.
grid5:Snap fields to grid when created or moved.
grid8:This is the spacing (in OS units) between the grid lines.
grid9:This is the interval (in OS units) to which fields will snap when created or adjusted.
grid11/grid12:\Salter line spacing by 2 OS units each time.
grid13/grid14:\Salter snap interval by 2 OS units each time.
grid?/grid??:\Tgrid-defining \w. It is used to set up a grid for laying out the record design.
prefs?/prefs??:\Tpreferences \w. It is used to choose settings which determine how Powerbase works for you.
passwd?/passwd??:\Tpassword-setting \w. It is only accessible if you have "Manager" access or if no passwords at all are set. Many other aspects of database access are also controlled from here.
print?/print??:\TPrint Options \w.
csv?/csv??:This \w sets the options for CSV file creation and import.
main?/main??:\Trecord \w. \Ahighlight fields for inclusion in a report. The order in which fields are highlighted is the order in which they will be printed.
keypad?/keypad??:\Tkeypad. Click MENU to set keystroke-equivalents for the buttons.
query?/query??:The area bounded by a red line is the Query Panel. It appears on any \w which can accept a search formula.
move?/move??:This \w is used to move or delete sets of records all of which match the entered search formula.
size?/size??:This \w defines the size of the database
help?/help??:This \w provides a way of entering search formulae for users unfamiliar with Powerbase's query language.
match?/match??:\TMatch \w which is used to interrogate the database.
tabcreate?/tabcreate??:This \w is used to create Validation tables.
savesub?/savesub??:This \w is used to export data either as a CSV (or similar) file or as a fully-working database consisting of a subset of records from the current database.
save?/save??:\Tstandard Save box which is used for general file-saving throughout Powerbase.
acl?/acl??:This \w allows you to create an access-control list for the database in which individual users have their own I.D.s and passwords.
create?/create??:\Tform-creation \w which you use to design the database record.
access?/access??:The fact that this \w has appeared at all means that the database is password-protected.
calc?/calc??:Formulae for Calculated and Composite fields are entered in this \w.
fkey?/fkey??:This \w is used to set up function keys to produce the actions of the keypad. Any exisiting key assignment is displayed.
key?/key??:This \w is used for defining key-structures for the primary key and for subsidiary indices. It also gives details about the currently-selected key.
change?/change??:This \w is used for making changes which affect a set of records matching a search formula.
link?/link??:This \w is used to make or break links between data fields and validation tables.
col?/col??:This \w lets you chose foreground and background colours for the primary key field, other key fields and fields linked to validation tables.
reform?/reform??:This \w is used when merging databases or when rebuilding a database to an altered format.
