Re: [Firebird-net-provider] suspect - [SPAM] Re: suspect - [SPAM] Re: Error message "attempted update of read-only column"

[Mercea P. <pau...@al...>]

> 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