Using alias in lookup() - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Using alias in lookup()

Message

From

12/11/2004 09:22:29

Mark McCasland
Midlothian, Texas, United States

12/11/2004 08:58:08

Peter De Valença
Haarlem, Netherlands

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: Using alias in lookup()

Environment versions

Visual FoxPro:

VFP 7 SP1

Miscellaneous

Thread ID:

00960793

Message ID:

00960813

Views:

Works that way for me in VFP9.

>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?

Mark McCasland
Midlothian, TX USA

Map

View

Click here to load this message in the networking platform