In this case the object oConn.errors.count return 0 (zero)


>Did you check the Errors collection on the Connection object?
>
>-Mike
>
>>Michel, My string contains many inserts or updates, see:
>>
>>

>>text to MyString noswhow
>>     insert into MyTable1(fields) values (values)
>>     insert into MyTable2(fields) values (values)
>>     update MyTable3 set field = value where fieldkey = filter
>>     insert into MyTable4(fields) values (values)
>>endtext
>>

>>
>>When I send this string to SQL and a trigger error occurs in any line, this error don´t return to me.
>>
>>If I send line by line to SQL the trigger error return to me.
>>
>>
>>>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.