Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2003 Server
>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement