SET TERM ^ ;

CREATE TRIGGER TRIG_AGENDA_BI_0 FOR AGENDA
ACTIVE BEFORE INSERT POSITION 0
AS BEGIN
NEW.REGISTRO_ID = GEN_ID(GEN_AGENDA_REGISTRO_ID,1);
END
^

SET TERM ; ^




2005/12/7, Thomas Steinmaurer <ts@...>:

> > I was working on this and finally found the problem: I have one
> > trigger that feeds the PK field. I turn it INACTIVE and now I have the
> > behavior I want in application. I turn the trigger ACTIVE, just for
> > testing, and the pointer goes crazy again.
>
> How does the trigger source look like?`
>
>
> --
> Best Regards,
> Thomas Steinmaurer
> LogManager Series - Logging/Auditing Suites supporting
> InterBase, Firebird, Advantage Database, MS SQL Server and
> NexusDB V2
> Upscene Productions
> http://www.upscene.com
>
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

--
[]s
Andrei

W2K + D4 Pro + FB 1.5.2 + IBO 4.5B