Specifications

Internal dBase Database
297
Valid field types are as follows:
• Character
• Numeric
• Logical
• Memo
• Date
Field Length
Field LengthField Length
Field Length
This is the maximum number of characters or digits that are to be contained in
the field. Date, logical and memo fields are fixed length fields.
Decimal Places
Decimal PlacesDecimal Places
Decimal Places
The number of decimal positions in a numeric field. The value entered here
should be 2 less than the field length of the numeric field value.
Example: A numeric field length of 5 may have decimal places defined as 3, 2, 1
or 0.
Field Position
Field PositionField Position
Field Position
The position to insert the field within the structure. This appears after you have
defined at least one field for the database.
Editing the Database Structure
Editing the Database StructureEditing the Database Structure
Editing the Database Structure
In order to edit the database, you must first choose the option Create the New
Database. After creating a new database, the Database Records Management
screen will be presented.
Reserved Words
Reserved WordsReserved Words
Reserved Words
There are four (4) reserved words that can be used for database field names:
FMTCOUNT, BARSUPP, LBLCOUNT and FMTNAME. More information and an
example of their use can be found here.
FMTCOUNT
FMTCOUNTFMTCOUNT
FMTCOUNT allows you to control the number of labels printed for each
individual record when using the $all function. When FMTCOUNT is used
as a field name, the record is printed as many times as the number stored
in this field. FMTCOUNT is useful when different records in the database
require a different number of labels. For example, when multiple locations
are used to shelve an item.