I found a solution.
I use the this tric.
select MyField... ;
from .\MyDBC!MyTable ;
into cursor MyCursor
>Hi Jean-René.
>
>>But if you have two DBC one in c:\MyData1 and one in c:\MyData2 which one is Open if you do this.
>>
>>Use C:\MyData1\MyTable in 0
>>Use C:\MyData2\MyTable in 0
>>
>
>Both DBCs are open in that case. Neither one is selected (ie. DBC() returns an empty string).
>
>>After this code you do this:
>>
Use MyDBC!MyTable2 in 0
>>
>>From which directory MyTable2.dbf is open?
>
>I looked into this several years ago, so my memory may be fuzzy, but I believe the DBC opened last is the one that's used in this case.
>
>>Is there a way to control which DBC is Open?
>
>You can control which one is selected by doing SET DATABASE TO (full path of the DBC). Then you can just USE MYTABLE rather than USE MYDBC!MYTABLE.
>
>>Can I Open a table, which is part of the DBC, without opening the DBC?
>
>No.
>
>Doug