Wrox Home  
Search P2P Archive for: Go

  Return to Index  

activex_data_objects thread: How to rollback changes in a recordset w/o using the .value=.underlyingvalue


Message #1 by "Joseph De Guzman" <jake_sturm@y...> on Thu, 4 Oct 2001 03:52:54
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

  Return to Index