Category : Paradox DBMS
Archive   : TUTIL3.ZIP

Output of file : TUTILITY.DOC contained in archive : TUTIL3.ZIP
Paradox Table Utility Program Page 1
Release 2.04


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 names to
verify and/or rebuild. By pressing the function key "F1" anywhere
in the program, you can instantly view helpful hints about tutility.
You may also run tutility in a batch mode which is described later
in this document.

The Menu

The first thing to appear on the screen when tutility is invoked is
the menu. Using the right and left cursor keys, simply highlight 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 Program Page 2
Release 2.04

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 back together. 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
deleted files.

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 Program Page 3
Release 2.04

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
damaged table.

Batch Mode

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
DOS prompt:

tutility tablename

"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 and illustrates how to verify a single table:

tutility price.db

To verify three tables named "table1", "table2", and "table3", you
could use either of the following:

tutility table1.db table2.db table3.db


tutility table?.db

To verify all tables in the current directory, you would use the
following command:

tutility -all

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 Program Page 4
Release 2.04

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
rebuilt table. These files may be recreated but you must be in
Paradox to do so.


Control Key Summary

F1 display help screen
RightArrow move to next file name in list
LeftArrow move to previous file name in list
UpArrow move to file name above current one
DownArrow move to file name below current one
Home move to first file name in list
End move to last file name in list
BackSpace erase previous character
^BackSpace erase entire field
^Break cancel current operation

  3 Responses to “Category : Paradox DBMS
Archive   : TUTIL3.ZIP

  1. Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!

  2. This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.

  3. But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: