I suspect ThomasG's reply is the answer, but here's another thing to consider...

(I've replied in this vain 2-3 time in the last few days, but I am not stuck in a rut < s >)...

I've seen weird stuff like this when the alias involved is for cursor made by a Select-SQL and VFP opted to provide the result as a "filtered result set" instead of a real cursor. I don't think VFP6 has the NOFILTER clause for Select-SQL, but I believe that adding a "... .F. AS Dummy..." as a field in the SELECT clause will evade VFP's action.

Another possibility is that the table in question has a numeric as its first character, in which case VFP will make up it's own alias which a USED() would never find.

good luck



>I have a function that usually hums along, but has recently come up with an intermittent problem. The code is very simple:
>
>if !Used('ABC')
> use abc in 0
>endif
>select abc
>.....
>
>The problem is that Used() on occasion will return .t., but when I try to select the table, I get a "table is not open" error. The same function runs fine 99% of the time, and I cannot recreate the problem at will.
>
>When it does fail, I can see that the table (or at least the alias) is not open in the current data session even though Used() returned .t.
>
>I know I have seen other posts similar to this, but they don't seem to be coming to me in a search.
>
>Can someone help?
>
>TIA,
>Margaret