更新时间:2022-11-07 23:33:32
扩展ThePhantomUpvoter的评论 - 它回答了问题 - 但主要是从未答复的列表中删除它:
更改:x.executeSql(' CREATE TABLE IF NOT NOT EXISTS' + CASENAME ' +(id INTEGER PRIMARY KEY AUTOINCREMENT,DocumentName TEXT NOT NULL,DocumentDate INTEGER,DocumentNotes TEXT NOT NOT NULL)');
To:x.executeSql(' CREATE TABLE IF NOT NOT EXISTS' + CASEN AME + ' (id INTEGER PRIMARY KEY AUTOINCREMENT,DocumentName TEXT NOT NULL,DocumentDate INTEGER,DocumentNotes TEXT NOT NULL)');
Hi
i am getting error
tx.executeSql('CREATE TABLE IF NOT EXISTS '+CASENAME'+(id INTEGER PRIMARY KEY AUTOINCREMENT, DocumentName TEXT NOT NULL,DocumentDate INTEGER ,DocumentNotes TEXT NOT NULL)');
Error:
Unexpected string
To expand on ThePhantomUpvoter's comment - which answers the question - but mostly to remove this from the unanswered list:
Change:x.executeSql('CREATE TABLE IF NOT EXISTS '+CASENAME'+(id INTEGER PRIMARY KEY AUTOINCREMENT, DocumentName TEXT NOT NULL,DocumentDate INTEGER ,DocumentNotes TEXT NOT NULL)');
To:x.executeSql('CREATE TABLE IF NOT EXISTS '+CASENAME+'(id INTEGER PRIMARY KEY AUTOINCREMENT, DocumentName TEXT NOT NULL,DocumentDate INTEGER ,DocumentNotes TEXT NOT NULL)');