Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Progress bar and cancel in a SQL sentence
Message
 
 
À
24/09/2002 16:25:05
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00703979
Message ID:
00704041
Vues:
20
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform