>>>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.
If it's not broken, fix it until it is.
My Blog