>>To know what is going on, use the SET command to interactively check for open tables.
>
>Hilmar, I have done this and the table is not USED(). However, trying to USE it without the AGAIN statement results in the file in use error. Trying to USE the table to close it shows the "alias mytable is not found" error. The only thing I can think of is that there is some unfiltered view being created somehow based on the table but I have only one SELECT statement for this table and that performs a SELECT INTO array operation.
>
>Paul
It may be opened in another DataSession, especially if you use forms with private datasessions. The SET command can also show this, but you have to select the different datasessions (if more than one is open).
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)