Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Vfp50 - A question about VIEWS.
Message
From
30/05/1997 09:23:20
Matt Mc Donnell
Mc Donnell Software Consulting
Boston, Massachusetts, United States
 
 
To
30/05/1997 09:13:21
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00034234
Message ID:
00034235
Views:
29
>How do you switch to another work area, if the work area is a VIEW?
>I am use to SELECT mytable.

Actually, SELECT does not key on the table name, it keys on the alias, so it matters not if the work area contains a view, cursor or table.

try ..
SELECT myAlias

helpful hint...
In any function that requires selecting a new work area you may consider using this convention...
LOCAL lcAlias

lcAlias = ALIAS()

function code
.
.
.

IF !EMPTY(lcAlias)
SELECT (lcAlias)
ENDIF

HTH
Matt McDonnell
...building a better mousetrap with moldy cheese...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform