hello helen,

i did check that awhile back and none of those are the case. it is
all strict. before insert or update apply NEWs with no reference to
OLDs, after insert or update update other tables, which is where the
accrual field update is, before or after delete only uses OLDs, and
the after delete also updates the accrual field. restated just to
double check my thinking on that point.

hey, thanx for the quick response.

lucas

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 10:51 PM 1/08/2007, you wrote:
> >hello one and all,
> >
> >i am having some weird intermittent problem with the triggers under
> >1.5.4.4910. basically, a detail table updates an accrual field in the
> >master table. essentially, the accrual fields are not being updated
> >properly by the triggers of the detail table. i rewrote the triggers
> >to ensure that nulls were not entering into the problem. the code for
> >these triggers have existed for years and i have never had the problem
> >until i upgraded to 4910. my biggest problem is that i am having such
> >a hard time reproducing the bug because it is intermittent and at this
> >point i can't seem to see why it is doing it. the only way that i
> >know it exists is that the accrual field doesn't add to the sum of the
> >detail, but again this is in the minority.
> >
> >i do remember a couple years back when a 1.5 release didn't run the
> >triggers at all. this bug was fixed very fast back then. however,
> >this one is very intermittent and has me stumped. any ideas?
>
> Check that you don't have any AFTER triggers that are trying to
> change the NEW values; nor any DELETE triggers trying to refer to
> NEW values; nor any INSERT triggers that are trying to refer to OLD
values.
>
> ./heLen
>
>
>
> >lucas
> >
> >
> >
> >++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> >Visit http://www.firebirdsql.org and click the Resources item
> >on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> >Also search the knowledgebases at http://www.ibphoenix.com
> >
> >++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> >Yahoo! Groups Links
> >
> >
> >
>