On 02/16/2012 09:55 AM, Matt Jackson wrote: > Hello all: > Dabo is a great software package. I'm in the process of moving Microsoft > access applications over to Dabo and using MySql as a backend. It's > working really well. > What are the ways to support the continuing development of Dabo if any? > > My main question involves a table where I've added a DateMod and DateIns > columns. They are timestamps to track when a record was last modified and > when it was added. I've found these to be valuable in past systems. I've > put logic in the bizObj that handles this table to update the DateMod field > when a record is saved. > > I'm wondering where the best place is to put statements that update other > information in a record based upon actions the user has taken, before the > record is saved.
I generally put this in the database. I use Postgres so I use a combination of a default value and a UPDATE trigger. For MySQL there are some builtins for timestamp that do this; http://dev.mysql.com/doc/refman/5.0/en/timestamp.html One less thing to hassle with in the app, especially if you different apps pointing at the db. > > > > Thanks, > Matt J. > -- Adrian Klaver [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]
