I am getting the new record saved OK - ie the record count increases by one after each transaction is entered. I have an auto-increment primary key in all tables. I'll explore the dabo settings in the bizobj. Thanks Roger
-------------------------------------------------- From: "johnf" <[email protected]> Sent: Wednesday, May 27, 2009 12:34 AM To: "Dabo Users list" <[email protected]> Subject: Re: [dabo-users] SQLite Problem > On Monday 25 May 2009 06:28:14 pm Roger Lovelock wrote: >> Not sure if this is a problem with dabo, or my code - wondering if anyone >> else has a similar problem :- I have a transaction table with a date >> field >> - default value is today. Whenever I enter a new transaction the date on >> the first record in the table is updated to today, even though I have not >> edited that record. My form only allows new transactions to be entered - >> the after init routine ending with self.new(). >> >> Any suggestions where I may be going wrong? >> >> Thanks >> >> Roger > > This is a total guess because (at least for me) you have not provided > enough > information to do anything else. > > Are you in fact getting a new record in the table. IOW if you start out > with > 10 records - did you get 11 records after the save? If not you are most > likely updating the same record over and over again. > > I have not worked with SQLite very often but does it need a commit, should > you > supply a primary key (auto-increment available?), Turn off/on some Dabo > setting in the bizobj? Like setting NonUpdateFields. > > > > -- > 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/[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/[email protected]
