>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 used() function works with an alias name, not with the table name. Perhaps another table happens to be open with the alias "abc".

To avoid error messages, use the AGAIN clause, just in case the same table is already open, but with another alias.

Here is an example, to integrate both concepts:

CurrentMonth = "January"
if used("MonthlyData")
  select MonthlyData
else
  select 0
  use (CurrentMonth) again alias MonthlyData
endif

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