TZSQLProcessor - Error creating trigger

In this forum we will discuss things relating the ZEOSLib 6.6.x stable versions

Moderators: gto, EgonHugeist

Post Reply
ilboss
Fresh Boarder
Fresh Boarder
Posts: 14
Joined: 13.09.2006, 08:51

TZSQLProcessor - Error creating trigger

Post by ilboss »

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
Post Reply