Re: [sqlite] Unable to create table, default value of column [ID] is not constant

I made some changes. You do not need "unique" and "primary key" on the same variable. You still need a rowid. I removed the unique constraint otherwise updating to duplicates does not work, and then you cannot see that it works.. CREATE TABLE Programmes ( ID TEXT, Title

Re: [sqlite] Unable to create table, default value of column [ID] is not constant

But you could use an INSERT  trigger instead. Also "does contains no sub-queries" ought to "doesn't contain any sub-queries", shouldn't it? Peter On Monday, June 20, 2016 5:55 PM, Peter Aronson wrote: According to https://www.sqlite.org/lang_createtable.html:

Re: [sqlite] Unable to create table, default value of column [ID] is not constant

According to https://www.sqlite.org/lang_createtable.html: "An explicit DEFAULT clause may specify that the default value is NULL, a string constant, a blob constant, a signed-number, or any constant expression enclosed in parentheses. A default value may also be one of the special

[sqlite] Unable to create table, default value of column [ID] is not constant

Alright, trying to set the scenario: * I open/create a database * I register a custom function called HASH (set to be deterministic), tested and working * I create a bunch of tables (if not exists) So far, everything works fine. Then, the troublesome create: CREATE TABLE IF NOT EXISTS