Re: Trapping CommitTrans - returns success even when failed!

I have an 'On Error Resume Next' statement just before the CommitTrans.
After the method executes we check Err.Number and it is zero!

"Val Mazur (MVP)" <group51a@xxxxxxxxxxx> wrote in message
news:uRaUQAfpFHA.3316@xxxxxxxxxxxxxxxxxxxxxxx
> Scott,
>
> Do not you get any error at all? Have not you disabled error handling in
> your code? Error collection in ADO could be empty, but your application
> suppose to generate an error that could be trapped by error handling part
> of the code.
>
> --
> Val Mazur
> Microsoft MVP
>
> http://xport.mvps.org
>
>
>
> "Scott Meloney" <scottm1100@xxxxxxxxx> wrote in message
> news:Oqp4wEGpFHA.3936@xxxxxxxxxxxxxxxxxxxxxxx
>> Using VB6, SQL Server 2k, ADO 2.8, I am trying to implement an error
>> handler for ADO CommitTrans. I pause in the middle of transaction, pull
>> the network wire, then write more records and call CommitTrans. It
>> completes without error even though the data was not written. I have
>> checked the Err collection both in the main line and using withevents.
>> They always indicate success.. Am I missing something?
>> TIA!
>>
>>
>
>


.