On 04-04-2011 13:37, Kovalenko Dmitry wrote: > Hi > > SQL Script > > set transaction; > create table TEST_36187 (ID INTEGER); > create trigger BI_TEST_36187 for TEST_36187 before insert as declare > variable x integer; begin select count(*) from TEST_36187 into :x; end; > CREATE OR ALTER trigger BI_TEST_36187 active after insert position 1 as > declare variable x integer; begin select count(*) from TEST_36187 into > :x; end; > Firebird 2.5 executes these SQL without problem > > Firebird 3.0 returns the error for last statement: Incompatible trigger type > > It is right? > IMO, yes.
It's *CREATE OR* ALTER, and it's a DML trigger, so the table name is required. Adriano ------------------------------------------------------------------------------ Create and publish websites with WebMatrix Use the most popular FREE web apps or write code yourself; WebMatrix provides all the features you need to develop and publish your website. http://p.sf.net/sfu/ms-webmatrix-sf Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
