Gabriel,
I've never seen it take more than a fraction of a second to load a view with the "NoDataOnLoad" set. Can you repeat this in a PRG and from the command window? If it's in a form are you sure it is this command?
Are these very complex views loading multiple tables?
Are your indexes set to optimize Rushmore (or SQL-Server if that's where your data is)?
Barbara
>When attempting to use a view without downloading data either by means of the nodata clause in the use command, or by setting the cursor's NoDataOnLoad property to .T. when the view is added to a form's dataenvironment, the view is first executed.
>
>When dealing with large tables this can take a long time (about 3 to 4 minutes in my case). Is there any way to prevent the execution of the view.
>
>I could create a cursor instead of using a view, but as I understand it, a view is faster than a cursor.
>
>Any ideas or suggestions would be appreciated.