Could you put together a sample of code that demonstrates the issue? Maybe use the Pubs or Northwind database?
-Mike
>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.