activex_data_objects thread: How to rollback changes in a recordset w/o using the .value=.underlyingvalue
Fellow crackheads, hello!
I have been working on a data source class that performs validation on the
fields before it updates the recordset. Now my mind inquires, HOW DO I
ROLLBACK CHANGES IN A RECORDSET? I've tried using
the .value=.underlyingvalue technique but this doesn't work on new records
and ADO reports a runtime error. Using the connection's transaction
methods (BEGINTRANS, ROLLBACK, etc.) is out of the question because the
changes haven't been updated to the underlying recordset. The ADO's
WillChangeField event doesn't do any good either because it doesn't
reflect the fields new value eventhough its MSDN document states
otherwise. So I'm still here stuck with this predicament.
Anyone knows how to this?
--Joseph De Guzman