Hi
 
I have a Paradox table with a composite primary key made up of:
DocketNo    Integer
DocketCheck Char(1)
DocInd    AutoIncr
 
I have also defined a secondary index on DocInd (EntryOrder), which is used whenever I want to order the table in the order of entry.
 
The client site has recently done some bulk deleting from this table and now cannot post to the table, getting error
"Key Violation: Index - EntryOrder"
 
I have tried deleting the index files and recreating them, but to no effect.
 
Can anyone throw any light on this or suggest any remedies.
 
Thanks
 
Mark 
BEGIN:VCARD
VERSION:2.1
N:Howard;Mark
FN:Mark Howard
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20010716T235533Z
END:VCARD

Reply via email to