To reproduce, run the code under VFP 9.

Observed result: empty browse window
Expected result browse window with one row.

Notes.
1. This problem does not occur in VFP 7.
2. SET ENGINEBEHAVIOUR does not fix this.

This breaks my application. Any idea how to fix this ?

CREATE CURSOR test ( test c(10) )
INSERT INTO test VALUES ('test')

CREATE DATABASE temp

create sql view DOKLSTL as sele * from test

RENAME VIEW DokLstL TO Originaal
CREATE SQL VIEW DokLstL1 AS SELECT * FROM Originaal

SELECT 0
USE doklstl1
BROWSE