Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>Several tables are related in a form. I'd like to order the main (navigation) table by a description field that is in one of the reference tables without using views. Is there a way to create a temporary index that will just disappear when the tables are closed, eliminating future problems if the application should have an abnormal ending?
>>
>>TIA,
>>
>>Alex
>
>Try using: INDEX ON eExpression TO IDXFileName
>
>IDXFileName can be anything and will have to be deleted after use (unless you want to keep it around)
It could also be deleted at application startup, then create another afterwards. This way an abnormal end previously should cause no problems in its regard.
>
>Einar
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