>Not sure if this is a BUG, but you may use the V_Lower BEFORE REQUERY() V_Upper

Of course I can. But it looses its magic - the view definition may be far complex
than in my demo and opening all the sub-views in advance means you must study
the view definition, before you use it, to open all the necessities. The VFP8
solution was better for me.

>SET SAFETY OFF
>CLOSE DATABASES ALL
>
>CREATE DATABASE TryDB
>
>CREATE TABLE TryTable ( Jmeno C(10) )
>INSERT INTO TryTable VALUES ( "Igor" )
>INSERT INTO TryTable VALUES ( "Jane" )
>FLUSH FORCE
>
>CREATE SQL VIEW V_Lower AS SELECT * FROM TryDB!TryTable
>CREATE SQL VIEW V_Upper AS SELECT * FROM TryDB!V_Lower
>
>USE IN V_Lower
>USE IN TryTable
>
>USE TryDB!V_Lower
>USE TryDB!V_Upper NODATA  IN 0
>REQUERY("V_Upper")
>SELECT V_UPPER
>GO TOP
>BROWSE
>
>CLOSE DATABASES ALL
>