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