Subject RE: [firebird-support] "Attempted update of read-only column"
Author Alan McDonald
> Dne 24.2.2010 16:41, Marcin Bury napsal(a):
> > You get this error when you have some After Insert or After Update
> > trigger where you are trying to modify NEW.???? value.
> >
> I don't know WHERE I am getting the error. That's precisely what I need
> - some means of finding which particular trigger or SP causes the
> error,
> preferably along with e.g. statement number.
> > Try to recompile manually all such triggers and then you find one.
> >
> Considering the number of triggers and their dependencies, that is not
> a
> trivial task at all. It seems I will gave to do it if I ever want to
> upgrade to FB2.1, but I don't look forward to this process :-(
>
> Pepak
>

If you don’t have an admin tool that provides meta data searching, extract the trigger metadata and search on 'OLD.*=' in a good editor which allows wildcard searches.
Alan