Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Logical record numbers ?
Message
De
25/05/1999 10:30:13
 
 
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:
00222476
Vues:
29
>I need this type of function because I am using a 3rd part virtual listbox that requires me to populate the listbox myself. Lets say I have a listbox on a form that has 10 rows. Each time a row needs to be populated, a method called getdata() is fired where I populate each column in the row with data. A parameter called nRow is passed to the getdata() method which indicates the row number I am to populate. When there is no index order set, I can simply issue the go and then populate the columns. However, if an index order is set, issuing go will produce the wrong results. The Locate, skip works well, except when nRow is a large number.

you can keep a property that will hold the recno and/or key of the last record you fetched (or if needed of all the record currently fetched in an array)
and locate/goto or even seek to that record and then use a scan/for to get the next batch of records

Arnon
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform