>Hi Elyse.
>
>>I've marked all of my views as NoDataOnLoad in the DataEnvironment but they still take a long time to open. Why would the statement USE MyView NODATA take a long time to execute?
>
>There was a tip in FoxPro Advisor a few issues back on this topic. If I recall, it's due to the way VFP handles SET DELETED when you open a view NODATA. Try SET DELETED OFF before opening the views NODATA, then SET DELETED ON; that seems to improve the time VFP takes to create the empty cursor.
>
>Doug
I don't understand why, but this helped tremendously! Now the views load instantaneously. Thanks!
Elyse
Elyse Pomerantz