且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

运行querry时出现意外的字符串错误

更新时间: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)');