Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexing with For clause.
Message
 
À
18/08/1998 09:38:28
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00127699
Message ID:
00127708
Vues:
27
>>Hi,
>>
>>I have a huge table. Before data processing I create temporary index:
>>
>>Select 0
>>Use SERV
>>Index On ENUM+STR(SNO,2) For BATCHDATE=ldDate To Temp
>>
>>How can I know how many records were filtered ?
>>
>>Sincerely, Igor Gelin
>
>Normally _TALLY will return it after INDEX. However, it was reported recently that it's not reliable, so you can fortify it by using COUNT or SELECT-SQL with _TALLY.

Thanks, Ed.

What makes _TALLY un-reliable in this particular case?
Igor Gelin.
Igor Gelin
Database Developer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform