Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Stored procedure is executing - but not really
Message
 
À
03/12/2000 21:26:52
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00448662
Message ID:
00449147
Vues:
9
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform