On Monday 24 December 2007 4:34 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().
Given the recent discussion I am doing bizobj.save() > > 4. You do a requery() and don't see "psqlData" matching the data you > updated with psql. Exactly. The problem being that though I am , in this case ,making the change with psql the change could in theory be coming from another instance of the Dabo app. > > 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? Will the form suffice or do you need the table and data also? -- 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]
