>>>I have a form with a DE. If I set the views NoDataOnLoad property to .F. it takes a significant longer time to open the form than if I set it to .T. and just Requery in the Init of the form. Is this usual? And does it make a difference which way it's done? Thanks!
>>>
>>>Regards, Renoir
>>
>>Renior;
>>
>>Yes, that is normal and the correct way to do it. Otherwise you pull all the data and have to wait until it is through. Set the view to NoDataOnLoad = .T. You learn this quickly when you have 24 tables and a million records to work with when you open a form. :)
>>
>>Tom
>
>Hey Tom,
>
>Why does it take so much longer? Is there a time when you would want to set the propery to False? Why does the property exists? So few questions, so much time... :-)
>
>Renoir

Renoir;

If you set NoDataOnLoad to false, you are pulling all the data from a view (table or tables). The greater the number of records the longer it will take. If your data is on a network this will be an additional hit. To minimize the time it takes to open a form you set the property to true. No records are loaded or requested by your form. When you request data, you pass a parameter and do a requery on a set of data. Data sets should be kept small.

I have worked with tables containing large amounts of data. This is a real time saver. Your form will not instantiate until the data has been pulled. Setting the property to true tells the form the data is ready - like right now (sneaky)!

Tom