TZSQLProcessor - Error creating trigger
Posted: 19.12.2011, 18:55
Hi to all,
with the TZSQLProcessor I try to create a trigger in a FB 2.1 Database (I'm using Delphi 2007)
SET TERM ^ ;
CREATE TRIGGER TEST_BI0 FORTEST
ACTIVE BEFORE INSERT POSITION 0
AS
begin
if (new.id is null) then
new.id = genera_guid();
end^
SET TERM ; ^
il gives me this error:
SQL Error:_ Dynamic SQL Error SQL error code = -104 Token unknown - line 1, column 5 TERM. Error Code:_-104. Invalid token The SQL:_SET TERM ^
Where I wrong?
thank's
Boss
with the TZSQLProcessor I try to create a trigger in a FB 2.1 Database (I'm using Delphi 2007)
SET TERM ^ ;
CREATE TRIGGER TEST_BI0 FORTEST
ACTIVE BEFORE INSERT POSITION 0
AS
begin
if (new.id is null) then
new.id = genera_guid();
end^
SET TERM ; ^
il gives me this error:
SQL Error:_ Dynamic SQL Error SQL error code = -104 Token unknown - line 1, column 5 TERM. Error Code:_-104. Invalid token The SQL:_SET TERM ^
Where I wrong?
thank's
Boss