SQLite STRICT Tables

[Mike Doty]

Stricter typing made optional.
It also catches incorrect or no datatypes specified on columns in the create statement which would then use blob.

https://www.sqlite.org/stricttables.html

#INCLUDE "sqlitening.inc"

FUNCTION PBMAIN AS LONG
 slOpen ":memory:" 'changed so no write to disk
 slexe "create table t(i integer) strict"
 slexe "insert into t values('me')" 'error: cannot store TEXT value in INTEGER column t.i
END FUNCTION

[Stuart McLachlan]

Stricter typing made optional.
It also catches incorrect or no datatypes specified on columns in the create statement which would then use blob.

"Great" he says and Immediately finds link and downloads latest version!

(Now all I want is for SQLiteStudio to release an update that supports it. Currently supports 3.35.4, needs to support at least 3.37