| Subject | Re: [IBO] Can new.columnvalue be used in an after insert trigger? |
|---|---|
| Author | Helen Borrie |
| Post date | 2006-11-23T09:15:01Z |
At 05:41 PM 23/11/2006, you wrote:
2.0. In 1.5 an attempt to write to it is a no-op, so you won't know
that it didn't happen; in Fb 2.0 it will actually cause an
exception, recycling sqlcode -151, isc_code 335544359, symbol
isc_read_only_field, message "Attempted update of read-only column".
Helen
>Or can it only work in a before insert?It is read-only in an after insert trigger, in both Fb 1.5 and Fb
2.0. In 1.5 an attempt to write to it is a no-op, so you won't know
that it didn't happen; in Fb 2.0 it will actually cause an
exception, recycling sqlcode -151, isc_code 335544359, symbol
isc_read_only_field, message "Attempted update of read-only column".
Helen