Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Use In Select('alias')
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00836723
Message ID:
00836778
Views:
15
>Nigel,
>
>I think, that is the best and safest way to close an alias.
>
>Any other solution like
>Select (cAlias)..USE or USE IN cAlias
>Will raise the run time error if cAlias is not used (opened).
>
>I am using the USE SELECT(cAlias) for 8 years now, and never had problems with it.
>
>Cheers,
>
>Zoran

There was a Tip in Foxpro Advisor somewhere in 2002, something like
use in iif( used(cAlias), cAlias, 0 )
I was one of the people who reacted with an optimization. Actually, mine was
use in select(cAlias)
Everybody agreed that it works, even according to theory.

I'm surprised to notice that Zoran has been using it for over 8 years, although I wonder about the syntax USE SELECT(cAlias). :)
Groet,
Peter de Valença

Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform