>I've tried a few different ON ESCAPE possibilities - nothing, running some routine that displays a MESSAGEBOX, etc.
>
>The only way I've been able to escape out of the SELECT is by doing something I read about on UT, by incorporating some code in the WHERE clause that called a function that incorporated a DOEVENTS, but that slowed the SELECT to a crawl, so that doesn't seem to be an acceptable way to do it.
>
>If I understand, in theory it _is_ possible to escape from a SELECT that is running in a program?
>
>jd
Hmmm. If I have SET ESCAPE ON and ON ESCAPE is set to nothing, if I start a long SQL it will stop when I press escape. It may not be instantaneous, but it does stop before it completes. You don't see this? (VFP6/SP3) It's worked this same way for as long as I can remember, though.