SQLite Forum

how to refuse write empty value
Login
`CONSTRAINT "CHECK(invoice != '';)" NOT NULL` is **not** a CHECK constraint. It's a NOT NULL constraint whose name is "CHECK(invoice != '';)".

You want

    invoice VARCHAR CHECK(invoice != '')
    -- or, if you want a named constraint
    invoice VARCHAR CONSTRAINT 'SomeName' CHECK(invoice != '')