On Monday 24 December 2007 5:33 pm, johnf wrote: > 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()'.
When I get a chance I will try this. If it does not work I will send the form and the table schema. Thanks, -- Adrian Klaver [EMAIL PROTECTED] _______________________________________________ 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]
