Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>How would you insure that the entries in a given field are unique OR blank? That is, multiple blank records are OK but if data is entered, it must be a unique value. Setting up a candidate index doesn't work due to the blank fields.
>
>SELECT cField, CNT(*) AS nCnt ;
> FROM YourTable ;
> WHERE NOT EMPTY(cField) ;
> GROUP BY cField ;
> HAVING nCnt > 1 ;
> INTO CURSOR Dups
>
>This gives you a list of duplicate values.
>
>Tamar
Thanks Tamar. This would find duplicates if there are any, but how would you prevent them in the first place? I'm thinking some kind of code in both update and insert triggers might be the way to go, but I'm not really sure.
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