Page 1 of 1
inserting is not using default values
Posted: Wed 04 Feb 2009 16:32
by jkuiper
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.
Posted: Fri 06 Feb 2009 13:00
by Alexz
We have found the problem and now we are investigating it.
Posted: Tue 12 May 2009 08:29
by jkuiper
Is this problem already solved
It still exists in 3.50.x
Posted: Tue 12 May 2009 09:33
by Alexz
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.
Posted: Wed 13 May 2009 07:47
by jkuiper
Your right Alexz. I changed the settings in my table and it works.
Thanks
