Subject Re: [firebird-support] attempted update of read-only column
Author Dmitry Yemanov
"Chris Meelhuysen" <chris@...> wrote:
> update invoiceheader
> set paymentduedate =cast((:ptCalcDate + (:ptDays *
> :ptBeforeOrAfter)) as date)
> where invoiceheaderid = new.invoiceid;
> it receives this message
> General SQL error.attempted update of read-only column.

Table "invoiceheader" has a before update trigger which assigns to the OLD
context or an after update trigger that assigns to the NEW context.