Frndz, Asume that we have some error in stored procedure. We shall control that error by using transactions in Backend(Sql Server). But how z t possible to give the information to the front end application that error has occured in backend ? Will anyone plz help me.
If u cant able to understand plz mail me at mneduu@.gmail.com
Thankz in Advance.
Thanks & Regards
(M. Nedu)You could have a variable as an integer, you can set the varaible with @.@.ERROR. The variable will assign a number in the varaible if an error occurs.
Then before you commit your transaction you can have an if stment, so
If @.Variable <> 0
Begin
@.Reason = 'what ever you want to put in'
End
Else
Commit
Somthing like that
No comments:
Post a Comment