Andreas,

I use TDataset compatible components and many TDBDSQLs.

Using DB triggers is more complicated, becuase how would triggers know if a query is read only or not? Most queries do not directly contain a year value, so the triggers will need to run queries (sometimes not simple ones) to determine if a particular operation is related to a "closed year".

EZ.