> Then your Before Delete trigger probably has a reference to
> NEW.something. It is invalid in a delete trigger.
Trigger ddl is:
CREATE OR ALTER TRIGGER RPL_doc_invoice_BDEL FOR doc_invoice
ACTIVE BEFORE DELETE POSITION 1000
as
declare variable v_repl char(1);
begin
v_repl='N';
select o.repl from sys_repl o where o.name='doc_invoiceĊ£ into :v_repl;
if (v_repl is null) then
v_repl='N';
/* if (v_repl='I') then old.doc_repl='I'; */
execute procedure insert_log('doc_invoice',old.doc_repl,'D');
end
If I uncomment the "if (repl='I') then old.doc_repl=0;" I get the error!
Best Regards,
Paul
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
