On 4/14/16, Cecil Westerhof <cldwesterhof at gmail.com> wrote: > > ?Yes that makes sense. But could not a type of PRAGMA be used? So if the > PRAGMA is not defined the old functionality and your historical data is > save. And if the PRAGMA is defined the new functionality. >
Easier: Just declare the columns in question as NOT NULL. Or use a WITHOUT ROWID table which *does* enforce NOT NULL. -- D. Richard Hipp drh at sqlite.org