Subject Re: Firebird 3: Not able to UPDATE RDB$Procedures
Author Dmitry Yemanov
01.06.2018 10:30, Chuck Belanger wrote:
>
> 2. The difference turned out to be that for one there was actually some
> source code in the fields. While the other that threw an error message,
> already had NULL fields in all records.
>
> 3. When limiting the UPDATE to a specific record rather than the entire
> table and even then setting RDB$Procedure_Source = NULL only when there
> is some source code to null, then it works fine.

Only changes from non-NULL to NULL are allowed while updating. You need
to filter out records already without sources.


Dmitry