Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Use Command not working
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00601682
Message ID:
00601689
Views:
23
Has it been used under a different alias?
USE MyTable ALIAS MyOtherTable
If so have to use the alias.

Otherwise, maybe a datasession problem, is it in a different datasession?


>Here's an odd one I've come across, and I can't figure out why this happens.
>When I use an If...Then to check for a table being open, before opening it,
>the if doesn't trap; it goes right to the open statement and then I get an error, "File Already Open".
>
>Sample:
>
>if !used('sometable')
> use sometable in 0 exclu
>endif
>
>I also tried it the other way,
>
>if used('sometable')
> select sometable
>else
> use sometable in 0 exclu
>endif
>
>The 'if' clause fails in both places. Any ideas?
>
>Bob Ohrstedt
>Cleveland, OH
>www.rjoassoc.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform