Martijn Tonies wrote:

> Todd,
>
> > 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.
>

That was my thinking as well. But I wondered if there was some magical
way to do this in the database so we would be protected either way. We
try to encourage clients not to update themselves directly (not through
the application) but we can't totally control them.

Todd

>
>

[Non-text portions of this message have been removed]