Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updating records in FoxPro tables
Message
 
 
À
05/10/2001 16:50:58
Leshel Rich
Plains Cotton Coop Assoc
Lubbock, Texas, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00565010
Message ID:
00565071
Vues:
26
>I have some dupe records that are causing me problems and I need to delete one of the dupes for each record in several tables. Is there a way to do that without deleting each individual record by hand? Is there a way to do it using the command line?
select KeyID, count(*) as CntDups from yourtable group by KeyID ;
       having CntDups > 1 ;
       into cursor curDupes
index on KeyID tag KeyID
select yourtable
set relation to KeyID into curDupes
delete for found('curDupes') && One of the dupes would be deleted
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform