At 09:07 PM 2/04/2008, you wrote:
>> 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!
Of course you do! Consider the logic of updating a record that is being
deleted! All of these absurdities used to be ignored. From v.2 onward, they
are now surfaced as exceptions. Consider it as free education! ;-)
Helen
-------------------------------------------------------------------------
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
