A
- Append a field to end. C
- Change this field
R
- Reposition field offsets
+
- Display next field - display previous field
E
- Exit to master menu ENTER á-K)ICE:
FIELD EDIT OPTIONS: G
-
Go to field number-
Repositions you at the field number entered and displays the current definition of thatfield.
Youwill
be prompted for the field number to go to after entering the <G> option.I
-
Insert before thisf'kjd -
Creates rcjcm for a new field byincrementing all the higher field numbers by one. Them the field
specifications for a new field may be entered under the newly-
available field number. D
-
Delete thisfield -
Deletes the currentfield
and reduces all thehigher field numbers by one to adjust for the deletion. A
-
Append a field to end-
A new fieldwill
be created as the lastfield in the File Definition. You must enter the new field's speci
ficati
ens (see below) .Dataf1ex 2.0 User's Manual FILE DEFINITION (FILEDEF) C-61 C
-
Change or edit this field-
Allows you to re-enter the specifica- tions for the currentfield.
R
- Reposftion field offsets
-
Required to resetfield
positions after thefile
definition has been modified. The positions of the fields inthe record buffer (field offset) must be recalculated whenever any
field is added,, deletecb or changed in length. +
- Moves you forward one field.
- - Moves you back one fie?d. E
-
Exit to master menu-
Returns you to the FILEDEF menu. <RETURN>-
Always moves editing to the nextfield.
For examp1epif
you are on Field 2 and press <RETURN>, Field 3 will be displayed.<RETURN> will create a new field
if
you are currently on the last field in afile
definition.You will be asked the following questions for each
field:
****** FIELD # ******
# is the number of the field you are currently editing.
FIELD NAME: (tagname)
The tagname you enter here
will
be utilized by FILEDEF and QUERY forpranpting and documentatSom and
will
be displayed in thefile
definl-ti
on.It will
be used, along w¶th the DataFlex filename as part of the Data Base Element name, in the DataFlex Command Language. The tagnames are stored for eachfile
in a separate ASCIIfile
called rootname.TAG. The maximum tagname length is 15 characters. Validcharacters in tagnames are:
[
'A...Z', '0...9'. 'e'. C'. '#'
]The
first
character must be alpha (A...Z). Spaces and slashes areinvalid. and will be replaced with an underscore (_).
FIELD TYPE: ( A=ASCII, N=NUMERIC, D=DATE, 0=OVERLAP )
This
will
set the field to either:ASCII (numbers and letters) NUMERIC
- (numbers only)
DATE
- Stored Jul ian; output format: MM/DD/YY
OVERLAP
- A field which re-defines areas of the record.
The next prompt depends on the field type entered above. For ASCII fields:
NUMBER OF QURACTERS
This is the maximum number of characters to be assigned for this
fiel
d.———————
C-62 FILE DEFINITION (FILEDEF) DataFlex 2.0 User's Manual =======
————
For NUMERIC fields:
NUMBER OF MARACTERS TO THE LEFT OF THE DECIMAL POINT
Each number is broken into two parts:
left
and right of the decimalpoint. Enter the number of characters to the
left
of the decimalpoint. (Minimum of 19 maximum of 14.)
NUMBER OF CltARACTERS TO THE RIGHT OF THE DECIMAL POINT
Enter the number of characters to the right of the decimal point (O to
4). The characters to the
left
and right of the decimal point are added together by FILEDEF to compute the total field length. For DATE'fields, no questions are asked, Dates are ALWAYS stored as three-byte numbers. (
For OVERLAP fields:
FIELD OFFSET: OFFSET OF FIELD IN RECORD
This number represents the relative number
of bytes from the beginning of the record
to where the current overlap
field
starts.If
there are no previous overlap fields inthe recor6 then this number
will
be the number of bytes in the record up to thefirst
overlappedfield.
If
there are previous overlap fie1dSg their combinedlength must not be counted in developing
this number.
FIELD LENGTH: LENGTH OF FIELD IN BYTES
This is the number of bytes the overlap
field
will span in the record.It
should be the total length of the overlappedfields.
For ALL field types:
RELATIONSHIP TO FILE: FILE NUMBER·0F RELATED FIELD
If
thisfield
relates TO a field in anotherfi1e9 enter the number of that
file
here. A printout of thefile
definition of therelated-to
file
would be helpful for answering this and the next questiomif
there is a relation.
If
there is norelationship FROM this
field,
enter a zero. RELATIONSHIP TO FIELD: (FIELD NUNEIER OF RELATED FIELD)If
the question above was answered in theaffirmative (with a numberL then enter the number of the field which is being related TO. Otherwise, enter a zero.
The creation or editing of the selected
field
is now complete. Theinformation for this field will be re-displayed for inspection purposes.
If
you wish to make further changesg enter a 'C',If
all is correct, enter a "+" to move on to the next fie16 or enter an 'Elto return to the activities menu.
~~~~~
DataFlex 2.0 User's Manual FILE DEFINITION (FILEDEF) C-63 OPTION 2
- CREATE/EDIT INDEXES
Option 2 allows you to create or change the index(s) for a
file.
Thefollowing "dialog" with FILEDEF allows you to easily define how you want to your
file
indexed:FILEDEF PROMPT YOUR RESPONSE
HOW MANY INDEXES FOR THIS FILE:
A NUMBER IN THE RANGE FROM
l
TO 4 (Oneto nine in 16-bit computers) This will
correspond to the number of unique
indexes you wish to have automatically
maintained for this