Re: [sqlite] Not empty

2016-08-21 Thread Cecil Westerhof
2016-08-21 12:11 GMT+02:00 Richard Hipp : > On 8/21/16, Cecil Westerhof 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: > > subjectTEXT NOT NULL subject <> ''), > >

Re: [sqlite] Not empty

2016-08-21 Thread Richard Hipp
On 8/21/16, Cecil Westerhof 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: > subjectTEXT NOT NULL subject <> ''), subject TEXT NOT NULL CHECK(subject <> '') > > Is ther

[sqlite] Not empty

2016-08-21 Thread Cecil Westerhof
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: subjectTEXT NOT NULL subject <> ''), Is there a better way? -- Cecil Westerhof ___ sqlite-use