>>>>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?
Set null off
PS: Nulls are evils. Don't use them if unless you really know what you're doing. Generally they are over used when one really doesn't need them.
Cetin