Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Prevent a query in case of necessity.
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Prevent a query in case of necessity.
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01172519
Message ID:
01172519
Views:
49
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
Next
Reply
Map
View

Click here to load this message in the networking platform