On Monday 24 December 2007 05:11:21 pm Adrian Klaver wrote: > 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?
I'd like the form and if the table is simple I can figure it out. Of couse it's easy to grab the SQL from pgAdmin. -- 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]
