Information générale
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
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
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