Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexing - I'm just not getting it
Message
De
29/12/1999 22:26:46
 
 
À
29/12/1999 20:03:11
Information générale
Forum:
Visual Basic
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Divers
Thread ID:
00310169
Message ID:
00310205
Vues:
25
I can't be 100% sure on this, but I don't think that setting an index changes the physical layout of the data...therefore looping through it will still give you the exact order that the records were entered. The index only helps in queries, not direct table access unless you sort the table.

You could use something like:

SELECT * FROM table ORDER BY field

...and then loop through the cursor that is created. However, since you ran the query and have them in the correct order, you might as well just dump the whole thing out right there and save the step of looping through.

-Joe Kimbler
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform