On Monday 24 December 2007 05:22:31 pm johnf wrote: > 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!
I just read your reply to an earlier post. If you are using bizObject.save() it may the issue. Try 'self.Form.save()'. -- 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]
