Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Prevent a query in case of necessity.
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Prevent a query in case of necessity.
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01172519
Message ID:
01172519
Vues:
50
Is there any alternative command or technique instead of "cancel" command at the interrruptmessage procedure. Because "cancel" don't prevent the query it also quit the whole program. I want to cut only running query in case of necessity.

Thanks in advance

Altun
cQryStr = "select * from customer where name like 'A%'"
cEscState = set("escape")

set Escape on
ON ESCAPE DO interrruptmessage
&cQryStr
set Escape &cEscState



*****
procedure interrruptmessage()

if messagebox("To stop the query  press 'OK', to continue press 'Cancel' button.", 1+32)=1
        messagebox("Query cancelled", 0+16)
	cancel		
	return .F.
else
	wait window "Query is continuing." nowait	
endif
return .F.

ENDPROC
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform