<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.
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