Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Did I miss something?
Message
 
To
06/02/2002 15:24:30
Kam Lee
SUNY-Health Science Center
Brooklyn, New York, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00615839
Message ID:
00616603
Views:
21
>Hi Jim,
>
>Does the IN clause cause any overhead ? Or we should use it regardless?
>Your view please..
>

Kam,

I don't know about overhead for the in clause. I use it when I need it, usually I select the work are I want immediately before tacking any action. I also restore the work area when I am done. For example;
* Save the current work area
LOCAL lcAlias
lcAlias = ALIAS()

*Select the work area to be affected
SELECT Whatever

* Do whatever the plan is
Do Something

* Now restore the work area
IF NOT EMPTY(lcAlias)
  SELECT (lcAlias)
ELSE
  SELECT 0
ENDIF
RETURN
This allows me to call this code from antwhere without being concerned if the work area is being changed.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform