🚀 go-pugleaf

Marian,

> I have a trigger after update wich fire a stored procedure execution.
> If I make the update from IBConsole the trigger fire.
> From an IBX IBSQL component ... nothing.
> Transactions are read commited and separate for each IBX and table trigger.
> Is there a catch ?
> 
> IBSQL sql:
> update BON_CASA
> set
> NRBON=:nrbon
> where CODDOC=:coddoc
> 
> 
> CREATE TRIGGER "UPDATE_RAPORTX" FOR "BON_CASA"
> ACTIVE AFTER UPDATE POSITION 1
> AS
> DECLARE VARIABLE INCASARE_LIBERA_V BOOLEAN;
>  BEGIN
>              INCASARE_LIBERA_V=FALSE;
>             IF (NEW.NRBON<>OLD.NRBON)
>              THEN EXECUTE PROCEDURE INSERT_BON_RAPX(BON_CASA.CODDOC, 
> :INCASARE_LIBERA_V, BON_CASA.CODGEST);
>  END

* Do you commit the transaction?
* Any chance that either NEW.NRBON or OLD.NRBON is NULL? In this case, 
you won't get to the EXECUTE PROCEDURE statement



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