Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
_tally not at home, sometimes
Message
De
15/08/1998 09:22:00
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00126995
Message ID:
00127141
Vues:
27
>Dragan,
>
>I think you should just save the _tally result after the command that creates the result set before you index the result.
>

Not applicable in this case. The routine I use to create the cursor just copies the structure of the underlying table into a cursor, with an additional rcn field to keep the original record number, does a seek and then copies records one by one via scatter/gather. I use it when I expect a very small recordset from a large table. In this case it's just one customer's unresolved records (i.e. unpaid invoices). Works faster than SQL for cases like this.

Of course, in a larger scale, it would be better to use a parametrized view and simply requery, which it will be once I get down to it. I was just bothered with the (unnecessarily) changed behavior of _tally - one more thing to watch out fore while migrating the code, and kind of a waste of time.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform