|
<< Click to Display Table of Contents >> Paradox KeyViolation table |
  
|
|
<< Click to Display Table of Contents >> Paradox KeyViolation table |
|
As the Paradox Primary Index is always of the UNIQUE type, applying this kind of index (via the Table menu) will cause Key Violations in case of any non unique values in the indexed column.
These discarded values are stored in a KeyViolation table named according to the source table as
{SourceTableName}_KEYVIOL01.db
with successive tables up to
{SourceTableName}_KEYVIOL03.db
If the KeyViolation tables aren't (manually) deleted before needing further KeyViolation tables, an extra table suffix marked with an X is created
{SourceTableName}_KEYVIOL03X.db
which will be overwritten by successive results and auto deleted if applying a Primary Index without resulting Key Violations.
Generation of Keyviolation tables is provided for Paradox tables only.
In case of such Paradox Primary Key violation for a table named "Names", a dialog like this is presented:
A Paradox primary key is lifted/deleted via the Table menu.
__________________________