Board index » delphi » Paradox AutoIncrement Corruption
Paradox AutoIncrement Corruption
2007-01-06 06:54:19 AM
I have an old application that uses Paradox 7 tables. One of the
tables uses an AutoIncrement field to store a unique ItemID. The
current records in the table start at an ItemID of 3 and go to 314.
When adding a new record, the first new record is assigned 1 and the
second is assigned 2. Of course, when they try to put in the 3rd it
I read an earlier post where restructuring was suggested to fix this
but it doesn't work. I use Database Desktop v7 to restructure and the
problem still exists. I even added a new field to make sure that the
restructure actually took place.
Is there another way to fix this table?