Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing - I'm just not getting it
Message
From
29/12/1999 22:26:46
 
 
To
29/12/1999 20:03:11
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00310169
Message ID:
00310205
Views:
27
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
Map
View

Click here to load this message in the networking platform