Sqlite Statement with variable Syntax

Question

I need to run dynamically INSERT and CREATE Sqlite statements.

"CREATE TABLE IF NOT EXISTS Menu"+counter+" (itemid INTEGER PRIMARY KEY, test TEXT, type TEXT, table TEXT)";

"INSERT OR IGNORE INTO Menu"+counter+" (itemid , test, type, table) VALUES (?, ?, ?, ?)";

I got on both statements a syntax error if i try to run.

http://docs.phonegap.com/en/1.2.0/phonegap_storage_storage.md.html#SQLError SQLError.SYNTAX_ERR

Joachim Isaksson · Accepted Answer · 2013-07-29 13:31:58Z

2

table is a reserved keyword, and needs to be quoted in both statements if used as a field name.

I suggest you find another name, but to keep it, surround it with ";

'CREATE TABLE IF NOT EXISTS Menu'+counter+
  ' (itemid INTEGER PRIMARY KEY, test TEXT, type TEXT, "table" TEXT)'

answered Jul 29, 2013 at 13:31

Joachim Isaksson

182k28 gold badges298 silver badges308 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sqlite Statement with variable Syntax

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related