Best way to check a table for duplicates??? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Best way to check a table for duplicates???

Message

De

12/02/2002 15:37:09

Bryan Smith
Orion Seven Systems
Cheney, Washington, États-Unis

À

12/02/2002 15:28:14

Sunshine Smith
Computers
Tallahassee, Floride, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: Best way to check a table for duplicates???

Divers

Thread ID:

00619081

Message ID:

00619088

Vues:

20

Hello,

I use an SQL select to grab my duplicates. This may start you off down the right road.

SELECT * from YOURTABLE into cursor YOURCURSOR GROUP BY &cPrimaryKey HAVING COUNT(*)  > 1

Hope this helps.
Bryan

Click here to load this message in the networking platform