Subject Re: [firebird-support] Transaction Question
Author Martijn Tonies

> Our application is used for Property Assessment. We have one main
> table (the properties) and many child tables and grand child tables,
> etc. When the user uses the application they may add, change or
> delete many records in the child and grand child tables. When they
> are done doing their changes, I want to run a stored procedure to
> recalculate the properties assessment.
> Is it possible to do this using triggers? If not, how can I do this
> in the database and not through the application?
> I know how to do it using triggers, but the problem is that I don't
> want to recalculate everytime a child or grandchild record is altered.
> I only want to do it at the end of the changes.

From within the database, there's no way to "know" that a user finished
changing "lots of records".

You should do this from the client side.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!