inserting is not using default values

jkuiper · Post by **jkuiper** » Wed 04 Feb 2009 16:32

I insert a new records and not filling the fields with a default value.
But when I refresh the table, the fields with a default value are still NULL.

Alexz · Post by **Alexz** » Fri 06 Feb 2009 13:00

We have found the problem and now we are investigating it.

jkuiper · Post by **jkuiper** » Tue 12 May 2009 08:29

Is this problem already solved

It still exists in 3.50.x

Alexz · Post by **Alexz** » Tue 12 May 2009 09:33

This happened because the application couldn't determine what you wanted to insert - NULL or default value.

To resolve this problem you should set NOT NULL for fields with default values. After this if you are not filling them, the default values will be inserted.

jkuiper · Post by **jkuiper** » Wed 13 May 2009 07:47

Your right Alexz. I changed the settings in my table and it works.

Thanks