Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Progress bar and cancel in a SQL sentence
Message
 
 
To
24/09/2002 16:25:05
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00703979
Message ID:
00704041
Views:
19
>When I am executing an SQL sentence, how can i know the how many records i am processing,i am executing an .exe without the VFP environment.
>And I how can Icancel the SQL ?
>Thanks
* support user Escapes for interrupting query processing
		prevonesc = on('escape')			&& save previous Escape handler
		prevescape = set('escape')			&& previous Escape enablement state
		set escape on						&& enable escape handling
		querhalt = .f.						&& allow loop to run until this flag is toggled
		on escape querhalt = .t.			&& force immediate termination if user escapes
set talk on
set talk window noshow
select ...
set talk off
** Restore ESC settings
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform