Dmitry, > > > I always thought that this error was about table/view references, > > > not about old/new context variables. > > > What is the source of the error? > > > > OLD/NEW occupy two contexts, the rest is from somewhere else. Do you > > have computed fields with embedded selects that are being accessed via > > the OLD/NEW references? > > I don't think we have computed field references. I will check.
Would INSERTs (as below) to a table count as a context? if(old.ASS_ISARCHIVED is distinct from new.ASS_ISARCHIVED) then insert into SYS_CD(CDD_TRANSACTION_ID,CDD_TIMESTAMP,CDD_TABLE_ID,CDD_FIELD_ID,CDD_ACTION,CDD_USER,CDD_PK,O_INTEGER,N_INTEGER) values(:t_id,'NOW',10067,100734,:act,:usr,:pk,old.ASS_ISARCHIVED,new.ASS_ISARCHIVED); if(old.ASS_ISACQUIRED is distinct from new.ASS_ISACQUIRED) then insert into SYS_CD(CDD_TRANSACTION_ID,CDD_TIMESTAMP,CDD_TABLE_ID,CDD_FIELD_ID,CDD_ACTION,CDD_USER,CDD_PK,O_INTEGER,N_INTEGER) values(:t_id,'NOW',10067,100735,:act,:usr,:pk,old.ASS_ISACQUIRED,new.ASS_ISACQUIRED); Sean ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
