General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Is there any way of adding a record to the middle
>of a table, rather than a new record always going
>to the bottom of the table. Would be handy for list
>purposes.
Yes, there is a way that I presume still works, but you really don't want to use it. It is the INSERT command, but it will be sllooowwww, and there is another way. . .
Make a TAG (INDEX) on the field(s) that you would like to have the list ordered by, then set that index to be the active one before you list. This way you can list it by many fields, in their order for each list, rather than just one order.
Jim Nelson
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