General information
Category:
Database 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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only