Documentation Comments
Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.
Reality V15.2 Online Documentation (MoTW) Revision 3
Option 5: Regenerate Table (SQL) (m691504+regenerate.htm)
This option allows you to repeat the Create New Table Definitions process for a single existing SQL table and its associated Reality file.
Regenerate table offers the same methods for creating the table definition as Option 1: Create New Table Definitions:
Notes:
The Regenerate Table process is similar to that for Create New Table Definitions.
On selecting option 5 from the main menu, you are prompted:
Define Filename to be Processed... Enter Filename :
Enter the name of the Reality file for which you wish to regenerate the
SQL table. If you enter ?,
a list of files is displayed, from which you can select. See
Using the SQLM Menu Options.
You are then prompted:
Enter name of Table to be Regenerated: Enter Tablename :
Enter the name of the SQL table you wish to
regenerate. If you enter ?, a list of tables is displayed, from which you can
select. See Using the SQLM Menu Options.
You are then prompted:
Do you wish to:
A. Update existing Table (keeping untouched entries)
B. Totally replace existing Table
Enter selection (A/B/EXit):
A,
any user-created definitions that are not overwritten will be retained.B,
any user-created definitions that are not overwritten will be deleted.EX,
you will be returned to the main menu.Continue from step 3 of the Create New Table Definitions process.