General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
APPEND BLANK to cursor, CANDIDATE INDEX, index violations
Environment versions
Network:
Windows 2003 Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only