Robin Johnson a écrit :
Hi guys,
about this bug, I was just wondering, what would be consider the correct behavior?
Either: Checkbox(NULL) is on by default, and if data is placed into the textbox, then the checkbox is not applied in the PHP code.
OR
The checkbox is off by default, and must be checked to set the value to NULL.
I would say that, in insert mode: - checkbox is off, unless the default value for the field is NULL - if possible: if the focus goes to the field, we uncheck the checkbox - as you said, if there is data, the checkbox is not applied
But this leads to another behavior I want to validate with developers: Create a table with a field that has the attribute NULL, and put nothing for it's default value: the default value of the field will be NULL. Is this ok?
I would opt for the second solution, as I use a lot of data tables where I have designed the table with default values and actually take advantage of the default values in my manual SQL.
I see that lem9 mentioned a patch, but I haven't look it at it, so I don't know which method it implements.
The patch is supposed to disable a field if the null checkbox is on. But I wonder if we will need this, if the checkbox is off by default.
Marc