Key violation in Paradox table
Posted on 2001-08-20
I am using a Paradox database with several tables.
One of the tables called Stock.db got a primary index called Stock.px.
Something went wrong in upgrading AND in the back-up sequence and now whenever I try to insert a record into that table I get: Key Violation.
If I disable the primary key (called IDSelf which is an auto-increment field type) and enable it again in Database Desktop I get the same error and why: The new record tries to insert with IDSelf is 1 ! When it should be something like 1180.
How can I restore or create the correct primary key.
I can't delete this table and create a new one, since it has got several relations to other tables.
I am using Delphi 5.0 and BDE 5.1.
Thanks a lot!