>>>>Naomi,
>>>>
>>>>this function had my nose crinkled already when I read it - you already have a [S]WAG in the mail..<g>.
>>>>
>>>>regards
>>>>
>>>>thomas
>>>
>>>The tables are opened in advance, so we don't lose time opening and closing them. I changed the code and found that somehow I have empty values in cStatus_Codes_fk, but cResolution_Codes_fk are NULL (we should have NULL in both). I don't understand why it's happenning, because I use scatter memvar/insert from memvar and stage table has neither of these two fields.
>>
>>Check "set null"
>>Cetin
>
>Yep, I just added it. But the question is: why one code worked and another didn't with SET NULL OFF (presumably that's default)? That's a mystery.

Well, it turned out there was no mystery <g> The other two codes were explicitly set to NULL in the code <g> So I just added one more code.