Re: [dabo-users] Modifying field as part of verifyRecord or beforeSave?

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;

One less thing to hassle with in the app, especially if you different

apps pointing at the db.

> Thanks,

> Matt J.

Adrian Klaver

adrian.klaver@gmail.com

_______________________________________________

Post Messages to: Dabo-users@leafe.com