Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stored procedure is executing - but not really
Message
 
To
03/12/2000 21:26:52
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00448662
Message ID:
00449147
Views:
15
Trey,

Just a WAG, but is there any chance that there are uncommitted changes in the Audit buffer? Can you add a message or log file entry to both the 'known' SPs to see if either is called when you get the "SP is Executing" message?

Barbara

>Periodically, I get a "Stored procedure is executing" error when exiting my application. However, there is no stored procedure executing.
>There are only 2 stored procedures - an ID generation procedure and an auditing procedure. Each of these are triggered by data changes (default value of PK, and update/delete for the audit).
>
>I get this error even if no data changes have been made.
>
>The data is all VFP, w/ views used only for reports.
>
>What else might throw that error?
>
>TIA
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform