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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only