Versions Compared

Old Version 3

changes.mady.by.user Corby Nagel

Saved on

compared with

New Version Current

changes.mady.by.user Corby Nagel

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The last problem happens rarely, but it has happened. The easiest way to fix this is to pull the affected .DBT from a backup.  

Infonote

If the backup .DBT is lost, use the following procedure to recover:

  1. Assuming your database name is EXAMPLES, so your .DBT file is named EXAMPLES.DBT;

  2. Rename EXAMPLES.DBT to EXAMPLES.BAK, making a temporary backup;

  3. Make a copy of SYSPROG.DBT; name the copy EXAMPLES.DBT;

  4. Log into the EXAMPLES application.

What this does is start the EXAMPLES database out with just the system tables attached. Now you have to go back into Database Manager (or use the command line) to attach the tables necessary for your application. Once you have done that, use Define_Database to save the database definition. After you are happy that EXAMPLES is working well again, make a back up.

...

  • A table has been created that will be part of the application’s database;

  • A table has been deleted that was part of the application’s database;

  • A table has been attached that will be part of the application’s database;

  • A table has been detached that was and will no longer be part of the application’s database;

  • An index has been added to a table that is part of the application’s database and that previously did not have an index;

  • The last index on a table that is part of the application’s database has been removed;

  • One or more tables that are part of the application’s database have been moved.

Infonote

When using the system tools (as opposed to the command line), the .DBT file is

usually updated

usuallyupdated in each of these cases except in the case of adding and removing indexes.