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