RollbackTrans methos still set Underlying Values

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.

.

Relevant Pages

  • Re: RollbackTrans methos still set Underlying Values
    ... > When I rollback my transaction using ADO's Connection.RollbackTrans ... > that ADO is attempting to issue an Update statement, ... I am using ADO 2.8 to connect to an SQL server databse. ... After your rollback try this... ...
    (microsoft.public.data.ado)
  • Re: Connection types and speeds
    ... The memory used by holding the connection open is not ... All recordset inserts seen to consequently have 0ms execution time, ... actually written to the database while the code has regained control ... RecordsetClone of a form) when a transaction was rolled back, ...
    (microsoft.public.access.queries)
  • Re: commit or rollback a transaction without first beginning a transaction
    ... I understood the opposite; that when a recordset ... the recordset before entering the transaction, ... > what happens with a Jet recordset. ... >> a single connection, so when SQLTransact is called, all statements on the ...
    (microsoft.public.access.modulesdaovba)
  • Re: Delete event not followed up with BeforeDelConfirm or AfterDel
    ... I take it you are trying to wrap your own transaction around all the ... inserts, edits, and deletes in both a main form and a subform. ... decision to either commit or rollback. ... recordset within that transaction, open a form, and assign your recordset to ...
    (microsoft.public.access.forms)
  • Re: "cant open any more tables"
    ... Assign the workspace variable, then the transaction, ... If you do need to close a recordset, ... >> updates every time through the loop. ...
    (microsoft.public.access.modulesdaovba)