I am having fun with Visual FoxPro once again.
FORM'S DATAENVIRONMENT:
I have one Local View, vProjects, which selects two fields, Project_No and Proj_Name, from the Projects table. I also have 3 tables in the DataEnvironment.
As the WHEN Event of the first control on the form hits, I INDEX the two fields in vProjects.
The form seems to take about 5 or 6 seconds to load, possibly due to the relations set in the DataEnvironment, or maybe the execution of the view.
The form has 4 grids on it. Each grid represents a view or table.
vPROJECTS does a 1 to Many relation out to the POHeader table. POHeader does a 1 to Many out to 2 tables, PODetail and Costs.
vPROJECTS (Project_No)
|
POHeader (PO_Main)
|
PODetail-------------Costs
I read someone's opinion that we should not mix Tables and Local Views in a DataEnvironment. Why not?
Is the opening of the above tables what may be causing the form to instantiate more slowly. It seemed faster when I didn't use a View.