On Mon, Aug 17, 2015 at 5:19 PM, Olivier Barthelemy < barthelemy at geovariances.com> wrote:
> Create statement : > CREATE TABLE VariableDetails (dtl_id INTEGER PRIMARY KEY ASC AUTOINCREMENT, > storage_implicit BOOLEANCHECK (storage_implicit = 'true' OR > storage_implicit = 'false'), storage_type TEXT NOT NULL); > If "BOOLEANCHECK" is not a copy/paste error, that might be the problem. That might explain why this fails: Insert statement > INSERT INTO VariableDetails (storage_implicit, storage_type) VALUES (true, > INT_64); > ( Values are not passed dirrectly in the statement. The boolean in > particular is passed using sqlite3_bind_int() ) > > As far as i can see (debugging using debuggable version of Qt), it's at > sqlite calls that the insert failure is detected, and no error is > 'forgotten' by Qt at table creation. > What error code does the insertion return? Perhaps the table is not getting created due to the missing space? -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf