Information générale
Catégorie:
Codage, syntaxe et commandes
In your ON ERROR routine, you will need to do a ROLLBACK to revert the changes.
HTH
>I do have an problem with tableupdate or any updation statements.
>Let me explain breifly my problem.
>I have begin trans and end trans statements
>with in this say for example i got an error which doesnt go to end transaction but hangs in between how do i revert the changes. Because if the system hangs in between it wont proceed further.
>
>Statements in between begin and end trans are insert,update and delete statements basically to add or modify or delete new records.
>I am ashwath an indian working in malaysia for an usa based company from atlanta.
>I have 2 and half years of experience in automated resource management system basically designed for an engineering company which has premier products like flowmeters.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement