04.04.2011 21:05, Adriano dos Santos Fernandes wrote:
> It's *CREATE OR* ALTER, and it's a DML trigger, so the table name is
> required.
But the error message sounds misleading. In fact, the *type* of the
trigger hasn't been changed.
Dmitry
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 trigge
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
varia