Re: Reapplying successfull batch updates

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 02/05/05 

Date: Fri, 04 Feb 2005 21:08:07 -0600

>Meanwhile, it seems a bit perverse to have to save/load from file when after
>a rollback the local recordset has the correct values but just does not know
>that it has to send them to the server. It means that the user can see the
>values on screen, but if they don't edit them again they won't get saved.
>I'm thinking that since I have the values then all I have to do is loop
>through all the field values setting them to themselves, of course there is
>no way to differentiate between the ones that have changed (since the user
>started editing) and the ones that are the same, but then update the whole
>lot - that's what the save/load from stream is doing isn't it?

The problem is that the recorset no longer has OriginalValues that match what
the values in the database so a post can't do a comparison to know if the fields
have change. The saveToStream should save both the currentValue and
OrginalValue for each field and restore those to the dataset with a
loadFromStream 

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com

Relevant Pages

  • Re: Dupe
    ... A rollback to 1.6 and I will have to consider leaving WoW. ... > been zoning in and out of Maraudon orange non-stop for days. ... > attempt to zone into an instance after a crash of the world server. ... > smear the trail and make the dirty gold impossible to trace / remove. ...
    (alt.games.warcraft)
  • Re: kill not working
    ... was waiting on the killed process and it allowed the rollback to occur. ... > I've seen posts on the internet that have required cycling the server ... > SQL Server. ...
    (microsoft.public.sqlserver.programming)
  • Re: transactions between two databases different instances same sever
    ... full server was stopped with a power cut. ... When we power on server again I started both instances A and B. ... transaction is completed, but in other instance a transaction was ... so this other instance made a rollback. ...
    (comp.databases.informix)
  • Re: Installation of Exchange 2000 SP3
    ... Exchange service packs are not generally speaking "rollback friendly". ... sure and back up the server, ... and restore the information store. ...
    (microsoft.public.exchange2000.general)