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? -- 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]
