Announcement

Collapse
No announcement yet.

SQLite STRICT Tables

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQLite STRICT Tables

    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
    Code:
    #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
    Last edited by Mike Doty; 20 Jul 2022, 08:36 PM.

  • #2
    Originally posted by Mike Doty View Post
    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

    Comment

    Working...
    X