At 01:21 AM 6/07/2012, you wrote: >Hi, >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.
If you have a row in a table that depends on values in other rows in the same table then you have a serious flaw in your relational design. Move that column or set into another table. ./heLen
