Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Any way to stop requery process for a local view?
Message
From
13/01/2005 13:00:45
Mike Yearwood
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
00976837
Message ID:
00976856
Views:
32
This message has been marked as the solution to the initial question of the thread.
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!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform