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?
Kovalenko Dmitry
www.ibprovider.com
------------------------------------------------------------------------------
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