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