Symphony Pro User Manual 2.0.2.15
180
© 2005 TOSHIBA TEC AMERICA AMERICA RETAIL SYSTEMS, INC. R1.0a
The File Maintenance utility can also display specific information about a table and its associated SIL
file. With one table selected, click the right mouse button. A properties panel opens, displaying the
table information in the top portion of the panel. If you did not select an associated backup from the
"View" menu there is no associated backup file. If you select a backup day from the view menu, then
right click a table, the bottom portion of the properties panel displays information about the backup file.
You can also click the "View" button below the backup file properties to open the SIL file in an editor to
view the actual contents.
This example shows the Data table and backup file properties.
Re-indexing Tables
If you are using the default "Paradox" database type, there are situations that may arise where the
data table "indexes" become corrupt. This doesn't mean that the data itself is corrupt, just the internal
pointers used by the database to quickly locate records. This can happen during a system "crash". For
example: at the moment that Symphony Pro is writing data to a table, there is a power failure, or the
computer "freezes" because of low resources. When the system comes back online, and Symphony
Pro is re-started, it will open a message box indicating that it was not properly shut down, and that this
may have caused damage to the data table indexes. In this case it is suggested that the tables be re-
indexed as a precaution.
NOTE:
If your installation is using MSSQL rather than a Paradox style database you will probably
never need to run the re-index command because the MSSQL program handles this type of situation
internally.
Re-Indexing Operation
NOTE:
Close all Symphony Pro programs and modules before running the re-index command. If you
re-index while there are tables open, the process will stop, indicating that a table is busy. You must
close all Symphony Pro programs and re-start the re-index process.