Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Prevent a query in case of necessity.
Message
De
26/11/2006 18:01:47
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
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:
01172522
Vues:
14
CANCEL doesn't interrupt the query - the query was already interrupted with the ESC key.

You must just consider how you want to handle the interruption, for instance, tell the user that the query was interrupted and that the process can't continue:
if llInterrupted
  MessageBox("The process was interrupted.")
  return
endif
>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
>
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform