--- In [email protected], Thomas Steinmaurer <ts@...> wrote:
>
> > I am wondering if there are any known issues with queries within a trigger,
> > when that query accesses the table on which the trigger fires (before
> > insert, so no race condition).
> > I am experiencing unpredictable and even wrong results in such a case, at
> > least when using FB 2.0 and 2.5. With 2.1 I have not experienced this, so
> > far.
> > Thanks for any help.
>
> Can you post an example on what you are trying to accomplish?
>
>
No problem! This is a simplified version of a trigger that fires Before Insert
on table ARTICLE:
declare LOCATION integer;
declare ARTICLEID varchar(20);
BEGIN
select first 1 NEWLOCATION, ARTICLEID from ARTICLE
where ARTICLE.CUSTID = NEW.CUSTID
and ARTICLE.ISACTIVE = 'F'
and ARTICLE.NEWLOCATION is not null
order by NEWLOCATION
into :LOCATION, :ARTICLEID;
NEW.NEWLOCATION = LOCATION;
end
This then (sometimes) assigns values of NEWLOCATION for Articles with ISACTIVE
= 'T'.
Thanks,
Hans
