>>>>>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.
>>
>>Great sugestion Jim
>>
>>Einar
>
>To avoid problems with multi-user access, a temporary index should not have a fixed name. Assign sys(2015) to a variable, create the index with that name, and delete it later.
>
>Hilmar.
Yes we use a tempname function with the random generator function to ensure unique(well close to unique) idx name.
Einar
Semper ubi sub ubi.