Quote:
Originally Posted by chaley
The default value for a column is None/null/not-set. A Yes/No column is no different than any other column.
|
Why am I so confused? If the default value is null on a Y/N column, isn't it tri-valued? Are you just thinking of whether it can be set to null after it was previously set to Y or N, or do you mean that null=N or are you just thinking of display issues?
Quote:
|
for int columns, columns set to a value will sort before columns never set (blank), and I expect that people will think that this behavior is correct. The same is true for the various text fields.
|
Exactly. I'm more confused. Shouldn't the Y/N column behave this way, too? In which case it would be tri-valued wouldn't it?
Quote:
|
As I said, the default value for every column is None.
|
Which makes it tri-valued if it can also be Yes or No......
Quote:
|
Defaulting to two-value where None and No are considered the same solves that problem. Internally maintaining three values (remembering values that were explicitly set to false) helps protect work of users who later decide to set the tweak to change to visible tri-valued fields.
|
Aha - You're just not going to let the average user search for "false" and find anything? Or are you still going to allow that, but have a search for No pull up the internally saved null as well as No?