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