Subject Re: [firebird-support] how to delayed update in trigger
Author svanderclock
thanks mark,

yes you are right, but i choose invoice and items as a sample. my need a much more complicated to explain... but the main idea is the same

thanks again
stéphane

--- In firebird-support@yahoogroups.com, "Mark Rotteveel" <Avalanche1979@...> wrote:
>
> > Many ways to do this 2 are:
> > 1. I never put the invoice total in. I always retotal the items.
>
> I don't think that is a viable option. I think the total needs to be as the transaction was at the time of sale, not as it would if the sale was at the current time (with different prices).
>
> Mark
>
>
> --
> GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
> Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01
>