I am continuing experience this problem, doesn't anyone have an
suggestion?
--- In firebird-support@yahoogroups.com, "Nikolay Marinov"
<kok_bg@...> wrote:

>
> Hi group,
> very strange, the following trigger compiles fine in one database, but
> gives this error at another. The both databases has ODS 11.1, are on
> the same server and are free of errors (checked gfix -v -f).
> Server is FB 2.1 (WI-V6.3.1.17910)
>
> Actually the trigger is already created, altering raises the error.
>
> SET TERM ^ ;
>
> CREATE OR ALTER TRIGGER "LOG_tDBOnConnect"
> ACTIVE ON CONNECT POSITION 0
> as
> declare variable sessid integer;
> declare variable doLog char(1);
> declare variable rip varchar(40);
> begin
> if (user starting WITH 'REPL') then exit;
> select first 1 t."DoLog" from "tSettings" t into :dolog;
> if (doLog<>'Y') then exit;
> select rdb$get_context('USER_SESSION', 'SESSID') from rdb$database
> into :sessid;
> if ((sessid is not null ) and (sessid>0)) then exit;
> sessid=gen_id(gen_db_id,1);
> select rdb$set_context('USER_SESSION', 'SESSID',:sessid) from
> rdb$database into :rip;
> SELECT rdb$get_context('SYSTEM', 'CLIENT_ADDRESS') from
> rdb$database into :rip;
>
> insert into "tDB" ("Id",
> "User",
> "RemoteIP",
> "StampIn")
> values (:sessid,
> current_user,
> :rip,
> current_timestamp);
> SELECT rdb$set_context('USER_SESSION', 'RESDETIDSYSTEM','N') from
> rdb$database into :rip;
> end
> ^
>
> SET TERM ; ^
> ================
> Dynamic SQL Error.
> Invalid command.
> Incompatible trigger type.
>