Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Delete duplicate records
Message
De
27/11/2006 11:21:31
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turquie
 
 
À
27/11/2006 10:35:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01172620
Message ID:
01172695
Vues:
19
Don't you delete all records with that? He needed two records each key.

>Metin
>
>Wouldn't it be best to set the order to the index Tariq had?
>
>Then (assuming always 3 of each or just 1), something like:
>
>

>SCAN
> llFound = .F.
> lnRecNo = RECNO()
> xdate = date
> xvoucher = voucher
> xtype = type
> xSeekKey = DTOC( date) + str( voucher) + Type && NOTE not ALLTRIM( Type) when used in key.
> Do while llFound
> If INDEXSEEK( xSeekKey, .T., "ThisTable", "TariqsIndex")
> Delete
> llFound = .T.
> Goto lnRecNo && Don't even think this necessary
> Endif
> EndDO
>EndSCAN
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform