Mike,
Thanks, that was along the lines I was thinking, though I was not sure it would work for a view.
I think, I need to try to speed this query. My current problem is that there are 7 tables to join and variable number of parameters set.
I have another problem with this view, it is returning duplicates.
>Hi Nadya
>
>>Hi everybody,
>>
>>I have a local p-view with lots of parameters. It is created by joining 7 different tables and it has long time to requery(). Is there a way to stop requery() by hitting ESC?
>>
>>Thanks a lot in advance.
>
>I provided a feature like this to Drew Speedie who promptly made it part of Visual MaxFrame Professional. The basics of it are ...
>
>Add support for Error 1839 to your main errorhandler routine. That's the error you get when you escape from a query.
>
>*Remember the current SET ESCAPE and ON ESCAPE settings.
>SET ESCAPE ON
>LOCAL m.llQueryStopped
>m.llQueryStopped = .F.
>ON ESCAPE m.llQueryStopped = .T.
>REQUERY()
>*Restore the previous SET ESCAPE and ON ESCAPE settings.
>
>If the user hits escape, the error handler routine will do whatever you want with error 1839. llQueryStopped will be .T. so you can decide what to do. What's really cool about this, is that if there was data in that cursor before the requery, that data will still be there after the ESCAPE!
>
>Good luck!
If it's not broken, fix it until it is.
My Blog