Amiga Format 76

home *** CD-ROM | disk | FTP | other *** search

/ Amiga Format 76 / af076a.adf / archives / af76a2.lzx / datanexus / DataNexus.Help < prev next >

Wrap

Text File | 1995-07-31 | 95.4 KB | 2,992 lines

##-- GENERAL -- ##SCROLLUP SCROLL LIST: UP This button makes the list scroll up. SHORTCUT: Cursor Up. NOT on all scrollers. ##SCROLLDOWN SCROLL LIST: DOWN This button makes the list scroll down. SHORTCUT: Cursor Down. NOT on all scrollers. ##PROPSCROLL LIST SCROLL: BAR By grabbing the scroll bar, the list may be moved up or down. ##-- DRAG BAR HELP -- ##QUIT QUIT DATANEXUS The quit button will close down DataNEXUS, freeing all allocated resources. ##SNOOZE ICONIFY The iconify button will send DataNEXUS to sleep, leaving a small window on the Workbench screen which can be used to wake DataNEXUS. ##SYSFRONT DEPTH GADGET The depth gadget operates in the same way as the OS depth gadget. ##SYSBACK $$SYSFRONT ##SYSDRAG DRAG BAR The drag bar allows the DataNEXUS screen to be moved up and down. ##-- MAIN PANEL -- ##DBBEGINING RECORD: FIRST Goto the first record in the current database or filter range. SHORTCUT: Shift + Cursor left. ##DBPREVIOUS RECORD: PREVIOUS Goto the previous record in the current database or filter range. SHORTCUT: Cursor left. ##DBGOTO REGOTD: GOTO Goto a specific record in the current database or filter range. ##DBNEXT RECORD: NEXT Goto the next record in the current database or filter range. SHORTCUT: Cursor right. ##DBLAST RECORD: LAST Goto the last record in the current database or filter range. SHORTCUT: Shift + Cursor right. ##DBINDEX DATABASE: SORT The sort button opens the sort panel which allows the current database to be sorted, or a sorted index removed. NOTE: All searching functions work from the first to last record in an index. Searches are slower to perform when the index is in reverse order, or if the database is sorted. ##DBFILTER DATABASE: FILTER The filter button opens the filter panel, which allows a search filter to be created. If one or more filters exist, then the filter list window is opened, which allows filters to be created edited, used or removed. SHORTCUT: CTRL + f. NOTE: Deleted records cannot be included in a filtered range. NOTE: Also used to create field validation sequences. ##DBEDIT RECORD: EDIT The edit button and menu item places DataNEXUS into edit mode, where the contents of the currently displayed record can be changed. **EDITKEYS MOVEMENT KEYS ##DBADD RECORD: ADD The add button and menu item will add a new record to the current database and then place DataNEXUS into edit mode. **EDITKEYS MOVEMENT KEYS ##DBPROP RECORD: VERTICAL SLIDER This slider may be used to scroll the record card up and down. SHORTCUT: Cursor Up and Down. ##DBDONE EDIT: DONE The 'DONE' button is only displayed whilst editing or adding a new record. Selection will complete the add or edit, only if all field validators are satisfied. SHORTCUT: Left Amiga + TAB. ##DBABORT EDIT: ABORT The 'ABORT' button will abort the editing/adding of a record. Abort edit, will restore the current record with its previous contents. Abort add, will not add the new record to the database. SHORTCUT: Escape. ##DBMORE EDIT: COMPLETE, ADD ANOTHER The 'MORE' button is only displayed whilst adding a new record. Selection will complete the add, only if all field validators are satisfied. SHORTCUT: Left Alt + TAB. ##DBSCANFWD SCAN RECORDS: FORWARDS The scan will display all displayable records from the current to the last record. All record control buttons are replaced with DONE and PAUSE buttons. The DONE button will stop the scan, whereas the PAUSE button will pause the scan. SHORTCUT: ALT + Cursor Right ##DBSCANBACK SCAN RECORDS: BACKWARDS The scan will display all displayable records from the current to the first record. All record control buttons are replaced with DONE and PAUSE buttons. The DONE button will stop the scan, whereas the PAUSE button will pause the scan. SHORTCUT: ALT + Cursor Left ##DBRECPROP RECORD: RECORD SLIDER The record slider allows any record in the current database or filter range to be viewed by manipulating it. ##DBFIND RECORD: FIND Find can be used to create a simple filter. An empty record will be presented, into which any valid data can be typed. All fields with data will be 'AND'ed together for the filter. Eg. if 'Fred' is entered in the NAME field, and '32' into the AGE field, then DataNEXUS will search for records in which NAME contains the text 'Fred' and AGE is 32. NOTE: Text fields allow partial matching, whereas other field types require an exact match. ##DBPROPDOWN FIELD: SLIDE DOWN This slider makes the record card scroll down. SHORTCUT: Cursor down. ##DBPROPUP FIELD: SLIDE UP This slider makes the record card scroll up. SHORTCUT: Cursor up. ##--RECORD DISPLAY AREA -- ##DBFIELDS RECORD: DISPLAY This area is where fields are displayed. Some fields have 'hot- spots' which are activated when selected. TEXT - fields may have up and down arrows which scroll the text. EXTERNAL - fields have left and right arrows which scroll the text. The remainder of the external field is the hot-spot for activating the file named in the field. **SUPTYPES Click to see list of recognised file types. ##DBFIELDSDEF DEFINITION: FIELD DISPLAY Selecting a field enables the field to be moved. Selecting the solid rectangle (bottom right of field) will allow the field size to be changed. If, however, one of the following buttons is pressed prior to selecting the field, then the action performed is as indicated. SWAP - Allows two fields to be swapped around. The numbers in the top left of the field indicate the field order. REMOVE - Allows a field to be removed from the new database. EDIT - Allows a field to be modified or it's type changed. NOTE: Whilst moving a field, the use of the vertical slider (on the right) may be used to position the field further up or down the record card. NOTE: Whilst moving a field, the use of the ESCAPE key will abort the move and replace the field to its original position. ##DBFIELDSFILT FILTER: FIELD DISPLAY By selecting a field, a filter may be created or extended. When a field is selected, the filter is examined to see if there is an expression already there. If so then the separator requester is shown, allowing an expression separator to be chosen (see below). Next an operator requester is displayed where an operator for the expression may be selected. Entering the data for the expression is the last step in building a filter expression. ::OPERATORS Key : NUM = Numerical, TXT = Textual, CHR = Chronological = - NUM/TXT/CHR exact equals. <> - NUM/TXT/CHR does not equal. > - NUM/TXT/CHR greater than. >= - NUM/TXT/CHR greater than or equal to. < - NUM/TXT/CHR less than. <= - NUM/TXT/CHR less than or equal to. CONTAINS - TXT contains the following. NOT CONTAINS - TXT does not contain the following. ALLOWED - TXT which only contains the following characters Some characters are always allowed. SPACE, CARRIAGE RETURN, TAB and NEWLINE. NOT ALLOWED - TXT which does not contain the following characters. Some characters cannot be excluded SPACE, CARRIAGE RETURN, TAB and NEWLINE. LIKE - TXT which matches an **PATMATCH AmigaDOS pattern matching expression. EMPTY - Field which does not contain any data. NOT EMPTY - Field which contain some data. ::SEPARATORS AND - The AND separator performs a logical AND. For example, (Name CONTAIN 'Mr') AND (Salary > £10000.00) will select all records of people whose NAME contains 'Mr' AND have a salary of more than ten thousand pounds. Example | Truth Table | Miss. Smith earns £200 - Not Selected | FALSE AND FALSE = FALSE Mr. Smith earns £200 - Not Selected | TRUE AND FALSE = FALSE Miss Smith earns £2000 - Not Selected | FALSE AND TRUE = FALSE Mr. Smith earns £2000 - Selected | TRUE AND TRUE = TRUE OR - The OR separator performs a logical OR. For example, (Name CONTAIN 'Mr') OR (Salary > £10000.00) will select all records of people whose NAME contains 'Mr' OR have a salary of more than ten thousand pounds. Example | Truth Table | Miss. Smith earns £200 - Not Selected | FALSE OR FALSE = FALSE Mr. Smith earns £200 - Selected | TRUE OR FALSE = TRUE Miss. Smith earns £2000 - Selected | FALSE OR TRUE = TRUE Mr. Smith earns £2000 - Selected | TRUE OR TRUE = TRUE NOT - The NOT separator performs a logical NOT on the right operand and then a logical AND. For example, (Name CONTAIN 'Mr') NOT (Salary > £10000.00) will select all records of people whose NAME contains 'Mr' AND do NOT have a salary of more than ten thousand pounds. Ie., Example | Truth Table | Miss. Smith earns £200 - Not Selected | F AND (NOT F) = FALSE Mr. Smith earns £200 - Selected | T AND (NOT F) = TRUE Miss. Smith earns £2000 - Not Selected | F AND (NOT T) = FALSE Mr. Smith earns £2000 - Not Selected | T AND (NOT T) = FALSE EOR - The EOR separator performs a logical EOR. For example, (Name CONTAIN 'Mr') EOR (Salary > £10000.00) will select all records of people whose NAME contains 'Mr', or have a salary of more than ten thousand pounds, but not if both are true. Ie., Example | Truth Table | Miss. Smith earns £200 - Not Selected | FALSE EOR FALSE = FALSE Mr. Smith earns £200 - Selected | TRUE EOR FALSE = TRUE Miss. Smith earns £2000 - Selected | FALSE EOR TRUE = TRUE Mr. Smith earns £2000 - Not Selected | TRUE EOR TRUE = FALSE **FLTERRORS ERROR MESSAGES ##DBFIELDSEDIT EDIT: FIELD DISPLAY Whilst editing the current record, various keys are to move the cursor around the record card. **EDITKEYS MOVEMENT KEYS ##DBFIELDSINDX SORT: FIELD DISPLAY Selecting a field will choose it for sorting. Some field types cannot be used for indexes. DataNEXUS will warn you if you attempt this. ##DBFIELDSFIND FIND: FIELD DISPLAY Entering data into one or more fields, using the edit record keys, allows DataNEXUS to build a temporary filter, which is used to find specific record(s). Numeric fields are checked for equality, and text fields are checked to see if they contain the match text. **EDITKEYS MOVEMENT KEYS ##-- PROJECT MENU -- ##NEWDATABASE NEW DATABASE Create a new database from scratch, or use an existing database (any file with .FDEF suffix) as a template. ##LOADDATABASE DATABASE: OPEN Open a database for use. The file requester will hide all non database files. DataNEXUS currently supports up to ten simultaneously open databases. If two or more are opened, a new menu becomes available. This menu allows easy activation of any opened database. Any database may only be opened once. A database which is password protected will require a password to be entered. The default password allows access at a set level. ##SAVEDATABASE DATABASE: CLOSE Close the current active database, saving all changes made to any filters, passwords, print forms etc. ##PACKDATABASE DATABASE: PACK Close the current active database, saving all changes made to any associated filters, passwords, print forms etc. In addition, DataNEXUS will ask whether blank spaces and deleted records are to be removed permanently. NOTE: DataNEXUS supports variable length records, when records are edited, their lengths may change, and spaces may appear in the record file. ##SAVECOPY DATABASE: SAVE COPY Save copy has three functions: **SCBACKUP BACKUP **SCSAVEAS SAVE AS **SCRANGE SAVE RANGE ##SCBACKUP BACKUP Backs up the current database to a different directory, or to the same directory with '-BK' appended to the name. ##SCSAVEAS SAVE: AS Saves the current database with a new name, leaving a copy of the database under the current name. ##SCRANGE SAVE: RANGE Saves the records in the current filter range to a new database that only contains these records. The original database is left unchanged. This allows the easy creation of sub databases built on powerful selection criteria. ##SCCANCEL SAVE: CANCEL Cancels the save database operation. ##EDITDATABASE DATABASE: EDIT Edit database allows limited editing of the current database definition and form. Operations allowed include: changing field names and resizing, repositioning and changing the display format of some field types. ##HELP HELP The Help button on the keyboard invokes the on-line help. To obtain help for a specific button or menu, move the mouse pointer over that button or menu and press the HELP key on the keyboard. Some buttons in DataNEXUS invoke the online help directly. These are used to explain the current panel. :: MISCELLANEOUS **PATMATCH AMIGADOS PATTERN MATCHING **TOOLTYPES AVAILABLE TOOLTYPES **TROUBLE TROUBLESHOOTING ::PROJECT MENU **NEWDATABASE NEW DATABASE **LOADDATABASE OPEN DATBASE **SAVEDATABASE CLOSE DATABASE **PACKDATABASE PACK DATABASE **SAVECOPY SAVE DATABASE **EDITDATABASE EDIT DATABASE ::RECORD MENU **DUPRECORD DUPLICATE RECORD **IMPORTDATA IMPORT DATA **EXPORTDATA EXPORT DATA **DELETERECORD DELETE RECORD **SHOWDELETED SHOW DELETED ::PRINT MENU **PRINTLABELS PRINT LABELS **PRINTMERGE PRINT MERGE ::MISC MENU **PASSWORDDB PASSWORDS **REBUILD REBUILD **CALCULATOR CALCULATOR ::MAIN PANEL **DBBEGINING GOTO FIRST RECORD **DBPREVIOUS GOTO PREVIOUS RECORD **DBGOTO GOTO RECORD **DBNEXT GOTO NEXT RECORD **DBLAST GOTO LAST RECORD **DBINDEX SORT DATABASE **DBFILTER FILTER DATABASE **DBEDIT EDIT RECORD **DBADD ADD RECORD **DBSCANFWD SCAN DATABASE FORWARDS **DBSCANBACK SCAN DATABASE BACKWARDS **DBRECPROP RECORD SLIDER **DBFIND FIND RECORD ##ABOUT ABOUT The about menu will display the about requester, detailing important revision information and product date. ##-- RECORD MENU -- ##ADDRECORD $$DBADD ##EDITRECORD $$DBEDIT MOVEMENT KEYS ##DUPRECORD RECORD: DUPLICATE Duplicate record will add a copy of the current record to the current database, then enter EDIT mode. If there is a UNIQUE field in the database, care must be taken when using this function, ie, ensure that the unique field data is changed before completing the duplicated record. **EDITKEYS MOVEMENT KEYS ##IMPORTDATA RECORD: IMPORT ASCII DATA Import allows a specially formatted ASCII file to be imported; creating new records. The import requester allows fields in the ASCII file to be joined together, multiple spaces to be removed and allows the specification of the order of the fields. DataNEXUS attempts to analyze the file to determine the record and field delimiters. If this produces incorrect results, two buttons are provided to facilitate experimentation, on which characters are used for delimiters. Commonly used delimiters are comma and linefeed. The import panel displays the first record in the ASCII file to make field matching easier. DataNEXUS may also import ASCII data formatted in columns, to select this mode, there is a pop up menu when the import panel is open. ##EXPORTDATA RECORD: EXPORT ASCII DATA Export allows data from the current database to be sent to a formatted ASCII file, which facilitates data transfer to other databases. The Export requester allows the field order and delimiters to be set. Additionally all fields may be enclosed in quotation marks. ##DELETERECORD RECORD: DELETE Selecting this menu item will take the current record and place it in the deleted record pool. It will no longer be available in the active record list. The record is not permanently deleted unless you go into the SHOW DELETED menu and then select PURGE. Selecting UNDELETE from the SHOW DELETED area will return the record to the active records list. **PACKDATABASE See Also CLOSE & PACK. ##SHOWDELETED RECORD: SHOW DELETED This menu will switch from showing the active records in the database to the currently deleted records. The deleted records pool may be accessed in the same way as the active record pool except that the user also has the option to permanently purge (erase) records from the database). When in SHOW DELETED mode a menu of options is available. ##PURGERECORD RECORD: PURGE Purge record will remove the current record from the database. NOTE: Purged records are permanently removed from the database. ##UNDELRECORD UNDELETE RECORD UnDelete record will return the current record to the active records pool. NOTE: Deleted records may not be recovered after the database has been packed and deleted records removed. **PACKDATABASE PACK DATABASE ##--- PRINT MENU --- ##PRINTLABELS PRINT: LABELS Print labels facilitates the printing of the current database's data onto labels, using a layout editor. Further help is available for the printer related icon tool types. **PRINTERTT PRINTER TOOL TYPES ##PRINTMERGE PRINT: MERGE Print Merge allows data from a specified field in a database to be merged into a letter or document (written using a word processor or text editor). The document MUST be stored as plain ASCII with no embedded formatting information. To insert fields from a database, there are three special characters which may be used, '&', '@' and '#'. & - Insert the named field between 2 & symbols. @ - Insert the named field between 2 @ symbols with fixed length so columns may be created. # - Insert the named field between 2 # symbols and remove any linefeeds present (useful for inserting multi line text fields). For example, Gratis Goods Ltd. 1 Huwlocks Lane WALES &Name& &Address& Dear &Name& ..... The Typeface may be controlled with the '^' symbol. The four options are ^B (Bold), ^I (Italic) , ^U (Underline) and ^P (Plain). Bold, Italic and Underline are toggles. This means the first occurrence will enable the mode and the second will disable it. Plain (^P) will cancel any current bolding, italicising and underlining. To print a control character, write that character twice. For example, '&&' will print as '&', and '^^' as '^'. Further help is available for the printer related icon tool types. **PRINTERTT PRINTER TOOL TYPES ##--- PREFS MENU --- ##SHOWNUMRECS PREFS: FILE SIZE DISPLAY This toggle effects the behaviour of DataNEXUS' file requester. The two states are: FILE REQ SIZE - The file requester shows the size of the database definition file next to the file name. FILE REQ RECORDS - The file requester shows the number of records in the file next to the file name. ##SAVEICONS PREFS: SAVE ICONS This toggle has two states: SAVE ICONS - Add an icon to each database file saved. NO SAVE ICONS - Do not add any icons. NOTE: The default tool in the created icon specifies the full path name of the DataNEXUS program. Therefore, moving a database to another machine may invalidate auto-loading by double-clicking the icon. The path can be changed by using Workbench's Information command from it's Icons menu. ##PASSWORDDB PREFS: PASSWORD This menu item invokes the password editor, from which passwords can be added or edited. You will have to enter the MASTER password (if there is a master password) to gain access to the editor, otherwise the password panel will open immediately. ## ----------------------------- EXTERNAL PREFS MENU ----------------------------- ##PLAYMODE EXTERNAL: IFF FILE PLAYMODE The playmode menu item has three options. The playmode affects 8SVX and ANIM files only. RAMPLAY IFF - Read the entire file into RAM before playing. Animations flash the screen once loaded, at which point, press the left mouse button to play. DISKPLAY IFF - Spool the file from disk (useful for very large files or where memory is limited). There may be some loss of performance, especially when spooling from floppy disks. AUTOPLAY IFF - Automatically selects which of the above two modes to use, RAM PLAY takes priority if you have enough memory. ##CENTERING EXTERNAL: IMAGE CENTERING The image centering menu item has two options. The centering affects ILBM and ANIM files only. H/W CENTER - Center the image inside the Amiga's hardware display window, with some monitors, portions of the display may not be visible. PREFS CENTER - Center the image within the current preferences display window. ##CYCLE EXTERNAL: IFF COLOUR CYCLING The cycling menu item has two options. The cycling affects ILBM and ANIM files with active colour cycling ranges set. COLOUR CYCLING ON - Enables colour cycling. Cycling may be toggled on/off using the [TAB] key on the keyboard. COLOUR CYCLING OFF - Disables colour cycling. Any image which contains colour cycling will NOT cycle. ##ANIMREPT EXTERNAL: ANIMATION REPEAT The ANIMATION REPEAT menu item has two options. The repeat affects ANIM files only. AMIM ONCE - Play once and hold on last frame until user presses an escape key. ANUM REPEATING - Loop play, until user presses an escape key. ##HIFI EXTERNAL: AUDIO FILTER The audio filter menu item has two options. AUDIO FILTERON - When any sounds are played, the Amiga's audio filter will be enabled. This may reduce the hiss associated with low quality audio samples, but reduces the quality of samples over 14Khz. AUDIO FILTEROFF - When any sounds are played, the Amiga's audio filter will be disabled. ##AUDIOREPT EXTERNAL: AUDIO REPEATS The REPEAT menu item has two options. The repeat affects 8SVX 8 bit samples files only. AUDIO ONCE - Play once. AUDIO REPEATING - Play until escape key pressed. ##ANIMSPED EXTERNAL: ANIMATION SPEED This menu item has three options. The repeat affects ANIM files only. ANIM DEFAULT SPEED - Play animations at the default speed set by the animation file, eg. DPaint's frame rate ANIM MAX SPEED - Play animations as fast as possible. ANIM STEP FRAMES - Play a frame at a time, using the space bar to proceed to the next frame. A frame count is displayed top center of the screen. ##XLSPEED EXTERNAL: CDXL SPEED This menu item has four options. The menu is used to control the playback speed of CDXL video files. XL DEFAULT SPEED - Play a XL file at the default speed set within the CDXL file. XL SINGLE SPEED - Play the CDXL file at CD-ROM single speed (150Kb/s) rate. XL DOUBLE SPEED - Play the CDXL file at CD-ROM double speed (300Kb/s) rate. XL MAX SPEED - Play the CDXL file as fast as the hardware and disk drive will go. NOTE: The above settings assume the read speed of the storage device is fast enough for the playback transfer rate. If the CDXL playback breaks up, then you are specifying a transfer rate faster than your drive or network can handle. ##XLDISP EXTERNAL: CDXL HEIGHT This menu item has two options. This option only works on AGA machines with OS3.1 (Kickstart V40 and upwards). SINGLE HEIGHT - Display CDXL file normally. DOUBLE HEIGHT - Doublescan the CDXL file, doubling it's height. This will not work if mode promotion is on. ## ----------------------------- MISC MENU ----------------------------- ##DBSTATUS DATABASE: STATUS The status requester will display a field listing of the fields in the current database, and some other miscellaneous details. If a field is selected, then the field type, format and flags will be displayed. ##STATUS DATANEXUS: STATUS The status requester shows available memory, disk storage on the drive the current database is stored and how many databases are open. ##REBUILD INDEX AND TABLE REBUILD If a read record error message occurs, it may indicate that one internal index is corrupt. Rebuild will attempt to rebuild the any indexes and tables. RECORD - The record index maintains the whereabouts of all records in a record file. SORT - The sort index is the same as a RECORD index, keeping records sorted. FILTER - The filter index maintains the whereabouts of all records which match the filter criteria. This index changes the scope of the slider bar and record movement buttons. FIELD - Not really a table, but allows specific field types to keep track of data, ie. SUMMARY field. UNIQUE - The unique index maintains a list of the data in the fields with the unique flag set. NOTE: Deleted records cannot be included in a filtered range. **TROUBLE TROUBLE SHOOTING GUIDE ##CALCULATOR CALCULATOR The calculator solves complex expressions. The expression can be built by a combination of typing and clicking. Two lists are displayed. The left list contains a list of numeric based fields from the current database. The right list contains all the operators available. Entries from these lists can be clicked on, to add them to the end of the current expression. After an expression has been entered and the CALC button pressed, the expression will be solved and the result displayed in the message area. If the calculator could not evaluate the expression, then you will be told why, and be given the opportunity to modify it and try again. Before an expression is evaluated, each reference to a field is replaced with the value of the field in the current record, in the current database. **AVAILABLEOPS AVAILABLE OPERATORS ##-- DATABASE MENU -- ##SELECTDB1 SELECT DATABASE Select Database will make the database named on the menu legend the current active database. ##SELECTDB2 $$SELECTDB1 ##SELECTDB3 $$SELECTDB1 ##SELECTDB4 $$SELECTDB1 ##SELECTDB5 $$SELECTDB1 ##SELECTDB6 $$SELECTDB1 ##SELECTDB7 $$SELECTDB1 ##SELECTDB8 $$SELECTDB1 ##SELECTDB9 $$SELECTDB1 ##SELECTDB10 $$SELECTDB1 ##-- NEW DATABASE PANEL -- ##NDADD NEW: ADD FIELD Adds a new field to the new database. A list of all supported fields and drawing tools is presented. Each field may have one or more attributes which can be set from the requester. UNIQUE - Only one field may be unique. An unique field MUST contain different data in each record. REQUIRED - The field MUST contain some data. VALIDATED - The contents of the field MUST conform to some criteria. Eg. greater than 100. **DBFILTER See filter. READONLY - All fields are initially empty. Empty read only fields can be edited, but once a field contains some data, it becomes read only (ie. constant) and un-editable (unless the read only flag is removed). NOTE: The first character of a field name must be alphabetic. All other characters may alphanumeric. ##NDEDIT NEW: EDIT FIELD Edit allows the characteristics of a field to be changed. The name, type, flags and format can be changed. ##NDCLONE NEW: CLONE FIELD Clone allows a field and it's attributes to be copied, creating a new field. The new field may not have the same field name. Drawing tool field types may not be cloned. ##NDREMOVE NEW: REMOVE FIELD Remove will permanently remove a field from the database being defined. ##NDSWAP NEW: SWAP FIELDS Swap fields is used to swap the order of two fields. This is used for selecting the order in which data is entered into fields. ##NDXHAIR NEW: TEE SQUARE TOGGLE The tee square is useful for aligning fields in the X or Y axis. To move the cross-hairs, simply drag them to the desired position. The tee square will lock to a grid, if one is set. ##NDGRID NEW: SNAP TO GRID The grid requester allows a grid to be enabled, disabled or modified. Whilst a grid is active, all field and drawing tools will snap to the grid. This facilitates easy alignment of fields within a form. ##NDTALLER NEW: MAKE CARD TALLER Make card taller, will add height to the record display card. This allows fields to be placed on a large card, of which only a portion will be visible. Once the database definition has been saved, the card height will be modified so that it just accommodates the lowest field or drawing tool. ##NDFINISHED NEW: FINISHED Selecting this button will accepts the new database definition. ##NDCANCEL NEW: CANCEL Cancels the new database definition and frees any associated resources. ##-- NEW FIELD REQUESTER -- ##NFDISPLAY NEW FIELD: TYPE LIST This list shows all field and drawing tools supported by DataNEXUS. They are: Text Field - Alphanumeric characters. Cycle Field - Multiple choice. Number Field - Numeric information. Date Field - Chronological information Time Field - Chronological information Calculation Field - Calculation that may involve any number fields within a record. Summary Field - Summary of number fields scoping the whole database or a range of records. External Field - Stores a file name. When an external field is selected in view mode, the file type is automatically determined, and the file is viewed / played. Eg. animations are shown and sounds are played. This could for example, be used by a radio station to implement a jingle playing database. Unique Field - A unique number will automatically appear each time a new record is added. This could be used, for example, to assign membership numbers to new customers. Text Tool - Used to add text to the record card. This could, for example, be used to give a group of fields a heading. Rectangle Tool - Used to add rectangles to the record card for cosmetic purposes only. Line Tool - Used to add lines to the record card for cosmetic purposes only. ##NFPROP $$PROPSCROLL ##NFUP $$SCROLLUP ##NFDOWN $$SCROLLDOWN ##NFUNIQUE NEW FIELD: UNIQUE TOGGLE If this button is depressed, the field will be made into a unique field. The contents of a unique field may be duplicated in another record in the database but must be changed in the duplicated record to avoid a duplication error when the record is completed. Only one field in a database may be a unique field. ##NFREQUIRED NEW FIELD: REQUIRED TOGGLE If this button is depressed, the field will be made into a required field. This type of field cannot remain empty (ie. it must contain some data). ##NFVALIDATED NEW FIELD: VALIDATION TOGGLE If this button is depressed, the field will require a field validator, in the form of a filter. When entering data into a validated field, only data that passes the validation check is allowed. **DBFIELDSFILT FILTERS ##NFREADONLY NEW FIELD: READ ONLY TOGGLE If this button is depressed, then the field will not be editable after the first time data is entered into the field and the record accepted. ##NFNAME NEW FIELD: NAME A new field obtains it's name from this button. Typing on the keyboard at any time whilst the new field requester is displayed, will place the text into this button. ##NFOK NEW FIELD: ACCEPT The accept button will accept the new field name, type and flags, and then call the appropriate field specific requesters, for defining the field format, size etc. before allowing the field to be positioned on the record card. Fields and field names may be re-positioned at any time, by selecting and then moving them. In addition, any field with a solid rectangle inside any corner, may be resized. To do this, click on the rectangle and move the mouse. The record card scroll bar remains active when positioning fields, allowing them to be moved up and down the card easily. ##NFCANCEL NEW FIELD: CANCEL Cancels the operation of adding a new field to the new database. ##-- STATUS PANEL -- ##DSOK STATUS: OK The OK buttons will close the status requester. ##DSDISPLAY STATUS: FIELD LIST The field list contains the names of all fields in the current database. To obtain further details on a particular field, select it. ##DSDOWN $$SCROLLDOWN ##DSPROP $$PROPSCROLL ##DSUP $$SCROLLUP ##--- CYCLE FIELD REQUESTER --- ##DCDISPLAY CYCLE FIELD: RESPONSE LIST The list button contains all the responses the cycle field will allow. Selecting a response makes it current and available for editing or deleting. Duplicated responses are NOT allowed. The cycle field requires at least two responses (this will behave as a boolean field (ie. YES/NO type field). ##DCPROP $$PROPSCROLL ##DCUP $$SCROLLUP ##DCDOWN $$SCROLLDOWN ##DCENTER CYCLE FIELD: NAME The text button accepts key strokes from the keyboard. ##DCADD CYCLE FIELD: ADD RESPONSE This button allows new choice text to be appended onto the end of the list of texts. This is the same as pressing the 'RETURN' key. ##DCINSERT CYCLE FIELD: INSERT RESPONSE This button makes room for a new choice text before the currently selected text in the list. ##DCDELETE CYCLE FIELD: DELETE RESPONSE This button will delete the currently selected response from the list. ##DCCANCEL CYCLE FIELD: CANCEL This button returns you to the form edit screen, abandoning the cycle field being edited. ##DCOK CYCLE FIELD: ACCEPT This button when selected, signifies that you are happy with the responses for the cycle field, and now wish to position the field on the record card. ##-- INDEX PANEL -- ##INCASE SORT: CASE SENSITIVITY This button is only available when a field is selected which supports case sensitivity. The button has two states: CASE SENSITIVE - Corresponding lower and upper case letters are considered different. Eg. 'a' is considered different to 'A'. CASE INSENSITIVE - Corresponding lower and upper case letters are considered the same. Eg. 'a' is considered the same as 'A'. ##INDIRECTION SORT: DIRECTION This button determines the order of the sort. It has two states: ASCEND - The records will be ordered from lowest to highest. Ie. from 'a' to 'z', minus infinity to infinity. DECEND - The records will be ordered from highest to lowest. Ie. from 'z' to 'a', infinity to minus infinity. ##INOK SORT: ACCEPT This button will sort the database on the selected field. This operation involves reading the required field from each and every record in the current database and may, therefore, take some time. ##INREMOVE SORT: REMOVE This button erases the current sort table. This has the effect of losing any ordering of the records. ##INCANCEL SORT: CANCEL This button cancels any changes made to the state of the current sort table, leaving it unchanged. ##-- NUMBER FIELD REQUESTER -- ##NMNUMUP NUMBER FIELD: INCREASE SIGNIFICANT DIGITS This button increases the number of digits to the left of the decimal point, the number will display, up to a maximum of 12. NOTE: Number fields can only have a maximum of 14 digits consisting of significant digits and decimal places. ##NMNUMDN NUMBER FIELD: DECREASE SIGNIFICANT DIGITS This button reduces the number of digits to the left of the decimal point, the number will display, down to a minimum of 1. ##NMDISPLAY NUMBER FIELD: DISPLAY This button shows the current number format. ##NMDECIUP NUMBER FIELD: INCREASE DECIMALS This button increases the number of decimal places the number will display, up to a maximum of 7 decimal places. NOTE: Number fields can only have a maximum of 14 digits consisting of significant digits and decimal places. ##NMDECIDN NUMBER FIELD: DECREASE DECIMALS This button reduces the number of decimal places the number will display. ##NMCURR NUMBER FIELD: CURRENCY SYMBOL This button allows you to enter a currency symbol that can appear before or after the number. **NMPREFIX CURRENCY PRE/POSTFIX ##NMPREFIX NUMBER FIELD: CURRENCY PRE/POSTFIX This button controls whether the currency symbol is placed before or after the number. Eg. Prefixed '£' : £1234.56 Postfixed 'p' : 120p ##NMSIGN NUMBER FIELD: SIGN This button controls whether positive numbers will be shown with a preceding plus sign. Minus numbers are always preceded with a minus sign. Eg., 123 will displayed thus: ' ' : 123 '+' : +123 ##NMLEADER NUMBER FIELD: LEADER This button controls what character will appear in 'unused gaps' to the left of the first digit of the number. This padding is only shown after editing. The characters that can be used to pad numbers are ' ' (space), '#', '*' and '0'. Eg. '0' padding of the number 123 in a 6 column field will yield 000123 ##NMSEP NUMBER FIELD: SEPARATOR This button controls whether the number will be interspersed with commas for improved legibility. Eg. 123456 will be displayed thus: ',' -> 1,234,456 ' ' -> 123456 ##NMOK NUMBER FIELD: ACCEPT This button, when selected, will accept the specified number field, and then allow it's positioning on the record card. ##NMCANCEL NUMBER FIELD: CANCEL This button will cancel the addition of the number field. ##-- DATE FIELD REQUESTER -- ##DDDISPLAY DATE FIELD: DISPLAY This button shows the current date format. ##DDFORMAT DATE FIELD: FORMAT ORDER This button controls the order in which the three elements of thee date are displayed. Eg. the 12 January 1993 will be displayed thus: 'DAY MONTH YEAR' : 12/JAN/1993 'MONTH DAY YEAR' : JAN/12/1993 'YEAR MONTH DAY' : 1993/JAN/12 ##DDYEAR DATE FIELD: YEAR FORMAT This button controls the year display format. Eg. 1969 will be displayed thus: 'YY' : 69 'YYYY' : 1969 NOTE: A date field can contain a date from 1 January 0000 to 31 December 9999. NOTE: if 'YY' is selected, the year can range from 00 to 99. ##DDMONTH DATE FIELD: MONTH FORMAT This button controls the month display format. Eg. March will be displayed thus: 'MM' : 03 'MMM' : MAR 'MMMM' : MARCH ##DDSEP DATE FIELD: SEPARATOR This button controls which character the date field uses to separate days, months and years. Eg. '/' : 12/01/1993 '-' : 12-01-1993 '.' : 12.01.1993 ##DDOK DATE FIELD: ACCEPT This button, when selected, will accept the specified date field, and then allow it's positioning on the record card. NOTE: A date field can contain a date from 1 January 0000 to 31 December 9998. NOTE: if 'YY' is selected, the year can range from 00 to 99. ##DDCANCEL DATE FIELD: CANCEL This button will cancel the addition of the date field. ##-- EXPORT PANEL -- ##FODISPLAY EXPORT: FIELD ORDER DISPLAY The field order display shows the order in which fields will be exported. Selecting a field in this area will select it for the next field to export (as long as it is not already selected). Any field in the display without a number to it's right will NOT be exported. NOTE: You will have to press the clear button first, before specifying your own order. **FOCLEAR CLEAR ##FOPROP $$PROPSCROLL ##FOUP $$SCROLLUP ##FODOWN $$SCROLLDOWN ##FORDELIM DELIMITER: RECORD The record delimiter contains the character which will be used to separate the records in the ASCII file. **DELIMITERS DELIMITERS ##FOFDELIM DELIMITER: FIELD The field delimiter contains the character which will be used to separate the fields in the ASCII file. **DELIMITERS DELIMITERS ##DELIMITERS DELIMITERS When exporting, it is best if the record and field delimiters are not set to the same value, even though it is allowed. When importing, if the record and field delimiters are identical, the number of fields cannot be calculated automatically, so a requester will ask you for the number of fields a record contains. Delimiter characters can be specified as follows: In hexadecimal. Eg. 0x0, 0xC, 0xFF As a literal character. Eg. ×, *, ¤, | As a 'C' escape sequence. Eg. '\b', '\f', '\n', '\r' ##FOENCLOSE EXPORT: ENCLOSE IN QUOTES The enclose quotes button controls whether each field is enclosed in double quotes or not. This option should be enabled if any field will contain the delimiter character. NOTE: This option should not be used if any exported field contains a single quote. This will confuse the import analyzer. ##FOOK EXPORT: START Start exporting all records (or filtered records) to a named file. ##FOCANCEL EXPORT: CANCEL Cancels the export operation. ##FOUNDO EXPORT: UNDO This button undoes the last field order selection. Multiple undoes are supported. ##FOCLEAR EXPORT: CLEAR FIELD ORDER This button will clear the current field order, therefore allowing a new order to be set up. ##-- FILTER PANEL -- ##DFSTRING FILTER: EXPRESSION This button holds the filter expression which can be entered and altered. NOTE: Manual editing of the filter expression is not recommended for novice users. ##DFUSE FILTER: USE This button activates the filter expression. A requester will ask you to name the filter, as DataNEXUS requires filters to be named. DataNEXUS will then attempt to create a range of records and inform you of the number of records found. **FLTERRORS FILTER ERROR MESSAGES NOTE: When no records are found the filter is turned off. NOTE: Only the first 32 characters of the name are used. NOTE: Deleted records cannot be included in a filtered range. ##DFFIELD VALIDATOR: FIELD This button is used for selecting the field, for inclusion in the field validator. ##DFCLEAR FILTER: CLEAR This button clears the filter expression. ##DFHELP FILTER: MORE HELP A filter consists of a sequence of simple expressions, eg. (Name CONTAIN "Bob") Each expression is separated with a separator. By selecting a field which the filter is to be based upon, DataNEXUS will follow through a sequence of events, which facilitates easy expression creation. ::EXAMPLE Below is an example filter broken down to it's two constituent parts. (Name CONTAIN "Bob") AND (Age > "10") (Name CONTAIN "Bob") - Matches records whose Name field contains somewhere within it the text "Bob". This could match for example "Bob Monkhouse", or "Bob George" (Age > "10") - Matches records whose Age field contains an age greater than ten. The two expressions are then logically anded together, which means a record must match BOTH expressions for it to be included in the filter range. ::QUOTING METHODS DataNEXUS does not limit the data quoting to " (double quotes) as you may wish to filter something with a " quote in it. eg. (Text CONTAIN ") correctly written as (Text CONTAIN '"') DataNEXUS allows various characters for its quoting around data (Text CONTAIN hello) (Text CONTAIN "hello") (Text CONTAIN 'hello') (Text CONTAIN {hello}) (Text CONTAIN [hello]) (Text CONTAIN :hello:) are all valid ways to write the expression. **FLTERRORS FILTER ERROR MESSAGES ##DFCANCEL FILTER: CANCEL This button will cancel any modifications made to the filter. ##DFTEST VALIDATOR: TEST Allows a validator sequence to be tested. ##-- LIST PANEL, FILTERS,PRINT -- ##LSDISPLAY LIST: DISPLAY This button shows a list of items. To select an item, position the mouse pointer over your selection and click with the left mouse button. ##LSPROP $$PROPSCROLL ##LSUP $$SCROLLUP ##LSDOWN $$SCROLLDOWN ##LSUSE LIST: USE This button accepts the highlighted item, then continues. ##LSNONE LIST: NONE This button forces DataNEXUS NOT to use any of the selections. ##LSEDIT LIST: EDIT This button allows the highlighted item to be edited. ##LSDELETE LIST: DELETE This button deletes the highlighted item. If the highlighted item has been assigned to a password, then deletion will be prohibited. ##LSNEW LIST: NEW This button allows the creation of a new item at the end of the list. ##LSCANCEL LIST: EXIT This button closes the list requester without accepting the selections made. ##-- IMPORT PANEL -- ##IOFIELDS IMPORT: FIELD LIST Selecting any field will place an order number beside the field name. Multi line text fields may have up to 8 contiguous import fields assigned to them. All other field types may only accept one import field. ##IOFILTERED IMPORT: WITH FILTER The imported data will be filtered before any new records are added to the database. ##IORDELIM $$FORDELIM ##IOFDELIM $$FOFDELIM ##IOCANCEL IMPORT: CANCEL Cancels the import operation. ##IODATA IMPORT: DATA LIST This list contains the analyzed data from the first record in the ASCII file. Should the data look odd, then try changing the record and field delimiters, until the display shows the file contents properly. This operation will clear the import field order, but which may be reinstated by using the ALL button. **DELIMITERS DELIMITERS ##IOFDOWN $$SCROLLDOWN ##IOFPROP $$PROPSCROLL ##IOFUP $$SCROLLUP ##IOALL IMPORT: START All records from the ASCII file will be imported, creating new records as each import record is processed. Below are various error situations explained. ::Duplicated unique data Should a unique field data be duplicated. In this situation a request will prompt for a response, skip this record, edit the offending field or abort the import. ::Incorrect data The data for a field is incorrect ie textual data going into a date or time field. In this situation a request will prompt for a response, skip this record, edit the offending field or abort the import. ::Other Errors There are other error sitiuations which will abort the import process. Record not saved - Could not save a record User abort - User aborted an import. I/O Error - Could not read data from the disk. Analysis error - Could not analyse the field structure in the ASCII import file. ##IODPROP $$PROPSCROLL ##IODUP $$SCROLLUP ##IODDOWN $$SCROLLDOWN ##IOCLEAR $$FOCLEAR ##IOUNDO IMPORT: UNDO Undo the last field order selection. Multiple undoes are supported. ##IOSKIP IMPORT: SKIP This button allows the next field to be skipped, allowing data in the import ASCII file to be ignored. ##IOSETALL IMPORT: SET ALL This button sets the field import order to the same as the database field order. ##IOPACK IMPORT: PACK TOGGLE This button is used to remove multiple spaces from fields in the import ASCII file, as the data is read in. ##IOHELP IMPORT: MORE HELP DataNEXUS is capable of importing data from databases which support an ASCII export facility. When importing data from a foreign database, a definition must be created in DataNEXUS first. The field order is not important, since DataNEXUS allows the field order to be changed, and fields skipped, when importing. DataNEXUS can also join more than one ASCII field into one DataNEXUS text field. Multi-line addresses may therefore be imported into one field. If within the ASCII file, fields are enclosed with the quote character, then DataNEXUS will report an ANALYZE ERROR. Try to export the data asking for no quoted fields. If importing with record and field delimiter the same, DataNEXUS will ask for the number of fields in the ASCII file, as the file analyser cannot determine this. The practice of using the same delimiters is not recommended. ##IODELMODE IMPORT: USE DELIMETER MODE Import delimiter mode allows importing of ASCII files which use record and field delimiters (one character each). ##IOCOLMODE IMPORT: USE COLUMN MODE Import column mode allows importing of ASCII files where each line contains one record and the fields are aligned into columns (no tabs allowed). ##IOCOLMARK IMPORT: USE COLUMN ENTRY Column entry allows the column positions to be entered (max 100) where the fields start. By pressing the return key after entering each entry the import data list will be updated allowing correct judgement. The format of the entry is as follows and columns MUST be in ascending order. 1,x,y,z,... ##-- FILE REQUESTER -- ##FRDIR FILEREQUESTER: DIRECTORY This button shows the current path name of the directory. ##FRCLEAR FILEREQUESTER: CLEAR The clear button erases the contents of the filename gadget. ##FRDRIVES FILEREQUESTER: DRIVES LIST TOGGLE This button will toggle between the list displaying the current directory, and a list of drives and assignments. ##FRDISPLAY FILEREQUESTER: DISPLAY This button shows the directory entries or drive list. Single clicking an entry will make that the current entry. Double clicking is the same as selecting the entry, then clicking the OK button. ##FRPROPDN $$SCROLLDOWN ##FRPROP $$PROPSCROLL ##FRPROPUP $$SCROLLUP ##FRPARENT FILEREQUESTER: PARENT DIRECTORY This button will select the parent of the currently displayed directory. This can be thought of as moving up the directory hierarchy. ##FRNAME FILEREQUESTER: FILENAME This button shows the name of the currently selected file, and can be used to type in a new name, using the keyboard. ##FROK FILEREQUESTER: ACCEPT This button accepts the file for the selected operation. ##FRCANCEL FILEREQUESTER: CANCEL This button cancels the disk operation. ##FRHIDE FILEREQUESTER: HIDE PATTERN MATCH This button is used to filter out files which you do not wish to show in the directory list, by entering an exclude pattern. **PATMATCH AMIGADOS PATTERN MATCHING ##FRSHOW FILEREQUESTER: SHOW PATTERN MATCH This button is used to filter in files which you wish to show in the directory list, by entering an include pattern. **PATMATCH AMIGADOS PATTERN MATCHING ##-- PASSWORD PANEL -- ##PWNAME PASSWORD: NAME Password names can be changed by entering a new name into this button. The master & default passwords may not have their names changed. ##PWPPROP $$PROPSCROLL ##PWPUP $$SCROLLUP ##PWPDOWN $$SCROLLDOWN ##PWADD PASSWORD: ADD Facilitates the addition of a user password. Adding a password for the first time (ie. no passwords are defined), will add two passwords - the master and default passwords. ::DEFAULT PASSWORD SETTINGS MASTER - All attributes are enabled and cannot be changed. DEFAULT - All attributes are disabled except for PASSWORD ENABLED. All attributes may be changed, except for PASSWORD ENABLED and EDIT PASSWORD. USER - All attributes are disabled except for PASSWORD ENABLED and BROWSE. All attributes may be changed except for EDIT PASSWORD and BROWSE. ##PWDELETE PASSWORD: DELETE This button deletes the currently highlighted password. The MASTER and DEFAULT passwords cannot be deleted if any USER passwords exist. Deleting the current active password (when the database was opened) will void it and make all functions available. ##PWATTR PASSWORD: ATTRIBUTE DISPLAY The attribute display shows the current state of the password. By selecting any item (except for those disabled for the password type) the state may be toggled. If any filters or print forms are defined, there are special attributes for these. If a filter had been defined and selected as an attribute, then it will be used when the database is opened using the password. If a label layout had been defined, print form selected as an attribute, and ADD PRINTFORMS is disabled, then any user wishing to print, will be forced to use the print form assigned to the password. ##PWPASS PASSWORD: DISPLAY This button is used for selecting a password for editing or deleting. ##PWADOWN $$SCROLLDOWN ##PWAPROP $$PROPSCROLL ##PWAUP $$SCROLLUP ##PWOK PASSWORD: ACCEPT This button closes the password requester and accepts the current state of all passwords. These will be saved to disk when the database is closed. ##PWEDIT PASSWORD: EDIT This button facilitates changing a password. First select the password you want to change, then click on this button. If data security is an issue, it is recommended that passwords are changed on a regular basis. ##-- PAGE LAYOUT WINDOW -- ##DIMNOT PAGE LAYOUT: DIMENSIONS NOTE All dimensions are shown in units of the currently selected measurement system. ##PLLABHEIGHT PAGE LAYOUT: LABEL HEIGHT Shows the height of the labels. Altering the contents will indirectly change the vertical label spacing. **DIMNOT DIMENSIONS NOTE ##PLVSPACE PAGE LAYOUT: VERTICAL SPACING Shows the vertical space between labels. Altering the contents will indirectly change the label height. **DIMNOT DIMENSIONS NOTE ##PLHSPACE PAGE LAYOUT: HORIZONTAL SPACING Shows the horizontal space between labels. Altering the contents will indirectly change the label width. **DIMNOT DIMENSIONS NOTE ##PLLABWIDTH PAGE LAYOUT: LABEL WIDTH Shows the width of the labels. Altering the contents will indirectly change the horizontal label spacing. **DIMNOT DIMENSIONS NOTE ##PLLABDOWN PAGE LAYOUT: LABELS DOWN Shows how many labels go down the page. Altering the contents will indirectly change the label height. ##PLLABACROSS PAGE LAYOUT: LABELS ACROSS Shows how many labels go across the page. Altering the contents will indirectly change the label width. ##PLBOTMBORDER PAGE LAYOUT: BOTTOM BORDER Shows the page's bottom border (margin). Altering the contents will indirectly change the label height. **DIMNOT DIMENSIONS NOTE ##PLTOPBORDER PAGE LAYOUT: TOP BORDER Shows the page's top border (margin). Altering the contents will indirectly change the label height. **DIMNOT DIMENSIONS NOTE ##PLRIGHTBORDER PAGE LAYOUT: RIGHT BORDER Shows the page's right border (margin). Altering the contents will indirectly change the label width. **DIMNOT DIMENSIONS NOTE ##PLLEFTBORDER PAGE LAYOUT: LEFT BORDER Shows the page's left border (margin). Altering the contents will indirectly change the label width. **DIMNOT DIMENSIONS NOTE ##PLDELETE PAGE LAYOUT: REMOVE LAYOUT This button allows the removal of a page layout. This operation is barred if a label layout has a page layout attached. ##PLRENAME PAGE LAYOUT: RENAME This button allows the current page layout to be renamed. ##PLLAYDEL PAGE LAYOUT: DELETE LAYOUT This button allows the deletion of a disk stored page layout. ##PLNEXT PAGE LAYOUT: NEXT A DataNEXUS database may contain many page layouts which can be selected for use. DataNEXUS visually shows the layouts. The Next button will loop round the layout list. ##PLOK PAGE LAYOUT: EXIT This button will return you to the main screen, keeping all changes made to all page layouts. ##PLPAGEHEIGHT PAGE LAYOUT: PAGE HEIGHT Shows the height of the labels. Altering the contents will indirectly change the label height. **DIMNOT DIMENSIONS NOTE ##PLPAGEWIDTH PAGE LAYOUT: PAGE WIDTH Shows the width of the labels. Altering the contents will indirectly change the label width. **DIMNOT DIMENSIONS NOTE ##PLMERGE PAGE LAYOUT: GOTO MERGE EDITOR Selecting this button will accept the page dimensions, and bring up the print merge control panel. ##PLLABELS PAGE LAYOUT: GOTO LABEL EDITOR Selecting this button will accept the label dimensions, and bring up the label editor. ##PLNEW PAGE LAYOUT: NEW Allows the creation of a new layout, either using the default template, or using the current layout as a template. NEW asks for a meaningful name for the page layout. If no name is given a default name will be provided. ##PLDISPLAY PAGE LAYOUT: DISPLAY This area shows the page in graphical form. The page representation is sized to fit into the display area whilst keeping the proper aspect ratio. ##PLLOAD PAGE LAYOUT: LOAD FROM DISK Loads a previously saved page layout. ##PLSAVE PAGE LAYOUT: SAVE TO DISK Saves the current page layout. The current layout's name will be sent to the file requester. ##PLTEST PAGE LAYOUT: TEST Prints one page of labels for testing purposes. The label areas are filled with 'H' characters, so the accuracy of your page layout can be checked. ##PLSIZE PAGE LAYOUT: PAPER SIZE This button sets default values for various paper sizes. ##PLHELP PAGE LAYOUT: MORE HELP The page layout panel supports 2 functions, selecting page dimensions and arranging label layout. A layout cannot be edited or deleted if it is used with a label layout. While creating a page layout for print merging the label dimension boxes are disabled. This is a problem areas which may cause problems with printing. The test print feature will show this up. The printer driver and the printer is required to have the left margin set to 0 and the right margin set to 80, the printer must be in a mode where it accepts commands to change font size and linefeed spacing. DataNEXUS always prints PICA at 6 lines per inch. ##PLUNITS PAGE LAYOUT: UNITS DataNEXUS page layout allows page dimensions to be entered in inches, centimeters or points (there being 72 points to the inch). ##-- LABEL LAYOUT WINDOW -- ##PPXHAIR LABEL LAYOUT: CROSS HAIR This button toggles the cross hair on and off. A cross-hair is useful for aligning fields. ##PPREMOVE LABEL LAYOUT: REMOVE FIELD This button removes a field from the label. ##PPFIELD LABEL LAYOUT: ADD FIELD This button adds a field to the label. An add field requester is opened from which a field may be selected and it's attributes set. The attributes that can be set are: Bold, italic, underline and remove spaces. ##PPTEXT LABEL LAYOUT: ADD TEXT This button adds arbitrary text to the label. A text requester is opened from which text and its attributes may be set. The attributes that can be set are: Bold, Italic, Underline. ##PPEDIT LABEL LAYOUT: EDIT ITEM Edit Item allows a field item or text item to be edited, change field, text or attributes. ##PPPRINT LABEL LAYOUT: PRINT Accepts the label layout and calls the print control requester, where the records to be printed and print settings are selected. ##PPEXIT LABEL LAYOUT: EXIT Exits the label editor, accepts the layout and returns to the main panel. ##PPHPROP LABEL LAYOUT: SCROLL BAR This slider may be used to scroll the label left and right. ##PPVPROP LABEL LAYOUT: SCROLL BAR This slider may be used to scroll the label up and down. ##PPFIELDS LABEL LAYOUT: DISPLAY This area shows the label as it will be printed. A field may be moved by selecting and dragging it, and may be re-sized by selecting and dragging it's corner sizing rectangle. ##PPBLANKS LABEL LAYOUT: REMOVE BLANKS The remove blanks toggle will move a field up the label if there is no text on the line above, thus avoiding unprofessional looking labels with blank lines in the middle of a label. An example of when this would be useful, is if a label contained: NAME-------------------- COMPANY----------------- ADDRESS----------------- If a record had an empty company field, the address would move up one line leaving no gap between the name and address. If a record had text in the company field, it would still appear in the expected position. ie NAME-------------------- ADDRESS----------------- ##-- NEW PRINT ITEM REQUESTER -- ##PFCANCEL ADD FIELD: FIELD Cancel adding a new field to the label. ##PFSPACES ADD FIELD: REMOVE SPACES The remove spaces toggle will remove any spaces within a field when printed. This only applies to two or more spaces together. ##PFDISPLAY ADD FIELD: FIELD LIST This button contains a list of all printable fields. ##PFDOWN $$SCROLLDOWN ##PFPROP $$PROPSCROLL ##PFUP $$SCROLLUP ##PFOK ADD FIELD: ADD Adds the selected field to the label with the selected settings. ##PFBOLD ADD FIELD: BOLD This button toggles whether a field is to be printed in bold type or not. ##PFITALIC ADD FIELD: ITALIC This button toggles whether a field is to be printed in italicised type or not. ##PFULINE ADD FIELD: UNDERLINE This button toggles whether a field is to be printed underlined or not. ##-- PRINT CONTROL REQUESTER -- ##PCCANCEL PRINT CONTROL: CANCEL Cancels the print operation, remembering the current settings. ##PCPRINT PRINT CONTROL: PRINT Starts the print operation with the current settings. ##PCFILE PRINT CONTROL: TO FILE This button shows where the print will be sent to. The output may be changed by selecting the button, then typing the new output name. ##PCREPEATS PRINT CONTROL: REPEATS This button shows the number of times the records will be printed. Altering the contents will change the number of print runs, from a minimum of 1 to a maximum of 99. ##PCTO PRINT CONTROL: TO RECORD This button shows the last record which will be printed. You can alter the contents of this button. ##PCFROM PRINT CONTROL: FROM RECORD This button shows the first record which will be printed. You can alter the contents of this button. ##PCHCTRL PRINT CONTROL: HORIZONTAL CONTROL This button is used to determine how the printer moves the print head between columns of labels. There are three options: SPACES - Prints spaces between columns. This achieves an accuracy of 1/10 th of an inch. SP/B.SP - Prints using spaces and back spaces in different print pitches, which can improve column positioning. ESC SEQ - Sends an escape sequence to the printer for relative print head positioning. Since the escape sequence is not ANSI supported, there are no printer drivers which support the escape codes. For this reason, the appropriate escape code can be specified via a Workbench tool type. **PRINTERTT PRINTER TOOL TYPES ##PCVCTRL PRINT CONTROL: VERTICAL CONTROL This button is used to determine how the printer moves the print head between rows of labels. There are three options: LINEFEED - Prints using only linefeeds. This achieves an accuracy of about 1/6th or 1/8th of an inch. LF/REV LF - Prints using linefeeds and reverse linefeed with a different line spacing, which can improve column positioning. ESC SEQ - Sends an escape sequence to the printer for perform paper feed. Since the escape sequence is not ANSI supported, there are no printer drivers which support the escape codes. For this reason, the appropriate escape code can be specified via a Workbench tool type. **PRINTERTT PRINTER TOOL TYPES ##PCPAGEFEED PRINT CONTROL: PAGE FEED This button toggles between LINFEEDS and FORMFEED LINEFEEDS - Used in situations where the printer used does NOT know the size of paper being used. DataNEXUS will emulate a formfeed at the end of each printed page. FORMFEED - Used in situations where the printer used is setup with the length of the paper being used, or when a Laser printer is used. DataNEXUS will send a form feed to the printer at the end of each printed page. ##PCPRTTYPE PRINT CONTROL: QUALITY This button toggles between NLQ and Draft. Users of Laser printers may ignore this option. ##PCTOPRT PRINT CONTROL: TO PRINTER Selects the printer as the output device for printing. ##PCTOSER PRINT CONTROL: TO SERIAL Selects the serial port as the output device for printing. ##PCTOFILE PRINT CONTROL: TO FILE Selects a file as the output device for printing. Clicking this button will bring up a file requester, allowing you to enter a filename to print to. ##PCTABS PRINT CONTROL: TAB SIZE This button shows the regular tabs size used in print merge documents. This setting should be the same as the tab size setting in the word processor used to create the ASCII merge document. ##PCTEST $$PLTEST ##-- CALC FIELD PANEL -- ##CCFPROP $$PROPSCROLL ##CCFUP $$SCROLLUP ##CCFDOWN $$SCROLLDOWN ##CCOPS CALCULATION: FUNCTION DISPLAY This display area shows all the operations that the calculator can perform. By selecting an operation, it will be appended to the calculation. There are several types of operation contained in the list, simple, functions, field and constants. **AVAILABLEOPS AVAILABLE OPERATORS ##CCFORMULA CALCULATION: FORMULA This button shows the calculation formula. It may be edited at any time by typing directly into it. ##CCCANCEL CALCULATION: CANCEL Cancel the specification of the calculation field. ##CCEXIT CALCULATION: EXIT This button removes the calculator panel. ##CCDO CALCULATION: CALCULATE Perform the calculation and display the result. The result will be displayed to the right or this button. ##CCFIELDS CALCULATION: DATABASE FIELD This display lists all fields in the current database which may be used in the calculation. ##CCODOWN $$SCROLLDOWN ##CCOPROP $$PROPSCROLL ##CCOUP $$SCROLLUP ##CCUSE CALCULATION: ACCEPT This button accepts the expression and allows the positioning of the calculation field. ##CCCLEAR CALCULATION: CLEAR This button clears the calculation, ready for another to be entered. ##CCEDIT CALCULATION: ACCEPT & EDIT This button accepts the expression and allows the display format of the field to be changed. ##CCHELP CALCULATION: MORE HELP This panel allows complex expressions to be calculated. Results are displayed in a calculation field, or in direct mode, in the answer box to the right of the CALC button. The function list displays all the available functions, operations and constants which are supported. Note: All angles are in degrees, unless they are specifically converted into radians. **AVAILABLEOPS OPERATORS AVAILABLE ##-- SCAN SUB PANEL -- ##SCANDONE SCAN RECORDS: DONE This button cancels the record scan. The button can be a little unresponsive, due to the time taken in displaying any given record. SHORTCUT: ESCAPE ##SCANPAUSE SCAN RECORDS: PAUSE This button allows the record scan to be paused at any time. The button can be a little unresponsive, due to the time taken in displaying any given record. SHORTCUT: SPACE BAR ##-- SUMMARY FIELD REQUESTER -- ##SWTYPE SUMMARY FIELD: TYPE Toggles the type of summary calculation. The two options are: SUM - Aggregate of all fields. AVERAGE - Sum divided by the number of records. ##SWEDIT SUMMARY FIELD: EDIT DISPLAY FORMAT Edit the numeric display format for the summary field. ##SWPROP $$PROPSCROLL ##SWUP $$SCROLLUP ##SWDOWN $$SCROLLDOWN ##SWFIELDS SUMMARY FIELD: FIELD LIST Lists all fields which a summary field can summarise. ##SWUSE SUMMARY FIELD: OK Accept the summary field settings. ##SWCANCEL SUMMARY FIELD: CANCEL Cancel the addition of the summary field. ##-- TIME FIELD REQUESTER -- ##TIMEFORMT TIME FIELD: FORMAT This button toggles the time display between 24 hour and AM/PM format. ##TIMESECS TIME FIELD: SECONDS This button toggles between the time field displaying seconds as well as hours and minutes. ##TIMEOK TIME FIELD: OK Select this button to accept the time format. ##TIMECANCEL TIME FIELD: CANCEL This button cancels the addition of the time field. ##-- TEXT FIELD REQUESTER -- ##TXTYPE TEXT FIELD: TYPE This button toggles the type of the text field. It has two options that determine the number of characters that can be entered into, and stored by, the text field. BOX SIZE - The number of characters is limited by the field's on-screen box size. SCROLLABLE - The number of characters is that which is entered into the size button. The field will scroll if necessary. ##TXSIZE TEXT FIELD: SIZE This button indicates the number of characters the text field can store. This number is only valid if scrollable is selected as the box type. ##TXOK TEXT FIELD: OK Select this button to accepts the text field and proceed to place the text field on the form. ##TXCANCEL TEXT FIELD: CANCEL This button cancels the addition of a text field. ##TXKEEP TEXT FIELD: KEEP SIZE Selecting this button will leave the field with it's old size intact. ##TXRESIZE TEXT FIELD: RE SIZE Selecting this button indicates that you want the size of the field altered to the size entered. **TXSIZE SIZE BUTTON ##-- TEXT TOOL -- ##DTTXTULINE TEXT TOOL: UNDERLINE This button toggles whether the text will be shown underlined or not. ##DTTXTBOLD TEXT TOOL: BOLD This button toggles whether the text will be shown bold or not. ##DTTXTITALIC TEXT TOOL: ITALICS This button toggles whether the text will be shown italicised or not. ##DTTXT3D TEXT TOOL: 3D Look This button toggles whether the text will be shown with a 3D look or not. ##DTTXTTXT TEXT TOOL: TEXT Enter the text you wish to place on the form into this button. ##DTTXTOK TEXT TOOL: OK Accept the text and proceed to place it on the form. ##DTTXTCANCEL TEXT TOOL: CANCEL Cancel the addition of this text onto the form. ##-- BOX TOOL -- ##DTBOXTYPE RECRANGLE TOOL: TYPE This toggles the visual appearance of the rectangle that will be drawn. ##DTBOXOK RECRANGLE TOOL: OK Accept the rectangle type, and proceed to place it on the form. ##DTBOXCANCEL RECRANGLE TOOL: CANCEL Cancel the addition of this rectangle onto the form. ##-- LINE TOOL -- ##DTLINETYPE LINE TOOL: TYPE This toggles the visual appearance of the line that will be drawn. ##DTLINEOK LINE TOOL: OK Accept the line type, and proceed to place it on the form. ##DTLINECANCEL LINE TOOL: CANCEL Cancel the addition of this line onto the form. ## -- OVERWRITE REQUESTER -- ##OVERWTYES OVERWRITE: YES Selecting this button will overwrite the old file with the new file. Be warned; the old file will be lost! ##OVERWTNO OVERWRITE: NO Cancel the write operation, leaving the old file alone. ##-- QUIT REQUESTER -- ##QUITYES QUIT: YES Quit DataNEXUS, save current preferences if any prefs item has changed, and free all resources used. ##QUITICONISE QUIT: ICONIFY Iconify DataNEXUS by closing it's display screen and opening an snooze window on the Workbench screen. ##QUITNO QUIT: CANCEL Cancel the quit operation and return to DataNEXUS. ##-- EXTERNAL PROGS -- ---------------------- ##QUITTEXT QUIT TEXT VIEWER Exit the text viewer. ##QUITHEX QUIT HEX VIEWER Exit the hex viewer. ##QUITFONT QUIT FONT VIEWER Exit the font viewer. ##QUITARCH QUIT ARCHIVE VIEWER Exit the archive file viewer. ##--TEXT VIEWER-- ##TEXT_DISPLAY TEXT: DISPLAY The display area for ASCII text and HEX dumps. **TEXT_SHORT SHORTCUTS ##TEXT_EDIT TEXT: DISPLAY This text area displays the ASCII document being edited. To move the cursor to a different part of the document, simply select the character with the left mouse button. There are some keyboard operations to be aware of. **TEXT_SHORT SHORTCUTS ##TEXT_SEARCH TEXT: SEARCH Search will locate a word or phrase within a document. **TEXT_SHORT SHORTCUTS ##TEXT_TOP TEXT: FIRST PAGE Go to the top of the document. **TEXT_SHORT SHORTCUTS ##TEXT_LAST TEXT: PREVIOUS PAGE Go to the previous page of the document. **TEXT_SHORT SHORTCUTS ##TEXT_NEXT TEXT: NEXT PAGE Go to the next page of the document. **TEXT_SHORT SHORTCUTS ##TEXT_BOTTOM TEXT: LAST PAGE Go to the end of the document. **TEXT_SHORT SHORTCUTS ##--TEXT VIEWER SHORT CUTS-- ##TEXT_SHORT TEXT: KEYBOARD SHORTCUTS RIGHT AMIGA + T - Alter Tab setting. RIGHT AMIGA + I - To toggle between overwrite and insert modes. RIGHT AMIGA + N - Search for next occurrence. RIGHT AMIGA + P - Search for previous occurrence. RIGHT AMIGA + R - Repeat search in the direction last used. <- - Delete character to the left of the cursor. DEL - Delete character under the cursor. RIGHT AMIGA + S - Invoke search requester. CTRL + CURSOR UP - Goto start of document. SHIFT + CURSOR UP - Goto previous page. SHIFT + CURSOR DOWN- Goto next page. CTRL + CURSOR DOWN - Goto end of document. ##--TEXT VIEWER SEARCH REQUESTER-- ##SRCH_DIRECT SEARCH: DIRECTION The direction button has three states. FORWARD - Search forwards from the current position in the document. BACKWARD - Search backwards from the current position in the document. FROM TOP - Search forwards from the top of the document. ##SRCH_CASE SEARCH: CASE SETTING The case button has two states. Case sensitive search and case insensitive search. ##SRCH_WORDS SEARCH: FOR WORDS The words button will toggle between searching for the text within the document as either whole words or parts of words. A word consists of a series of characters in between space characters (ie. SPACE,TAB,RETURN,LINE FEED). ##SRCH_STRING SEARCH: STRING The string button allows you to enter the text you wish to search for within the document. ##SRCH_OK SEARCH: START The OK button will commence the search operation according to the parameters set in the requester. **TEXT_SHORT SHORTCUTS ##SRCH_REPEAT SEARCH: REPEAT The repeat button will repeat the search in the direction indicated by the DIRECTION button. ##SRCH_CANC SEARCH: CANCEL The cancel button will quit the search text requester. ##--HEX SEARCH ADDITIONAL BUTTONS-- ##SRCH_MODE SEARCH: MODE The search mode toggles between searching for ASCII text within a file and binary sequences (Hexadecimal or base 16). ##--FONT VIEWER-- ##FONT_ULINE FONT: UNDERLINE Toggle the underline characteristic of the font on and off. ##FONT_ITALIC FONT: ITALIC Toggle the italic characteristic of the font on and off. ##FONT_FBOLD FONT: BOLD Toggle the bold characteristic of the font on and off. ##--ARCHIVE VIEWER-- ##ARC_DISPLAY ARCHIVE: CONTENTS This area displays the contents of the selected archive file. ##ARC_PROP ARCHIVE: SCROLL BAR Scroll the list of archived files up or down. ##--EXECUTE-- ##EXE_ARGS EXECUTE: ARGUMENTS The text entered here is placed after the file that is about to be executed. The file may accept this text as it's argument (telling it what to do). For example, if the file being executed is 'C:Lock', and the argument entered is 'DH0:', then 'C:Lock DH0:' will be the command executed. ##EXE_BEHIND EXECUTE: BEHIND This option determines whether DataNEXUS will remain visible after the program has been launched. If a program is launched with the behind option set, it will be running, but may not initially be visible. Use the screen depth arrangement gadgets to rotate through the list of currently available screens. ##EXE_RUN EXECUTE: RUN The file about to be executed will run concurrently with DataNEXUS. This means that DataNEXUS will not have to wait for the launched program to finish before it can continue to be used. ##EXE_CD EXECUTE: CD If this option is selected, then DataNEXUS will change the current directory for the launched task to it's own directory. Some programs require access to additional files to run, this option will allow them to do just that. ##EXE_CON EXECUTE: CONSOLE If this option is selected, then the launched program will have a window to write text to and receive input from. Some programs require a console. ##EXE_EXE EXECUTE: EXECUTE PROGRAM Launches the program selected taking into account all of the options just entered. ##EXE_ABORT EXECUTE: CANCEL Cancels the launching of the program. ##--VARIOUS REQUESTERS-- ##PWNAMEREQ PASSWORD: ENTER Typing into this area allows the entry and validation of passwords. ##PRTTROUBABO PRINTER ERROR: ABORT Could not send printout to the printer. Abort the printing. ##PRTTROUBCAN PRINTER ERROR: RETRY Could not send printout to the printer. Try the following. 1) Check the printer is connected. 2) Check the printer is switched on. 3) Check the printer has some paper. 4) Check your preferences printer settings. 5) Check your printer DIP switch settings. ##INTEGCLOSE DATANEXUS DATA INTEGRETY Periodically DataNEXUS closes and reopens all open record files, this forces AmigaDOS to ensure all changes to the record file have been written to disk. This procedure has failed to reopen a record file, subsequently the database MUST be closed. ##INDEXERR DATANEXUS INDEX ERROR DataNEXUS has found an error, inconsistency in an index table to correct this use REBUILD from the MISC menu. **REBUILD REBUILD INDEXES & TABLES ##GRIDX GRID: X SETTING Set the X grid setting in pixels. ##GRIDY GRID: Y SETTING Set the Y grid setting in pixels. ##GRIDUSE GRID: USE Use the current grid settings. Whilst the grid is in use all move operations will lock the upper left corner of objects to the grid. ##GRIDCANCEL GRID: CANCEL Cancel grid requester, restoring settings as they were prior to invoking this requester. ##GRIDRESET GRID: RESET Reset the grid, has the same effect as setting the grid to X = 1 and Y = 1. ##TALLERYES TALLER CARD: YES Make the record card taller. This allows more fields to be placed on the record card. The scroll bar to the right hand side of the screen is used to move the card up and down. ##TALLERNO TALLER CARD: NO Leave the height of the record card as it is. ##TEMPLATEYES LOAD TEMPLATE: YES Read in a definition from an existing database. This may be a convenient starting point saving you time and effort. ##TEMPLATENO LOAD TEMPLATE: NO Create a new database from scratch. ##CIRCULARDEF CIRCULAR DEFINITION You have created a circular definition; two calculation fields reference each other eg. Field1: Cost = Price * 2 Field2: Price = Cost + 12; ##JOINBLINES JOIN IMPORT: BLANK LINES DataNEXUS allows multiple fields to be joined together when importing. Any blank lines may be removed eg. ::Import data Address 1 1 The Terrace Address 2 Address 3 High street Address 4 Lutterworth :: Field after import Keep blanks Remove blanks Address 1 The Terrace 1 The Terrace High Street High street Lutterworth Lutterworth ##JOINJLINES JOIN IMPORT: JOIN CHARACTER DataNEXUS allows multiple fields to be joined together when importing. The separate fields in the import data may be joined with a space or new line character eg. ::Import data Address 1 1 The Terrace Address 2 High street Address 3 Lutterworth :: Join with space Address 1 The Terrace High Street Lutterworth :: Join with new line Address 1 1 The Terrace High street Lutterworth ##JOINOK JOIN IMPORT: OK Exit the join fields requester. ##ENTERFCNT IMPORT FIELD: COUNT DataNEXUS needs to know how many fields are in the import data, this cannot be achieved when the record and field delimiters are the same, please enter this value. ##ENTERFCNTOK IMPORT FIELD: OK Exit the import field count requester. ##FLT_NAMESTR NAME FILTER: NAME Name filter allows a meaningful name to be assigned to a filter. By leaving this button blank, DataNEXUS will fill the filter name with the start of the filter text. ##FLT_NAMEOK NAME FILTER: OK Accept filter name and find all records which match the filter expression. NOTE: If no records are found, the filter is disabled. ##FLT_NAMECAN NAME FILTER: CANCEL Do not use the filter and return to normal operation. NEW FILTER - New filters will be deleted. EDITED FILTER - Changes will be kept but the filter not used. ##FLD_REQREENT FIELD REQUIRED: RE EDIT Re edit returns to editing the current field. ADD RECORD - Record is not added to the database. EDIT RECORD - Changes to the record are abandoned. **FLD_REQDEXP Error Explanation. ##FLD_REQREABOT FIELD REQUIRED: ABORT Aborts the record editing. **FLD_REQDEXP Error Explanation. ##FLD_REQDEXP FIELD REQUIRED: EXPLANATION You have tried to skip a field which has the REQUIRED flag set. ##FLD_HIDEDIT RECORD HIDDEN: EDIT The hidden record may be edited. **FLD_HIDEEXP Error Explanation. ##FLD_HIDCANCEL RECORD HIDDEN: CANCEL The hidden record is left unchanged. **FLD_HIDEEXP Error Explanation. ##FLD_HIDEEXP RECORD HIDDEN: EXPLANATION When searching for a record with duplicated unique data and a record is found which is hidden (see preferences). ##FLD_UNIQEDIT FIELD UNIQUE DUPLICATED: RE EDIT Re edit returns to editing the current field. **FLD_UNIQEXP Error Explanation. ##FLD_UNIQFIND FIELD UNIQUE DUPLICATED: FIND OTHER Find record with duplicated unique data and edit that record. **FLD_UNIQEXP Error Explanation. ##FLD_UNIQEXP FIELD UNIQUE DUPLICATED: EXPLANATION Data has been entered into a field with the UNIQUE flag set and another record contains the same data. ##GOTO_REC GOTO RECORD: RECORD NUMBER Enter the new record number to goto. The valid range is shown in the requester. ##GOTO_OK GOTO RECORD: OK Goto the record number as shown in the number button above. ##GOTO_CANCEL GOTO RECORD: CANCEL Cancel the goto record operation. ##FIND_OK FIND: OK Cancel the find operation. ##FIND_NEXT FIND: NEXT Find the next record which matches the search criteria. ##DEUNDEL SHOW DELETED: UNDELETE Undeletes the currently viewed deleted record, returning it to the active record list. ##DEPURGE SHOW DELETED: PURGE Purge the currently viewed deleted record. Purge permanently erases the record from the database, leaving an empty space in its place. Empty spaces may be removed by using close and pack. **PACKDATABASE CLOSE AND PACK ##DEEXIT SHOW DELETED: EXIT Returns to normal operation with active records. If there have been any changes, DataNEXUS will rebuild all index tables. ##-- MISC HELPS -- ##PATMATCH AMIGADOS PATTERN MATCHING The pattern matching expressions allowed depend on the version of AmigaDOS you are running under. DOS 1.3 - '#?' Matches any number of characters. '?' Matches a single character. '|' OR's two expressions eg. 'A|B'. DOS 2.0 - See AMIGADOS users guide Page 7-3. DOS 3.0 - See AMIGADOS users guide Page 1-11. ##AVAILABLEOPS CALCULATION OPERATORS The operators available are: + - * / : Arithmetic add, subtract, multiply and divide. % : The modulus (or remainder) of an integer divide. Eg. 10 % 3 = 1 (10 / 3 = 3 r 1) | : Binary OR. OR's the binary representation of two numbers. Eg. 4 | 5 = 5 (%100 | %101 = %101) & : Binary AND. AND's the binary representation of two numbers. Eg. 4 & 5 = 4 (%100 | %101 = %100) ~ : Binary Negate. Negate is an unary operator. It only effects one operand. It reverses the binary representation of a number. Eg. ~0 = -1 () : Braces. Encasing sub-expressions within braces overrides operator precedence in the normal mathematical way. Eg. 5 * 2 + 1 = 11 5 * (2 + 1) = 15 , : Comma. Used to separate parameters in named functions. Eg. POWER(2, 2) ABS(n) : Absolute. Gives the order of magnitude of a number. Ie. negative numbers are made positive. Eg. ABS(-5) = 5 INT(n) : Integer. Gives the integer portion of n. The fractional part is discarded and no rounding occurs. Eg. INT(2.99) = 2 SQRT(n) : Square Root. Eg. SQRT(9) = 3 POW(n, p) : Power. Raises n to the power of p. Eg. POS(3, 2) = 9 FIX(n, d) : Fix. Gives the number, n, to the precision of d decimal places. Normal rounding occurs. Eg. FIX(2.9, 0) = 2 FIX(3.1415, 3) = 3.142 SIN(deg) : Sine. Gives the sine of the number of degrees. Eg. SIN(90) = 1 COS(deg) : Cosine. Gives the cosine of the number of degrees Eg. COS(0) = 1 TAN(deg) : Tangent. Gives the tangent of the number of degrees. Eg. TAN(45) = 1 ARCSIN(n) : Arcsine. Gives the arcsine of a number in degrees Eg. ARCSIN(1) = 90 ARCCOS(n) : Arccosine. Gives the arccosine of a number in degrees. Eg. ARCCOS(1) = 0 ARCTAN(n) : Arctangent. Gives the arctangent of a number in degrees. Eg. ARCTAN(1) = 45 DEGTORAD(d) : Degrees to radians. Gives an angle specified in degrees in radians. Eg. DEGTORAD(180) = PI RADTODEG(r) : Radians to degrees. Gives an angle specified in radians in degrees. Eg. RADTODEG(PI()) = 180 LOG(n) : Logarithm. Gives the log of the number to base 10 Eg. LOG(100) = 2 (Ie. POW(10, 2) = 100) LN(n) : Logarithm. Gives the natural log of the number (to base e) Eg. LOG(E()) = 1 EXP(n) : Exponent. Gives e to the power of n. Eg. EXP(1) = e DAYS(date) : Days. Gives the total number of days from 0/0/0, to the date in the given date field. This is useful in obtaining the difference, in days, between two dates. Eg. DAYS(12/2/95) - DAYS(30/12/94) = 44 Ie. 44 days separate the two dates. MONTHS(date) : Months. Gives the total number of months from 0/0/0 to the date in the given date field. This is useful in obtaining the difference, in months, between two dates. Eg. MONTHS(12/2/95) - MONTHS(30/12/94) = 2 Ie. 2 months separate the two dates. YEAR(date) : Year. Extracts the year from a date field. Eg. YEAR(24/12/72) = 72 MONTH(date) : Month. Extracts the month from a date field. Eg. MONTH(24/12/72) = 12 DAY(date) : Day. Extracts the day from a date field. Eg. DAY(24/12/72) = 24 MINUTES(time): Minutes. Gives the total number of minutes from midnight to the time in the time field. This is useful in obtaining the difference in minutes between two times. Eg. MINUTES(02:05:03) - MINUTES(01:05:20) = 60 SECONDS(time): Seconds. Gives the total number of seconds from midnight to the time in the time field. This is useful in obtaining the difference in seconds between two times. Eg. MINUTES(02:05:03) - MINUTES(01:55:20) = 10 HOUR(time) : Hour. Extracts the hour from a time field. Eg. HOUR(12:05:02) = 12 MINUTE(time) : Minute. Extracts the minute from a time field. Eg. MINUTE(12:05:02) = 5 SECOND(time) : Second. Extracts the second from a time field. Eg. SECOND(12:05:02) = 2 MAX(n, m) : Maximum. Returns the highest number from n and m. Eg. MAX(-2, 1) = 1 MIN(n, m) : Minimum. Returns the lowest number from n and m. Eg. MIN(-2, 1) = -2 ROUND(n) : Round. Gives the integer part of n with rounding. Eg. ROUND(1.5) = 2 PERCENT(n,p) : Percentage. Returns p percent of n. Eg. PERCENT(200, 10) = 20 (10% of 200 = 20) ADDPERCENT(n,p): Add Percentage. Gives n + (p percent of n). Eg. ADDPERCENT(200, 10) = 220 (200 + 20 = 220) SUBPERCENT(n,p): Subtract Percentage. Gives n - (p % of n). Eg. SUBPERCENT(200, 10) = 180 (200 - 20 = 180) . : Gives a decimal point. 0-9 : Gives the corresponding digit. TIME() : Time. Returns the number of seconds elapsed since midnight. PI() : Gives the mathematical constant PI. E() : Gives the mathematical constant e. ##TROUBLE TROUBLE SHOOTING GUIDE ::RECORD CANNOT BE DISPLAYED When a record exists and cannot be displayed there are two possibilities: 1) The index is out of date. 2) The record file is corrupted in some way. Unless there is a read/write error in the record file, the REBUILD option from the MISC MENU should fix the index error. Failing this, the record file must be corrupt in some way. As the record file follows the IFF chunk standard, any IFF chunk listing program should point out the location of the problem. ::PRINTER DOES NOT PRINT CORRECTLY Most printers have a print area. The border area may need to include the non-printable area. Alternatively, you have asked for escape sequence positioning, without having set up the printer escape codes correctly. See **PRINTERTT PRINTER TOOLTYPE SETTINGS for more information on setting up your printer escape codes. ::IMPORTING PROBLEMS If you are importing with the record and field delimiters the same, you must enter the number of fields, as the file analyser cannot determine this automatically under these circumstances. When fields within the import file contain the quote character, the fields must not be enclosed inside quotation marks. DataNEXUS will report this as an ANALYZE ERROR. Importing multi-line text fields into a single line text field will give undesirable results. ::EXPORTING PROBLEMS When exporting multi-line text fields which use the linefeed character, the export should enclose fields within double quotes, or use another delimiter (not linefeed \n ). Importing such a file will give undesirable results. ::SLOW SEARCHES All search functions work from the first to last record in the index. Searches are slower to perform when the database is sorted. ::ERROR REQUESTERS Create Sort - Low Memory Delete Sort - Low Memory Chunk Tracker - Low Memory Try to free some memory by closing other applications, closing windows on the Workbench screen, or by closing opened databases. If you still have memory problems, you could try saving all your work, rebooting and trying again. This procedure will de-fragment your memory and may help. If all this fails, you could re-design your database to hold less information or purchase a memory upgrade. Find Record - Null Pointer Find Record - Test Pointer Summary - Record Not Found Summary - Field Not Found Sort Records - Record Not Found Sort Records - Field Not Found Record Error - Reading Extra Record Error - Read Field Record Error - Corrupt Read Record Header Unique Table - Field Not Found Space Error - Illegal Position The record file or index may be corrupt. Try REBUILD. If this does not correct the problem, you could resort to trying to IMPORT the file. Record Error - Write Error A DOS error occurred during a write operation. You may be able to try the write again, or try to write to a different place. Consult your AmigaDOS manual for more information. Index Error - Save Length Incorrect The number of entries in the record index does not match the number of records. The index will be rebuilt next time the database is opened. ##EDITKEYS EDIT/FIND RECORD KEYBOARD The following keyboard shortcuts are active whilst editing a record: ::MOVEMENT TAB - Move to next field. In last field will indicate end editing. SHIFT + TAB - Move to previous field. In first field will go to the last field. AMIGA + TAB - Finish editing the record. ALT + TAB - Finish editing the record and add another SHIFT + DEL - Erase the fields contents. ESCAPE - Abort edit, add or find record. ::TEXT FIELD CURSOR UP - Move up one row. CURSOR DOWN - Move down one row. CURSOR LEFT - Move left one character. CURSOR RIGHT - Move right one character. SHIFT + CURSOR UP - Move to the top of the field. SHIFT + CURSOR DOWN - Move to the bottom of the field. SHIFT + CURSOR LEFT - Move to the left of the line. SHIFT + CURSOR RIGHT - Move to the right of the line. ::NUMERIC FIELD CURSOR LEFT - Move left one character. CURSOR RIGHT - Move right one character. '.' - Move to the right of the decimal point. ::DATE FIELD & TIME FIELD CURSOR UP - Increment selected part of date field. CURSOR DOWN - Decrement selected part date field. CURSOR LEFT - Move to the left of the date field. CURSOR RIGHT - Move to the right of the date field. ::CYCLE FIELD CURSOR UP - Select the next response. CURSOR DOWN - Select the previous response. AMIGA + A - Add a response. ::EXTERNAL FIELD RETURN - Open File requester to change the filename (also by clicking on the highlighted area in the field). ##FLTERRORS FILTER ERROR MESSAGES ::"Cannot Find Expression" There must be an open bracket at the beginning of an expression. ::"Expressions Not Separated With AND, OR, NOT, EOR" The expression has no infix operator. ::"Separated AND, OR, NOT or EOR. Not Found" The logical separator found after an expression is not supported, or a separator has been incorrectly spelt. ::"Separator NOT Followed By Expression" A logical separator has been found without another expression following. ::"No Field In Expression" A field name cannot be found after the open bracket in the expression. ::"Illegal Operator" The field operator found after the field name is not supported by the field, or there is a spelling mistake. ::"Operator not Suitable With Field" A text field is being used in conjunction with a numeric operator or vice versa. ::"No end of expression character" Cannot find the close of expression character. The end of expression character may be determined with the following table. START CHAR END CHAR fred) none ) "fred") " " 'fred') ' ' {fred}) { } [fred]) [ ] :fred:) : : ::"No expression data found" There was no data to match with a field. ::"No close brace in expression" There must be a close bracket at the end of an expression. ::"Expression data too long (max 98 chars)" The expression data is too long. ::"Invalid expression data for field type" The field data found in the expression is not supported by the field type. ::FOUND COMPARITOR OPERATOR A comparitor operator was found when there should be a separator operator. ::FOUND SEPARATOR OPERATOR A separator operator was found when there should be a comparitor operator. ##TOOLTYPES ICON TOOL TYPES ::GENERAL TOOL TYPES PALETTE - DEFAULT, SYSTEM or a system palette file. EMBOSS - LIGHT or DARK. INITFILEREQ - ON or OFF. FORCELACE - ON or OFF. **PRINTERTT PRINTER TOOL TYPES ##PRINTERTT PRINTER TOOL TYPES DataNEXUS uses the following tool types for printers which have fine positioning control of the print head. These are printers which support n/180 n/216 n/60 ... inch paper feed commands, and relative horizontal position commands. PRTINITIAL - An escape sequence sent to the printer before labels/print merge starts. Can be used to set the printer into an emulation mode. PRTFINAL - An escape sequence sent to the printer after labels/print merge has completed. Can be used to reset the printer to its initial settings. PRTDRIVER - Workbench 1.3 only. Used to select the printer driver other than the preferences printer. PRTHORIZESC - The n/180 n/216 n/60 ... inch paper feed command used for moving the print head to a specified position for the next label. See Note 2 PRTVERTESC - The relative horizontal position command used for feeding a specified amount of paper between rows of labels. See Note 2. PRTHORIZINCS - The amount which PRTHORIZESC command will increment, eg. n/180 command will increment by 180ths of an inch. PRTVERTINCS - The amount which PRTVERTESC command will increment, eg. n/60 command will increment by 60ths of an inch. NOTE 1: Escape sequences can be entered by using decimal, binary, hexadecimal or ASCII in any combination. Eg. 27, 48, 54 27, '0', '3' (or 27 '03') 27, $FF, 43 27, %01001010 NOTE 2: The positioning commands are usually specified in the printer manuals like ESC + J + n or 27,74,n or 1B,4A,n. The 'n' must be substituted by a value from 0 to 255. This is done internally by DataNEXUS. To indicate the position of the 'n' value, the escape sequence must contain an asterisk '*'. Eg. 27 'J' *. For commands which have n1 and n2, n2 must be substituted with a binary zero. Eg. Template : ESC + \ + n1 + n2 : Entered : 27 '\' * 0 Note 3: As mentioned above, the PRTDRIVER tool type is for 1.3 owners only. Owners of WorkBench 2.0 and above should enter the printers preferences program, setup the driver as desired and then save it to DataNEXUS.Prt into the same directory as the DataNEXUS main program. This will be used each time DataNEXUS prints anything to the printer. Note 4: The Printer MUST not use a proportional font, otherwise the horizontal print control and word wrap feature will not function correctly. ##SUPTYPES RECOGNISED FILE TYPES The external field player automatically recognises and handles the following different file formats: IFF - ILBM, ANIM, 8SVX, SMUS, ANIM Brushes, 24BIT MED - MDD0 Module Only ICON - Workbench Icon FONT - Image Data, Header, Bitmap, Compugraphic and Colourfonts supported ASCII - Documents SCRIPTS - Standard AmigaDOS batch script PROGRAMS - Executable programs OBJECT CODE - Programmer object files ('.O' files) VIDEO - CDXL, VAXL (Optonica's CDXL Type) ARCHIVES - LHA, ZOO, ARC, ZIP,LZX PRO TRACKER - Tracker Music AMIGA GUIDE - Amiga Guide Database. (OS 2 and above only.) DATATYPES - Any additional file type which has a datatype handler available. (OS 3 and above only.) COMPRESSION TYPES AUTOMATICALLY HANDLED POWER PACKER - Any file compressed using PowerPacker. (Requires PowerPacker.library © Nico François) XPK - Any file compressed using XPK. (Requires XPKMaster.library) NOTE: AGA images will be converted to HAM for displaying on ECS machines. On ECS machines HAM & HAM8 images in 640 width mode will automatically be scaled to 320 width. NOTE: 24bit images will be shown in HAM8 on AGA machines, and HAM on ECS machines. (The conversion may take a short while.) ##