>For some reason, my view definitions seem to disappear from the database where they are located.  I am using FPD26 tables in a local view, and the views work OK when I use them immediately after creating them with the view designer.
>
>But after exiting VFP and reentering, the view name is still in the
>database, but the tables are no longer identified in the view designer, the SQL commands are missing, and the filters, etc all have to be reset.
>
>Any thoughts?
>
>Joel Aiken
>jaiken@mindspring.com

Joel,

My guess is that you're having a pass problem. What you might do is define your views, exit the project, run GENDBC.PRG (under \TOOLS\GENDBC), or better, GENDBCX. This will generate the FoxPro code that's in your DBC. Go to the views section and check how the DBC accesses your 2.6 tables.

Jose