Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Checking for Duplicates
Message
De
17/02/2004 04:22:58
 
 
À
16/02/2004 09:09:29
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00877622
Message ID:
00877855
Vues:
10
Hi,

>
Does anyone know of a simple code that I can check for duplicate records within a table?
>

Looks like most of the solutions offered deal with duplicate fields. For duplicate records try something like:
SELECT RECNO() rec, SYS(2017) checksum from TableX INTO CURSOR myCursor
SELECT * FROM myCursor GROUP BY checksum HAVING COUNT(*) > 1
Regards,
Viv
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform