Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Descending Indexes
Message
De
17/04/1999 17:24:03
 
 
À
17/04/1999 12:19:07
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00209331
Message ID:
00209420
Vues:
19
>Josh,
>Thanks for the reply. What I was trying to do was get the last entry for a particular customer. Creating the index on ACCT DESC in Fox2.5 did this but in VFP if gets the FIRST entry for the Customer even though ACCT are listed in descending order in the table. It seems to me that to constuct the index in this manner must mean extra work on VFP's part so there must be some sort of reason for it - which I can't figure out.

No, it means that when traversing the index; it arrives at the node for identical keys and runs through the children of that node in the fastest possible order of traversal, which may not be processing from the last leaf of node to the first; in fact, forward tranversal through a list of equals is almost certain to be faster if equivalent keys are grouped together as a singly-linked list.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform