Re: Trapping CommitTrans - returns success even when failed!

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: Trapping CommitTrans - returns success even when failed!
    ... I have an 'On Error Resume Next' statement just before the CommitTrans. ... Error collection in ADO could be empty, ... > suppose to generate an error that could be trapped by error handling part ... >> handler for ADO CommitTrans. ...
    (microsoft.public.data.ado)
  • Re: one more thing about Errors in VB
    ... ADO Function recordset I mentioned. ... He is apparently here with an agenda - to denigrate VB's error handling. ... I can't see how a Typo error could sneek thru the compiler!? ...
    (microsoft.public.vb.general.discussion)
  • Re: Quick RDO question
    ... I know but doesn't RDO support the Error collection object the same as ADO ... Chris Hanscom - Microsoft MVP ...
    (microsoft.public.vb.general.discussion)
  • VB / ADO 2.6 Locked records error code
    ... What is the error that is thrown by ADO 2.6 in VB 6.0 when you try to ... Does the error appear in the VB Err object or does it appear in the ADO ... Connection's Error Collection? ...
    (microsoft.public.vb.database.ado)
Loading