On 8/21/16, Cecil Westerhof <cldwester...@gmail.com> wrote:
> I have a field subject that I do not want to be empty. That means it should
> not be NULL and it should not contain ''. At the moment I do it like this:
> subject TEXT NOT NULL subject <> ''),
subject TEXT NOT NULL CHECK(subject <> '')
>
> Is there a better way?
>
> --
> Cecil Westerhof
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
