> I implemented this solution but I'm contemplating about the following:
>
> 1) What situations cause the Default setting in FB to be ignored, as
> I've experienced? Is IBO the one in play here?

The DEFAULT clause is only used if you fail to include the columns
in the INSERT clause.

> 2) I have some more numeric(15,2) fields in the db. Adding two
> separate triggers for each affected tables add to the overhead when
> inserting/modifying records. Or am I overstating?

You could have a single trigger (for insert and update) that does this
for all fields.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com