>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!

Mike,

I can not make it to work. Do I need to show a progress bar in order to be able to stop it?