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