Could it be that the table is used several times, or with another alias?

>Hi
>
>I have a strange problem
>
>I use the
>

>USE MyTable IN SELECT('MyTable') 
>

>syntax for a while
>On some strange moments
>I receive error 3 File is in use
>
>What I see
>Prog is in a workarea without open cursor
>MyTable is open shared in an other workarea
>DATABASE is set correctly, SET DEFAULT points to the path of the database, only one database is open.
>A CA that uses this table and might write to it is open
>
>The line is normally running fine, but sometimes it fails.
>
>Any idea why?
>I know I can circumvent the very place, but to do this on ever in every place I use IN SELECT(). Ouch