>Hi Naomi,
>
>>Perhaps it's affected by SET NULL command. But I think adjusting the schema is the way to go.
>
>I alread have tried to test SET NULL ON/OFF, but it didn't change anything about this behavior.
>
>Thanks for answer!
Are you using insert or APPEND BLANK? AFAIK APPEND BLANK is not affected by SET NULL, only insert-SQL when not every field is specified.
Ok, I didn't read your original statement carefully. Yes, you're using APPEND BLANK, so you're right, it's not affected.
If it's not broken, fix it until it is.
My Blog