Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
_tally
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Re: _tally
Divers
Thread ID:
00762047
Message ID:
00762343
Vues:
16
>I don't see why not to use reccount() on the cursor after it's built.

Because it doesn't work in all cases.
It only works if VFP cannot optimise the query to a filtered view of the original table.
Or if the query is a join of tables.
Of if you use the NOFILTER clause to force a cursor instead.

I managed to totally BREAK an application somone else wrote, because they used RECCOUNT() on the result set instead of using _TALLY.
I addded an index to the table which made it a fully optimisable select statement.
VFP then returned a filtered view of the table, with _TALLY=1 but RECCOUNT() over 50,000!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform