Hi,
I've found the following bug (??) in VFP 9 opening cascade view with NODATA clause.
I open the view with the NODATA clause and after issuing REQUERY():
- in VFP 8 I get the result of 2 records - as expected
- in VFP 9 I get an empty cursor - as not expected

In VFP 8 opening the view V_Upper with the NODATA clause prevents only this view
from filling with data, the view V_Lower has its data in place. Following REQUERY()
than works as expected.

In VFP 9 opening the view V_Upper with the NODATA clause prevents both V_Upper both
V_Lower from filling with data. Following REQUERY() does not fill the V_Lower
with data, so the resulting V_Upper is empty too.

Is this a bug ? Is it expected to be corrected in the VFP 9 SP1 ?
If it is not a bug, but the feature, why it is not mentioned in the VFP 9
documentation in the chapter "Changes in Functionality for the Current Release"
in the "Critical Changes" section ?

Any suggestions ?
Have I to wait for VFP 9 SP1 or have I to rewrite my applications ?

Here is the code (only for bug-demo):

CLOSE DATABASES ALL

CREATE DATABASE TryDB

CREATE TABLE TryTable ( Jmeno C(10) )
INSERT INTO TryTable VALUES ( "Igor" )
INSERT INTO TryTable VALUES ( "Jane" )

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_Upper NODATA 
REQUERY()
* resulting in empty BROWSE, while expecting 2 records
BROWSE

CLOSE DATABASES ALL