Not sure if this is a BUG, but you may use the V_Lower BEFORE REQUERY() V_Upper
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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
