Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with Stored Procedures
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00092007
Message ID:
00092076
Views:
17
>We are already using VFP's DBC Stored Procedure, the trouble thing is sometimes (not all the time), upon terminating the apps using CLEAR EVENTS where: at Cleanup.prg we issued CLOSE ALL, and then an error box appears with message 'Store Procedure is executing'.
>
>Any Idea on this matter?

I've seen this when a user closes by the "X" rather than the Quit menu option. Closing through the window executes the ON SHUTDOWN which in my case does not traverse the open tables doing a TableRevert on them. I haven't had time to fully explore this, but it's definately at the top of the list of items to check when I do. I use stored procedures too although none could possibly be running at the time of ON SHUTDOWN execution. Let me know if you do experiment with this and what you come up with.

Steve
Previous
Reply
Map
View

Click here to load this message in the networking platform