>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
myAliashelpful 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...