Null always entered by default

[Cosmicowboy]

When entering new values to a database NULL seems to be entered always, regardless of what the default is set as. I have a small SQLite db that has a column with a default of CURRENT_DATE. This default works to collect the current date at time of submission; however, this value can be overwritten with NULL. SQLiteStudio seems to always enter NULL if value is not entered into field when submitting new values using Grid View.

[pawelsalawa]

[Cosmicowboy]

Hello and thank you for the speedy reply. I might be misunderstanding the tool tip explaination. I was under the impression that by having that option disabled and NOT NULL condition on the column would force a DEFAULT value to be entered?