Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL escape function
Message
From
01/02/2000 14:22:57
 
 
To
01/02/2000 13:43:21
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00325712
Message ID:
00325747
Views:
27
>>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.
>
>What is the bigger overhead, the UDF or the DOEVENTS? Sometimes you put a UDF in the where clause for updating wait windows for example.

Yep, in which case, you're already calling out of the single line of code. Both the UDF and DOEVENTS are "expensive", since neither is optimizable, the DOEVENTS in particular because lots of things like timers and controls might geenerate events that otherwise VFP would just queue up until it finished the current statement.
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
Reply
Map
View

Click here to load this message in the networking platform