Message When RollBack occurs

Hi, consult in the VB6 forum


-
Microsoft M.V.P en SQLServer
SQLTotal Consulting - Servicios en SQLServer
Email:
"jvtarazona" escribió en el mensaje
news:

Hello, I want to advise user when rollback occurs in diferents triggers.
At
now, i can do it executing RAISERROR with my msg, after rollback, but to
capture it in VB6 interface, i need to put an "On Error GoTo ... " line.

This is not "nice" programming.

How Can I inform the user why values was not been written?

Thaks fo all

Thanks, but question is how to make it in my stored procedures, trying to use
the less code possible in VB, and if it is possible not using RAISEERROR.

I use SQL Server 2000.
In SQL Server 2005 exists try and catch, but ... .

"Maxi" wrote:

Hi, consult in the VB6 forum


-

Bueno, parece que va a ser más un problema de filosofía que de codigo.

De todas maneras dejo este enlace, que puede servir de algo:

http://www.microsoft.com/communitie...=1&p=1

Al final, funcionaré con el RaiseError y a recorrer los errores que me
devuelva el objeto conexion.

Gracias por todo.

Vaya, pensaba que por un descuido estaba posteando en el de inglés, un
grandioso desliz (por no decir metedura de pata) por mi parte.

"jvtarazona" wrote:

Hello, I want to advise user when rollback occurs in diferents triggers. At
now, i can do it executing RAISERROR with my msg, after rollback, but to
capture it in VB6 interface, i need to put an "On Error GoTo ... " line.