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
|
98KB
|
2,993 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.)
##