Thats why I am wondering if the problem is with SQLite storing data as essentially text - ie the requery() is needed to establish the datatype in the bizObj - I strongly suspect a 2nd issue as well - that the first record is loaded in the dataset (but not displayed), and has its date field then overwritten by the default (again a bizObj issue) - this seems to be stored as a database change and then updated when I eventually get to a save() operation along with the one I explicitly enter.
Roger -------------------------------------------------- From: "Ed Leafe" <e...@leafe.com> Sent: Tuesday, June 09, 2009 11:44 AM To: "Dabo Users list" <dabo-users@leafe.com> Subject: Re: [dabo-users] Problem with SQLite > On Jun 8, 2009, at 9:31 PM, Roger Lovelock wrote: > >> self.requery() >> self.cancel() >> self.new() > > OK, this is where things don't make sense. When you call requery(), > you should have a pristine, unmodified data set. The only thing that > cancel does is return a modified data set back to the way it was after > the last requery() happened. > > > -- Ed Leafe > > > > _______________________________________________ > Post Messages to: Dabo-users@leafe.com > 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/dafd0550-02e7-4e19-b64d-bdc81d361...@leafe.com > _______________________________________________ Post Messages to: Dabo-users@leafe.com 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/col102-ds2340267d8d25c468b4a093b9...@phx.gbl