>>I get sometimes the error "MyField cannot accept null values" if I INSERT INTO and do not specify all field names in a table. The not specified field names should be blank and not null, and I could not find out what setting causes this to happen.
>>
>>Any ideas?
>
>Check SET NULL command in Help. This question was recently discussed and I think your best bet would be to list all fields in your INSERT command.
Thanks, I thought I knew the command very well and therefore I never checked the help.
I believed that SET NULL only specifies the NULL setting of fields during Create Table or Create Cursor, and I never realized that Set Null also has impact on Insert SQL!
Christian Isberner
Software Consultant