Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Whats with my tables and how do I stop it
- Thread starter Tmole99
- Start date
Under the SQL standards a database engine is allowed to deliver data to you from a table in any order that it likes and there is no requirement for consistency.
The only exception is if you select the data using a query that has a defined sort order (Use the Sort line on the query grid or an ORDER BY clause if working in pure SQL).
Assuming you do not already have a suitable index column, what I would do is create a column in the table called form_sort_order and number the rows sequentially in the order that I wanted them to appear. I would use a Sort on the data in that column as the row source. You could index the column if there are more than a few records.
The only exception is if you select the data using a query that has a defined sort order (Use the Sort line on the query grid or an ORDER BY clause if working in pure SQL).
Assuming you do not already have a suitable index column, what I would do is create a column in the table called form_sort_order and number the rows sequentially in the order that I wanted them to appear. I would use a Sort on the data in that column as the row source. You could index the column if there are more than a few records.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question