When you are creating a new field and you want the default to be NULL, the query is getting passed through as
... default 'NULL' ...
but since the quotes are around NULL, it is interpreted as the string NULL so the default becomes 0...maybe we could add a little checkbox for null, so it would be like
Default ------- -- | | or | |null ------- --
what do you think?
Dan Allen
Dan,
this is Feature request #442855 : null field values: checkbox
Marc
Dan Allen a écrit :
When you are creating a new field and you want the default to be NULL, the query is getting passed through as
... default 'NULL' ...
but since the quotes are around NULL, it is interpreted as the string NULL so the default becomes 0...maybe we could add a little checkbox for null, so it would be like
Default
| | or | |null
what do you think?
Dan Allen
-
Dan Allen -
Marc Delisle