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.