Re: RollbackTrans methos still set Underlying Values

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Frank,

When I try this, I get an error: Method or data member not found. I
searched MSDN Online and it says that this method is part of the ADO 2.8 API
Reference. I also double-checked my references and I am using ADO 2.8. Any
Idea why this method isn't available to me? (BTW... It looks like I forgot
to mention that I'm using Visual Basic 6.0 in my previous post.)

Thanks,
Scott

"Frank Hickman [MVP]" wrote:

> "Dead.Zone" <Dead.Zone@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:1CE65B7A-D025-4688-A4DB-2516A2B7929E@xxxxxxxxxxxxxxxx
> > Hello,
> >
> > When I rollback my transaction using ADO's Connection.RollbackTrans()
> > method, the data is not saved to the databse (which is good) but the
> > recordset has the current values in the Underlying Value property, instead
> > of
> > "Empty". (These are all inserts. I roll back the transaction if one of
> > the
> > attempted inserts already exists in the database.)
> >
> > Now that the underlying value fields are populated, I can't attempt to
> > save
> > the recordset after the user fixes teh offending rows. All unmodified
> > rows
> > are not sent to the SQL server. And modified rows give me an error that
> > the
> > data may have been changed since it was last read. This seems to indicate
> > that ADO is attempting to issue an Update statement, rather than an Insert
> > statement.
> >
> > Any help would be appreciated.
> > Thanks,
> > Scott
> > p.s. I am using ADO 2.8 to connect to an SQL server databse.
> >
>
> After your rollback try this...
>
> rs.SetAllRowStatus( adRecNew );
>
> --
> ============
> Frank Hickman
> Microsoft MVP
> NobleSoft, Inc.
> ============
> Replace the _nosp@m_ with @ to reply.
>
>
>
.

Relevant Pages

  • Re: How to get Leading Zeros passed
    ... if via ADO and a recordset then: ... if via an update statement then: ... there is a 1 in the cell then it displays 0001. ...
    (microsoft.public.excel.programming)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: DAO to ADO Recordset Options
    ... DAO was really fast when dealing with Access data (faster than ADO) but was ... Recordset. ... For client-sided cursors, there is only Static cursor type regardless as ... determines how often data is fetched from the server. ...
    (microsoft.public.data.ado)