Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stored procedure is executing
Message
From
14/12/2000 18:33:35
 
 
To
14/12/2000 10:35:10
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00453343
Message ID:
00453681
Views:
17
>>Periodically, I get a "Stored procedure is executing" error when exiting my application. How did you solve this problem ?
>
>Sorry to hear that, but I'm glad that someone else has seen this, too. :)
>
>I haven't solved it yet.
>
>You might check that an SP is actually executing. In my case it wasn't - hopefully, for my sake, it's not in your case either. That would mean I'm not crazy. <g>

I've seen this happen when triggers or field validation rules were fired off as a result of the shutdown - if TABLEUPDATE() got triggered for optimistically buffered records during your form close procedures, for example, it's very possible that SPs were in progress when the QUIT was issued. Try adding a fewseconds of delay in the shutdown operation - I usually display a splash screen for 5-10 seconds telling the user that shutdown is in progress to allow for things to clean up their data before actually exiting from the app, especially when the data is out on a relatively slow or busy LAN.
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