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]
