Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Prevent a query in case of necessity.
Message
From
26/11/2006 18:01:47
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01172519
Message ID:
01172522
Views:
13
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)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform