Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Used() function returns .t., but table is not open?
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Used() function returns .t., but table is not open?
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Network:
Windows NT
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01032327
Message ID:
01032327
Views:
67
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
Margaret Duddy
mmd@outformations.com
Next
Reply
Map
View

Click here to load this message in the networking platform