Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Escaping from a lengthy SELECT

Status
Not open for further replies.

dsandlin

Programmer
Jul 11, 2003
56
0
0
CR
When working in the VFP IDE with a "SET ESCAPE ON" in effect, I am able to interrupt a long SELECT SQL statement, but it doesn't work when running the compiled EXE version.

Is there a way to interrupt the executeable?
 
dsandlin,

Actually, I'm surprised it even worked in the IDE. My understanding is that VFP will wait for the current command to finish before acting on the ESC key. At least, that's true when you are running from a PRG or method; it might be different if you run the SELECT from the command window.

You might try experimenting with ON ESCAPE. I'm not certain, but I think that will execute as soon as ESC is pressed, rather than waiting until the end of the command.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site: My Crystal Reports web site:
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top