>I have a problem deleting index file.
>
>I use command INDEX ON someExpr TO temp.idx on one table in one work area.
>
>I open same table in another work area and when I want to delete temp.idx it says that file is in use and I cannot delete that index.
>
>How to delete that index file because BEGIN TRANSACTION command is requiring that?

SELECT thetableAlias
CLOSE INDEXES