Dec 082017
FILEBASE is a simple database that works with comma delimited field records.
File FILEBAS.ZIP from The Programmer’s Corner in
Category Databases and related files
FILEBASE is a simple database that works with comma delimited field records.
File Name File Size Zip Size Zip Type
ARTICLES.FXD 2432 923 deflated
ARTICLES.PMT 128 47 deflated
FBMANUAL.DOC 21757 7491 deflated
FILEBAS1.EXE 36864 21155 deflated
FILEBAS2.EXE 21504 13657 deflated
FILEBAS3.EXE 16896 10722 deflated
FILEBAS4.EXE 48640 27855 deflated
FILEBAS5.OVR 4096 2415 deflated
FILEBAS6.EXE 62464 33901 deflated
FILEBASE.EXE 60928 33396 deflated
INFILE1 1031 573 deflated
INFILE1.PMT 80 58 deflated
INFILE2 534 333 deflated
INFILE2.PMT 80 58 deflated
LISTC.FXD 1170 596 deflated
LISTC.PMT 80 58 deflated
README 10368 4031 deflated

Download File FILEBAS.ZIP Here

Contents of the README file


Sample data files and corresponding prompt files to be used for
familiarization with program functions are:

Data file Prompt File Comment

INFILE1 INFILE1.PMT Names & addresses
INFILE2 INFILE2.PMT Names & addresses
LISTC.FXD LISTC.PMT Names & addresses
CHECKS.DTA CHECKS.PMT Check Register data

The contents of the data files may not correspond exactly field
for field with the printed versions used in the Tutorial Section
of the Manual. They may vary for illustrative purposes.

INFILE1 and INFILE2 can be used with all menu opitions with the exception
of Option 9 - Update. Option 9 requires a one-time conversion to
fixed length records. This can be performed with Option 10 or as
part of a sort or select operation with Options 1, 2, or 3.

The two files can be merged into one because they have the same
number of fields and the same kind of logical information in each
of the corresponding fields. That is, field one is a fullname in
each file, field 2 is a last name, etc. etc. and field 6 is a
numeric quantity which the prompt file defines as CONTRIBUTION.

LISTC.FXD is identical in format to the first 2 except that it has
already been converted to fixed length records and can be used
immediately with Opition 9 for random access, search, and to
change information such as a new address.

CHECKS.DTA is also a fixed record length file and is a typical
check register layout. It can also be used to illustrate the
14-column summary profit and loss statement generated by the
PROFLOSS program. EXPENSE.CAT is the expense categories
file as desribed on manual pages 72-74.

ARTICLES.FXD is a file suitable to serve as an example of print
capabilities on longer text fields such as TITLE and SYNOPIS
within this sample. The LFS (LABEL FORMAT TO SCREEN) and
TBF (TABULAR BLOCK FORMAT) within Option 4 would be illustrative
of the word-wrap capabilites in these report styles.


The following report format is now available within Option 4:

Author Title Source Synopsis

Tony Bove & Cheryl CompuServe User's Guide, Discussion of
Rhoades Communications- Vol. 1, No. 6, private file
File Transfers P7, 1983 transfers to
and Public electronic
Access publishing. Placing
orders, conducting
research, taking
courses. Sending

Bruce R. Hunter Etc. Etc. Etc.

Each of the above columns represents a single field. Release 7.7
incorporates tabular word-wrapped output from any database field,
in any order, for a maximum of 5 columns. Tabulation and word-
wrap are automatically performed by menu selection.

This tabular wrap format is an extension of a single column wrap option in
earlier versions that squeezed information onto index cards and other
atypical size media under user controlled width limits.


Return to the main menu is now with use of the ESC key rather
than the ? key as in prior versions. For data file protection
reasons, some prompts will not allow return to the main menu.
In these instances, progressing to the next prompt(s) will reach
a valid breaking point. Return to the menu is also enabled when
the Enter key is used alone when a required file name is requested.


Since FILEBASE has been used by some as a UTILITY type program,
CONTROL-C has been permitted as a valid means of termination.
However, to prevent any new records from being lost by the
improper use of CONTROL-C, it is no longer permitted during
keying in of new records.


With DOS, the logical printer is designated as LPT1 or LPT2 or LPT3.
Internally, these are referred to by a single integer. This is 0 in
the case of LPT1, 1 for LPT2 and 2 for LPT3.

With most FILEBASE print operations, it does not matter which one is
valid for your system. However, when printing an individual record
from within Options 6, 7, or 9 a printer test function has been
implemented. This requires FILEBASE to know whether your printer
is designated as 0 (LPT1) or 1 (LPT2) or 2 (LPT3).

In the vast majority of systems, LPT1 is the one used by DOS.
FILEBASE will automatically consider the printer designation as 0.
If this is not true for your system (the print function in Options
6, 7 or 9 does not work), you can use FILEBASE to create a
one field file on the FILEBASE disk or in the FILEBASE subdirectory.
Name the file FBLPTNUM.CDE. Enter the number 1 into a single record,
sign-off FILEBASE and reload the program again so that it can use
the new information. Test the print function. If this does not
work, create the file again and enter the number 2.

NOTE: In some hardware configurations (ex. using serial COM port
instead of regular printer port) an erroneous printer status
may be detected and a PRINTER NOT READY message given even
though the printer may be ready. The status check can be
disabled by requesting to establish a NEW print format.


Entering an equal sign (=) into a field during data entry will
cause the field contents from the prior record to be repeated in
the current record. The = sign will be replaced by the actual
data when the record is reflected back for changes. During this
correction process, entry of an = will not cause field contents from
the previous record to be used.


Requested file names may be entered with a path designation. If a
disk drive letter designation is not entered, the default (logged-on) drive
will be used by the program. Subdirectory paths may be entered with
file names. The entry of \docs\clublist as a file name designates the
path as follows:

On the logged-on (default) drive, go to root directory, goto the docs
directory and use the file named "clublist".

Remember that FILEBASE works together with DOS particularly when it
comes to file names. With subdirectory support, if you enter a file
name longer than 8 characters, FILEBASE will accept it and reflect it
back to you as you entered it. However, DOS truncates it to 8 characters.
For example, if you create a file with the 9 character name LIST12345
DOS will actually write it to the disk directory as LIST1234 even though
FILEBASE refers to it as LIST12345. If LIST1234 is already in existence
and you tell FILEBASE to create a file named LIST12345, it will report that
the file already exits and will ask if you wish to overwrite it.


The program will now sort on both 5 digit and 5+4 zip codes as part
of a "city, state zip" field even when the data file contains both
types. To sort on the full 5+4, reply to the "number of characters
for sorting" prompt with a 10.


Indexing on the last name part of a full name field and the zip code
part of a 'city, state zip' field is now offered and described on screen.

To find records in the 46 zip area do a zip index only on 2 characters,
or on 3 for a somewhat more specific search. Using the available comparators,
such as BETWEEN, this method of indexing can be very effective and specific.

These two functions can be put to good advantage on other kinds of
fields as well.

For example, the last name breakout feature if applied to a 'city state, zip
field' will index on the state because the routine finds the word just
before the comma (as might be found in John Smith, Jr.) but instead of
finding the last name it finds the state. There may be situations where
using the zip index feature can be used on other fields. The zip code
breakout routine finds the last continuous string of characters in the
field after stripping off incidental blanks from the right side. This
process ignores the presence of commas in a field.


When running a report there is now an option to write the report
to disk instead of the screen or printer. This is enabled to permit
editing of the report with a word processor or building a memo around
the report. Also, those using FILEBASE on a laptop computer away
form a printer can generate reports for later printing. The disk
reports can be printed with most any word processor or with the
DOS PRINT command.


FILEBASE allows testing only one field at a time. To get the results
of multiple field testing make two passes at the file. The first can
be a select/exclude with option 2 to segregate those meeting the first
field test criteria to another file. Then use the select/exclude
functions within the report option on a second field using the new file.

 December 8, 2017  Add comments

Leave a Reply