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

Now the code doesn't work, because I don't have several fields in stage tables and these fields are char fields, they don't allow nulls... What should I do now? Explicitly list all the fields in my Insert command?