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


Dmitry