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.