Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement