|Subject||Re: how to delayed update in trigger|
> Many ways to do this 2 are:That is in the perfect world ;) in the true world most of the time need to "denormalize" the data for speed optimization
> 1. I never put the invoice total in. I always retotal the items.
> 2. You are in control of the COMMIT command. Why don't you call an SP toBecause the database is use by more than one software, and hard to control all the software that they do correctly the job (this why we invent trigger :)
> total just before the commit. (instead of triggers)