Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using alias in lookup()
Message
From
12/11/2004 09:22:09
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
Miscellaneous
Thread ID:
00960793
Message ID:
00960812
Views:
8
>Hi All,
>
>Here's some code someone else wrote.
>
LOOKUP( EmpFcur.Both, M.EmpNo, EmpFcur.EmpNo, 'EMP' )
>It looks up a value in the alias EmpFcur. It appears to work, even if EmpFcur is not the currently selected alias. I assume it is an undocumented, and very handy, feature.
>
>Any comments?

You see the phrase "current selected work area" ? no

LOOKUP has other property beneficial (or maleficent if they are not known!):
CREATE CURSOR master ( aa i DEFAULT RECCOUNT())
APPEND BLANK
APPEND BLANK
CREATE CURSOR child ( aa i,bb i)
INSERT INTO child values (0,-1)
INSERT INTO child VALUES (1,-2)
INDEX ON aa TAG taa
SET RELATION TO aa INTO child IN master
? LOOKUP(child.bb,1,master.aa)
? LOOKUP(child.bb,0,master.aa)
CLOSE TABLES ALL 
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform