Hello
can't you just do a
if used('table1')
select table1
else
use table1
endif
>Hi,
>
>I'm experiencing a strange behaviour with a SQL-SELECT command. When I perform
>SELECT fielda, fieldb, fieldc FROM table1 WHERE condition1
>a cursor with the results is created. If I issue
>USE IN 'table1'
>and then I ask to
>USE table1
>I get the 'File is in use' error message, as if table1 was opened (which no longer is since the USE IN command has closed it).
>
>What might the problem be here?
>
>TIA,