Re: Trapping CommitTrans - returns success even when failed!

Scott,

What happens in a case if you remove On Error Resume Next?

--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"Scott M" <scottm1100@xxxxxxxxx> wrote in message
news:ueADa20pFHA.3104@xxxxxxxxxxxxxxxxxxxxxxx
>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!
>>>
>>>
>>
>>
>
>


.

Relevant Pages