Key Violation Error

[Hearaoi]

After creating a database, I added 6 records, saved, closed, and turned
Paradox off. When I started Paradox again, the 6 records were there. I was
able to type in another record, but the lone key field (an auto-increment
field) did not receive a value, and I was warned of a Key Violation.
Thanks, Hearaoi

[Bertil Isberg]

<<
I was able to type in another record, but the lone key field (an
auto-increment field) did not receive a value, and I was warned of a Key
Violation.
That's a problem that can occur when using AutoIncrement, if the table
gets damaged in any way. Try to rebuild the table using Table Repair.

[Hearaoi]

I have checked for damage: There is no problem. I restructured the table,
substituting a Short for the Auto-increment. Again I check for damage, and
there was none.
The problem has changed a bit, had changed before damage checks and before
the Short/Auto-increment change. Now I cannot make any entry beyond the 6
original records.
BTW, I dont understand 'remove spamfilter (reversed) to reply'.

Hearaoi

Post by Bertil Isberg
<<
I was able to type in another record, but the lone key field (an
auto-increment field) did not receive a value, and I was warned of a Key
Violation.
That's a problem that can occur when using AutoIncrement, if the table
gets damaged in any way. Try to rebuild the table using Table Repair.
--
Bertil Isberg
CTECH
FAQ newsgroup: corel.wpoffice.paradox-faq
Paradox Buglist: http://w1.826.comhem.se/~u82608896/
remove spamfilter (reversed) to reply

[Tony McGuire]

Now I cannot make any entry beyond the 6 original records.

What does this mean? Do you get an error? Can the table be put into edit?


--
--
Paradox Support http://www.thedbcommunity.com/support/

Tony McGuire
_____________

[Hearaoi]

Thanks, Bertil & Tony. Tony, I could switch to Edit mode, but could make no
entries. After receiving your message, I took another look. I arrow-keyed
down to a new record, and was and am able to add more records. I don't know
what changed., but for now all is great. Thanks, Harry

Post by Tony McGuire

Now I cannot make any entry beyond the 6 original records.

What does this mean? Do you get an error? Can the table be put into edit?
--
--
Paradox Support http://www.thedbcommunity.com/support/
Tony McGuire
_____________

[Bertil Isberg]

<<
BTW, I dont understand 'remove spamfilter (reversed) to reply'.

Hearaoi

"Bertil Isberg" <***@retlifmapsSCB.se> wrote in message
Do you see the spamfilter - reversed now? Reversed it is retlifmaps.

If you had try to Reply to sender instead of Reply to group, your mail
wouldn't have reached me.

[Bertil Isberg]

<<
I have checked for damage
Corruption of the autoincrement will not be seen by Table Repair, Verify. It
will be fixed by Rebuild and of course if you change the AutoIncrement
column to Short, the problem disappears.

The problem you described is most often caused by the last used Autoinc
value stored in the table's header being incorrect. When you tried to insert
a record an already used value was assigned to the Autoinc column, and you
got a Key violation.