Contents of the TUTILITY.DOC file
Paradox Table Utility ProgramPage 1
This document describes the program "tutility" which contains features
that allow the user to check a Paradox table for internal consistency
and then reconstruct it if necessary. Damaged Paradox tables can
result from many sources including power failures, hardware failures,
removing a floppy disk that Paradox is accessing, or rebooting the
system while Paradox is active in memory.
This version of tutility has been enhanced to include verification
and reconstruction of password-protected tables and the ability to
rebuild tables in batch mode. Gone is the 32,000 block limit which
occasionally prevented some large tables from being rebuilt. If you
have free disk space equal to 110 percent of the space taken by the
damaged table, you can rebuild it.
Method of Execution
To execute tutility, enter the following command at the DOS prompt:
This form invokes the interactive program mode where you select
various options from Paradox-like menus and provide table namesto
verify and/or rebuild. By pressing the function key "F1" anywhere
in the program, you caninstantly view helpful hints about tutility.
You may also run tutility in a batch mode which is described later
in this document.
The first thing to appear on the screen when tutility is invoked is
the menu. Using the right and left cursor keys, simplyhighlight the
task you wish to perform and press to execute that task. The
following describes each of the menu selections and how they operate.
The Verify Option
The "Verify" option allows you to check a given table to see if the
table descriptor is valid and that the internal links between each
record are unbroken. When the verification is complete, you will be
notified as to the table's condition. If the table is corrupted,
you will then have the option to rebuild it.
Paradox Table Utility ProgramPage 2
The Rebuild Option
To reconstruct a table whose record links have been severed, select
the "Rebuild" option. If the table has not been corrupted beyond
repair, the records will be linked backtogether. Please note that
some records may be lost in this process due to the nature of
relinking. Also note that any primary or secondary index files
associated with the table will be deleted and the table rebuilt
without any keys. You should use Paradox to restore any of these
If a table has been damaged beyond the point of recovery, you will see
a message indicating that the rebuild has been unsuccessful.
The Directory Option
The "Directory" option allows you to change your working directory
to any directory on your system. Since tutility does not support
path names when specifying which table to use, you should first use
the "Directory" option to connect to the desired directory.
The Monitor Option
If you have a color graphics adapter and a black and white monitor,
as many Compaq computers have, the tutility screen will appear with
a light background when you start the program. To change the screen
and make it more readable, select the "Monitor" option to see a menu
of monitor types and then select "B&W" to tell tutility that you wish
to see the screen in black and white mode. This option also works for
color monitors but has no effect on monochrome video adapters.
The Exit Option
When you have completed all your tasks in tutility, select "Exit"
from the main menu to return to DOS.
The File Name Prompt
When you select the "Verify" or "Rebuild" option, you will be prompted
to enter the name of the file on which the desired task will operate.
The name must be a valid Paradox table name without the ".DB" suffix
and must specify a table that resides in the current directory.
If you are not sure which tables reside in the current directory,
you may push the "Enter" key to see a list of available table names.
Use the cursor control keys to highlight the desired table name and
then press "Enter" to begin operating on the highlighted file.
Paradox Table Utility ProgramPage 3
Cancelling an Operation
Should you decide to cancel an operation once it has begun, press the
"Ctrl" key and the "Break" (^Break) key simultaneously. This will
signal tutility to quit what it was doing and return to DOS. Please
note that cancelling the rebuild of a table could itself lead to a
The batch mode of tutility supports both the "Verify" and "Rebuild"
options described earlier. However, in batch mode, you may specify
one or more tables to be verified or rebuilt.
To invoke the batch verify mode, type the following command at the
"Tablename" above represents either one or more table names or a
single table name argument containing the DOS wild card substitution
characters "?" and "*". The example below represents the simplest
form of the program andillustrates how to verify a single table:
To verify three tables named "table1", "table2", and "table3", you
could use either of the following:
tutility table1.db table2.db table3.db
To verify all tables in the current directory, you would use the
Tutility will examine each of the specified tables and report the
state of each one on the screen. After all tables have been checked,
you will also see a count of the number of tables examined and the
number of tables found to be inconsistent. All messages generated
by tutility may be redirected to a file or the printer for later
examination. For example, to print tutility output for all files
in the current directory, you could enter:
tutility *.db >prn
Paradox Table Utility ProgramPage 4
If you want the output stored in a file, substitute a file name for
the word "prn" above.
To invoke the batch rebuild mode of Tutility, type the following
command at the DOS prompt:
tutility -rebuild tablename
The "-rebuild" parameter tells tutility that all files specified
by the "tablename" parameter are to be rebuilt if they are found to
be inconsistent during verification. Tables found to be valid will
not be rebuilt.
Please note that the rebuild option is very powerful in that it will
delete all the primary and secondary index files associated with a
rebuilttable. These files may be recreated but you must be in
Paradox to do so.
Control Key Summary
F1display help screen
RightArrowmove to next file name in list
LeftArrowmove to previous file name in list
UpArrowmove to file name above current one
DownArrowmove to file name below current one
Homemove to first file name in list
Endmove to last file name in list
BackSpaceerase previous character
^BackSpaceerase entire field
^Breakcancel current operation