Re: Trapping CommitTrans - returns success even when failed!

It makes no difference. I removed all error handlers. No runtime error
ocurrs.

"Val Mazur (MVP)" <group51a@xxxxxxxxxxx> wrote in message
news:%23Fb5FV4pFHA.3304@xxxxxxxxxxxxxxxxxxxxxxx
> 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

  • Re: XP/he - Mystery Process
    ... Welcome Scott. ... Ramesh - Microsoft MVP ... Los Angeles ...
    (microsoft.public.windowsxp.newusers)
  • Re: horiz. rule cannot be removed
    ... Bill Foley, Microsoft MVP ... Check out PPT FAQs at: http://www.rdpslides.com/pptfaq/ ... "Scott" wrote in message ...
    (microsoft.public.word.docmanagement)
  • Re: Active Directory - People Search
    ... Scott ... >Check your gather logs and make sure the content ... >Microsoft MVP - SharePoint Portal Server ... >Expert Zone - ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Lack of connection
    ... Chris Lanier ... Microsoft MVP - Digital Media ... "scott" wrote in message ...
    (microsoft.public.windowsmedia.player)