I'm going through some of the same things myself. My advice is to always plan on only requerying data when the page is activated. I'm using the activate event of the page to tell the view to requery.

One other note. My application is a front end to SQL 7. By putting my views in the data enviornment even though I set nodataonload to .T. it still has a lot of overhead just loading the views without the data. I'll probably end up pulling them out of the data environment and loading the views and data when the page is activated. This is something to consider if you think you'll be using your VFP front end over the Internet.


Greg Moss
www.siteproposals.com
gmoss@midwest.net

>I have a form that has a PageFrame with 7 pages each with a grid. The dataenvironment for this form consists of 7 views, with each view made up of a single table with the exception of Nameplatv which is made up of Nameplat and Cust tables. Some of the views are : Nameplatv(parent), Dgav(child), Icpv(child), Liquidv(child), etc. In my 7 pages with grids, I want to display records from a single search for each of the grids and their respective views. The search criteria will be CUSTID and UPSINO (which stands for upsi number). Both of these criteria exist in all views and tables. Some searches may be by CUSTID only. Questions:
>
>1)When and where is the best place to Load the dataenvironment? Do I let all tables and views (total 15 work areas) load on the form's "Load" event. Or do I load views only when used and if so where? For example the user may never even view the ICPV tab during any one session, but when they click on that tab I want the data to be there Fast.
>
>2)Or should I re-think my whole dataenviroment and make only two views (1) NAMEPLATV and (2) AllChildTables, thereby having only two views for the whole dataenvironment?
>
>My goal is to enable the user to lookup a single or group of records then double click on any one record in a grid and display another form containing the details of that record.
>
>Thanks for the suggestions and help
>
>Elgin Rogers Jr
>Epic Solutions