Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
To stop a long query
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00955739
Message ID:
00955742
Views:
12
Off the top of my head, does SET ESCAPE ON ( even temporarily) work, if you hit esc during the query?

>VFP 8
>
>I have a form with a pageframe on it
>when you go from page to page (depending on the customer selected) a query is run to populate the data on each page. well there is a page that has a invoicing history and some costmer have up to 5000 records. so the view retives 50 records at a time from old to newest. most of the time the user does not need to see all records so he/she can just change page to select another cust. I whnat to stop the unfinish query when the user goes to another page.
>
>is there a way to do this?
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Reply
Map
View

Click here to load this message in the networking platform