Hi guys.

Reading here gives me some chance that it can be possible:

http://www.firebirdsql.org/refdocs/langrefupd21-ddl-trigger.html#langrefupd21-alter-trigger-changecount

What I want to do:

I have two tables: MY_TABLE, MY_TABLE_HISTORY. In MY_TABLE_HISTORY I want to keep only one row, in this row I want to have an information such as:

- last timestamp of changes
- last change number(counter)
- last row id which had been changed.

I would like to update this row basing on the trigger created for MY_TABLE.

However, there is one trick: if I update / delete/ insert many rows in one transaction I would like to update data in MY_TABLE_HISTORY only once.

So for example: If I update 100 records in MY_TABLE in one transaction I am incrementing only once the last change number, but if I am updating 100 rows in 100 different transactions I am incrementing the last change number by 100.


Is something like that possible? If not, do you have other ideas how to solve this problem?