Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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
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