Hi Stephen,

Of course I did. But the USED returns .F. and the subsequent USE table1 gives me the 'file is in use' error. That's why I said it's a strange behaviour!

>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,