LiveCode Forums.

Posted: **Sun Mar 15, 2015 8:12 pm**

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

Posted: **Fri Mar 27, 2015 3:47 pm**

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

LiveCode Forums.

Field not null undetected

Field not null undetected

Re: Field not null undetected