Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
No Duplicates
Message
De
04/05/2010 17:01:48
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
01462570
Message ID:
01463112
Vues:
23
>
>If your original table doesn't have an ID field (or fields combinations making a unique key), then in VFP the only way would be to rely on recno()
>
>I already posted this version in my previous replies.
>
>If you want to add this to the select, then
>
>select Name, cast(0 as I) as IDField from myTable group by Name having count(*) > 1 into cursor csrDups readwrite
>
>replace all IDField with recno() in csrDups

I tried that(the first line) but im not sure the query is liking the cast
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform