On Monday 24 December 2007 04:34:38 pm johnf wrote: > On Monday 24 December 2007 03:23:45 pm Adrian Klaver wrote: > > Problem: > > Open form with data. Make change in form field from Dabo app. Make > > committed change in same record but different field from outside app i.e. > > psql. From form do save(). Database has Dabo changed field updated. Do > > requery() , db is queried but non-Dabo change is not shown until an > > update() is done. Why? Shouldn't the requery() pull in all the new data. > > If point 3 is correct then the new form resident data should equal the db > > resident data after the requery(). > > It sounds like when you did a save() from Dabo the dataset/cursor was > committed and over wrote what you did using psql. To be sure we are on the > same page. > > 1. On the form you have a control that has a DataField= 'formData" you > make a change. > > 2. you use psql and update the same record changing only a different field > = "psqlData". > > 3. You do a self.Form.save(). > > 4. You do a requery() and don't see "psqlData" matching the data you > updated with psql. > > Dabo has an object called 'memento'. Which will cache only the changed > fields and provide only the changed fields to the update statement. At > least that is my understanding. So in theory your requery should have > retreived all the data including the both changed fields. If I'm right it > sounds like this is a bug. > > Do you have an example of a form that show this bug - can you post or send > it to me?
Sorry Adrian I can NOT confirm this issue. In my case I opened my customer form with pkid=12. The country field = 'USA' which I changed to 'MYTEST'. I then opened psql (on a different computer) and issued the following: update arcust set ccity = "MyCity" where pkid = 12 I then issued a self.Form.Save() from my form. I then opened the debug window (ctrl-d) and issued a "self.requery()" I then saw both of my changes. Like I said earlier dMemento takes care of this problem and has been working for a long time. Something else is going on! -- John Fabiani _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
