Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
For this problem I've always ended up doing an index on command to create a temporary index on the view after the original data has been pulled. I think one advantage to this solution is you don't have to requery the view to change the order. One problem is that you need to write the temp index to a local drive to avoid potential multi-user conflicts over the index.
g
>Hi all,
>
>i have some views in my database with table buffering on them. The records of these views are displayed in a grid with no order. Now i want to requery them with an order free to chose by the user.
>
>I wonder if its possible change the 'query code' behind the view to the chosen order and to requery the view.
>
>thnx.
Précédent
Suivant
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