Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL escape function
Message
From
01/02/2000 13:33:37
 
 
To
01/02/2000 13:28:54
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00325712
Message ID:
00325718
Views:
21
>Hello,
>I'm working on a SQL in FoxPro 2.6, and I want to give the user the chance to escape from the long query with pressing the ESC button.
>What is the best way to do that?
>I would have a solution, but I'm not sure whether this is the best, and I wanted to hear some other ideas on this.

The only 100% effective way, and it's expensive in terms of overhead, is to insert a UDF() in the WHERE (and if in use, the HAVING clause as well) that calles DOEVENTS(). VFP is not happy being interrupted in the midst of executing a single line of code, with the result that it oftens seems to be not responding in Task manager, and it ignores standard Windows messages in this context as well.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform