Subject RE: [firebird-support] Transaction Question
Author Alan McDonald
> 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.
> Thanks in advance,
> Todd

use a stored procedure and call it via a button on the client.