Thanya,
How long does it take to run the same view from the command window or from the View Designer? Is it showing all of a very large table?

You may want to set NoDataOnLoad to .T. in your dataenvironment, then requery the view with parameters to limit the amount of fields.

As an example, I have an app running agains a SQL-Server table with about 100,000 projects in it. When the form loads, it goes directly to the 'Find Project' form, where users input all or part of a project number. The first 2 characters show the project office, the next shows the year. If a user enters less than 3 characters I warn them that getting the data may take a LOOONGG time.

If you aren't using parameterized views, check them out. VERY useful......

HTH
Barbara (the OTHER Barbara P.)

>Hi all,
>
> My problem right now is when I run the forms that based on views(either parameterized or not), a message shows up on the right side of the window said "Executing Remote- Press ESC to cancel".
> If I click ESC button, another error message come up on the screen says "called from PROCEDURE formset1.form1.buttonset1.init
> C:\program files\microsoft visual studio\vfp98\wizbtns.vct"
> If I let it run, after 4' the the form shows up but 4' to run a form is not right?
> I have been very frustrated about this.
>
> Anyone here have experience with this kind of problem, please help me. Any ideas, suggestions would be great help.
> Thank you in advance.