Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Network:
Windows 2003 Server
>I am creating a cursor with keyID = 'key_value' from joining several SQL tables and each SQL table has keyID and keyIncrement as fields. When the cursor is created, it has several duplicated keyIncrement records for the given key_value. Then, I create an index as "INDEX ON STR(keyID)+STR(keyIncrement) TAG idx_MAD OF cdxMembers UNIQUE" to eliminate the duplicate increment numbers. ....
Hi Kay,
Exactly what SQL are you using? How are the keys being duplicated? Does some table have several matching rows that causes the duplicates in the result set? If there are several matchine key combinations, what about the rest of the fields? If they differ, how do you know which values you want to use/
Using a Fox UNIQUE index has always been a bad idea.
Précédent
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