>Keep in mind that deleted records are also taken into account by the index.
>
>>I'm getting some inconsistent errors that have left me confused about the situation.
>>
>>I have created a cursor and a candidate index for that cursor. The index uses two fields of the cursor. Here is the INDEX command that I am using.
>>
>>INDEX ON BINTOC(GroupID) + BINTOC(VisitID) TAG ixPrjSess CANDIDATE
>>
>>GroupID and VisitID are integer fields. The index using these two fields should be unique, thus my use of CANDIDATE.
>>
>>I use APPEND BLANK to add records to the cursor. After appending a blank record I fill in the fields with REPLACE commands.
>>
>>Some of the time I can add records with the APPEND BLANK command without any errors. Other times I get an error saying that the uniqueness of the index is violated.
>>
>>If a new index value is created when the APPEND BLANK is executed, I would expect that the index would be identical every time. Why do I not get a uniqueness violation every time?
>>
>>Thanks for your thoughts.
>>
>>Jim

Sergey,

Thank you for that suggestion. I am checking for deleted records before attempting to APPEND a new one. If the one that I am attempting to add has been there already and deleted, then I just RECALL it.

Jim