This can be simplified further:

<pre>CREATE CURSOR test ( test c(10) )
INSERT INTO test VALUES ('test')

CREATE DATABASE temp

create sql view DOKLSTL as sele * from test

SELECT 0
USE Temp!DokLstL
*!* no records

Now if I CLOSE ALL, reopen the DBC, recreate the cursor, and USE the view, I get 1 record. i.e., the following works for me:<pre>
CLOSE ALL
ERASE temp.dbc
ERASE temp.dct
ERASE temp.dcx

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

CREATE DATABASE temp

create sql view DOKLSTL as sele * from test

CREATE SQL VIEW DokLstL1 AS ;
	SELECT * FROM DokLstL

CLOSE ALL

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

OPEN DATABASE Temp
 
SELECT 0
USE DokLstL1

>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