Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Logical record numbers ?
Message
De
25/05/1999 13:53:51
 
 
À
25/05/1999 10:44:06
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00222325
Message ID:
00222593
Vues:
30
That is a primo idea.

Of course, you could also b-tree (sorta) it where you populate an array with every n records, n being equal to INT(number of records/65000)+1. Then you ASCAN the value and if not directly found, regress unitl find. When found, if not directly found you scan the next "n" records in the table to find the exact match ... logical record number = (n/2)+1+number of records scanned.

>>That is an excellent ideal. However, I think arrays are limited to 65,000 records, and I don't think it would work if I hit the pgdn or pgup key.
>
>well, skiping 5/10 records forward from the last record you were on is still better that skipping 50000 records from the top of the file
>as for the the 65000 limit of arrays - using an array poperty and assign/access method you can create a "virtual" array that consists of multiple arrays also it may be enough to store just the current visible options
>
>Arnon
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform