Table maintenance

This form is used for indexing, packing and validating tables as displayed in the caption.

Tables are dBase database files with extension “dbf”

Index Recreate the index files which determine the sorting order for display of data.
Index files have the same name as the dbf files but extension “nsx”

Pack Remove deleted but invisible tables from the physical files.

Validation Update the database structure to match that in the definition files.

Null Value check Removes empty records.

This form is modal – it must be closed before other forms or the menu can be accessed.

It will also automatically close any other open tables so make sure you save any pending edit before opening this form.

1. The grid displays all the tables defined in the system.
Table – name of the dbf file for the table
Alias – short cut used internally
Level – 0 for system files, 1 for well files
Tag – True or false. Only those tagged will be processed.
Updated – the version where the table was last updated.

2. Tag individual tables for processing by double clicking on the line or type T in the tag column

3. Use the buttons to Tag or Untag all tables

4. Click “Process” button – the tagged files will be indexed, packed or updated depending on the option used to display the screen.
You can not damage your database using this screen. If you tag all the only penalty is that it will take longer to complete than if you select a number files individually

5. For a validation, tag all and then click on the view report button.
This will present a report of all tables that need to be updated and at the same time untagging those that are already up to date.

HINT: If processing stops part way through, close and reopen the program.

Then repeat the process before doing any other work with the program.

DocumentDataTableMaintenance.htm