Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot access selected table???
Message
 
 
To
15/12/2000 12:30:15
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgia, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00453886
Message ID:
00454055
Views:
23
>I did not know this was a know problem. Let me see if I understand.
Solution 1
sele Alias2
replace Alias2.fieldname with somevalue
Solution 2
replace Alias2.fieldname with somevalue in Alias2
I'm not sure about the internals. Most likely VFP does an implicit select alias2 and then the replace when the IN clause is used. It then changes the workarea back to the previous state. This would be similar to the functionality of the NEWOBJECT() function. It performs an implicit SET CLASSLIB TO before the object is created so you don't have to. It then resets the CLASSLIB path to the previous state.

FWIW, you do not need to specify the alias.fieldname when you use the IN clause.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Reply
Map
View

Click here to load this message in the networking platform