Re: [sqlite] NOTNULL

2020-01-09 Thread Luuk
On 8-1-2020 12:15, R Smith wrote: I find the keyword NOTNULL listed among known SQLite keywords - no. 88 on this page: https://sqlite.org/lang_keywords.html But cannot find a single mention of it or place to use it in SQLite, nor get any hit on the sqlite.org search except in reference to the

Re: [sqlite] NOTNULL

2020-01-08 Thread Richard Hipp
On 1/8/20, R Smith wrote: > I find the keyword NOTNULL listed among known SQLite keywords - > no. 88 on this page: https://sqlite.org/lang_keywords.html > > But cannot find a single mention of it or place to use it in SQLite, nor > get any hit on the sqlite.org search except in reference to the

Re: [sqlite] NOTNULL

2020-01-08 Thread R Smith
On 2020/01/08 2:03 PM, Keith Medcalf wrote: 1. What is it for? It is a common misspelling of "IS NOT NULL" and means the same thing. "ISNULL" is also a reserved word as it is a common misspelling of "IS NULL" and means the same thing. You will note that ISNOTNULL is not a reserved word

Re: [sqlite] NOTNULL

2020-01-08 Thread Keith Medcalf
On Wednesday, 8 January, 2020 04:16, R Smith wrote: >I find the keyword NOTNULL listed among known SQLite keywords - >no. 88 on this page: https://sqlite.org/lang_keywords.html >But cannot find a single mention of it or place to use it in SQLite, nor >get any hit on the sqlite.org search

Re: [sqlite] NOTNULL

2020-01-08 Thread R Smith
On 2020/01/08 1:23 PM, Simon Slavin wrote: You can use NOTNULL as a condition. It's the opposite of ISNULL. You see it usually as a constraint, to ensure that a field has a value. Thank you Simon - Do you perhaps have an example of this working in SQLite? I am not finding a way to make

Re: [sqlite] NOTNULL

2020-01-08 Thread Simon Slavin
On 8 Jan 2020, at 11:15am, R Smith wrote: > I find the keyword NOTNULL listed among known SQLite keywords - > no. 88 on this page: https://sqlite.org/lang_keywords.html > > But cannot find a single mention of it or place to use it in SQLite, nor get > any hit on the sqlite.org search except in

[sqlite] NOTNULL

2020-01-08 Thread R Smith
I find the keyword NOTNULL listed among known SQLite keywords - no. 88 on this page: https://sqlite.org/lang_keywords.html But cannot find a single mention of it or place to use it in SQLite, nor get any hit on the sqlite.org search except in reference to the above list. 1. What is it for?