Key Violation Error

Hearaoi

unread,

Nov 25, 2004, 10:02:54 PM11/25/04

to corel.wpoffice.paradox10

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

unread,

Nov 26, 2004, 4:41:58 AM11/26/04

to corel.wpoffice.paradox10

<<
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

Hearaoi

unread,

Nov 26, 2004, 10:55:49 AM11/26/04

to corel.wpoffice.paradox10

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

"Bertil Isberg" <bertil...@retlifmapsSCB.se> wrote in message
news:41a6f446$1_2@cnews...

Tony McGuire

unread,

Nov 26, 2004, 11:48:05 AM11/26/04

to corel.wpoffice.paradox10

> 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

unread,

Nov 26, 2004, 2:57:15 PM11/26/04

to corel.wpoffice.paradox10

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

"Tony McGuire" <cng.paradoxcommunity@com> wrote in message
news:41a75817_2@cnews...

Bertil Isberg

unread,

Nov 26, 2004, 4:03:38 PM11/26/04

to corel.wpoffice.paradox10

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

Hearaoi

"Bertil Isberg" <bertil...@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 - CTECH
Paradox buglist:
online: http://w1.826.comhem.se/~u82608896/
FAQ newsgroup: corel.wpoffice.paradox-faq

Bertil Isberg

unread,

Nov 26, 2004, 4:08:41 PM11/26/04

to corel.wpoffice.paradox10

<<
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.