Field not null undetected

[AlessioForconi]

Hello everyone
in a table of a database sqlite there are three fields not null, including the id field.
How come when I enter data with one of the fields not null empty this anomaly is not detected and the row is added?

Thank You

[Mark]

Hi,

Empty isn't the same as NULL:

Code: Select all

put empty into myVar

is not the same as

Code: Select all

put NULL into myVar

Kind regards,

Mark