On 1-6-2018 11:44, Dmitry Yemanov dimitr@...
[firebird-support] wrote:

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

Out of curiosity: why? Why not just allow any updates to NULL, even if
the existing value already is NULL?

Mark
--
Mark Rotteveel