A trigger is consider part of the transaction that caused it to fire. Any exception raised by a trigger should be returned even exceptions that are explicitely raised using RAISERROR().
>I´m using vfp 7 with sql server / oledb / ado
With ADO, you'll have to pull the errors from the Errors collection on the Connection object.
-Mike
>Hello *.*
>
>When I execute a command like INSERT, UPDATE or DELETE and occurs an error in some trigger, this error don´t return to my interface. Why? What can I need to do to return a message?
>
>When it occurs, @@error is empty.
>
>I´m using vfp 7 with sql server / oledb / ado
>
>Thanks in advance.