Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error in stored proc
Message
De
23/10/2009 09:28:22
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Divers
Thread ID:
01430571
Message ID:
01430976
Vues:
39
At least, we can say it's a bug

And it's not only try/catch. I have tried it with the classic on('error') and also with a class with an error function in it (createobject + execute function new_ix)

All scenario's had the same result
_

>The error was intercepted by TRY...CATCH so from VFP point of view there was no error. Unfortunately, TRY...CATCH implementation in VFP is not very good. An error caught by TRY...CATCH affects state of some internal VFP structures, unrelated to the error, which in turn produces such side effects as this one.
>
>>
>>I understand the whole construct now - why it didn't error on a cursor - which is exclusive
>>
>>If not exclusive, it tries to lock the header, append and fill the default values. If any error has occurred in that sequence, it thinks it was not possible to lock the header
Gregory
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform