I am using sqlite3.exe to run the following very reduced script to successfully create a database. I was able to open and create and commit records using sqlBrowser.
I wasn't very clear above. I was trying to use Data Modeler to open the resulting sqlite3 db and generate the Aurelius table classes. Can anyone confirm this error?
I don't think such SQL is a valid SQLite syntax?
PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE IF NOT EXISTS "tblContent" ( "ID" INTEGER PRIMARY KEY AUTOINCREMENT, "subject" TEXT, "order" TEXT, "topic" TEXT, "notes" TEXT );COMMIT;
Changing the SQL statements as you directed did fix the problem. The other SQL syntax was created by SQLite Browser. I am noting that SQLite3.exe from the SQLite website does successfully execute the other version of the CREATE statement and adds it to the SQLite db schema. Maybe DataModeler should also allow this alternative syntax for SQLite3?
It seems that SQLite accepts such "non-official" syntax, but well, it's not official. Actually other tool we use for SQLite development also raises an error saying such SQL is invalid.
Thank you for your help. :)