Ketai Library and SQLite

Contributed Library Questions

knuppel

in Contributed Library Questions • 3 months ago

Hello,

i wrote a little sketch:

before setup:

import ketai.data.;

KetaiSQLite db;

KetaiSQLite db;
String CREATE_DB_SQL = “CREATE TABLE data ( _id INTEGER PRIMARY KEY AUTOINCREMENT, punkte INTEGER NOT NULL DEFAULT ‘0’, level INTEGER NOT NULL DEFAULT ‘0’);”;

in setup:

db = new KetaiSQLite( this); db.connect();

if (!db.tableExists("data")){ db.execute(CREATE_DB_SQL);} db.query( "SELECT * FROM data" ); while (db.next()) { level=db.getInt("punkte"); punkte=db.getInt("level"); }

somewehere in the sketch:

if (!db.execute(“INSERT into data (`punkte`,`level`) VALUES (punkte, level )”)) println(“error w/sql insert”);

I get this error message:

Error executing sql statement: no such column: punkte (code 1): , while compiling: INSERT into data (`punkte`,`level`) VALUES(punkte, level )
error w/sql insert

I have some experience with MySQL and PHP, but i don't know what i'm doing wrong.

Replies(2)

PhiLho

Library & Tools Development section is to discuss about making libraries and tools, not about problems using them. So I moved the topic.

Your formatting is odd too, but I will blame Zoho, as its editor is far from perfect...

I don't know well the Ketai library, but from the name, it seems it is about the SQLite database. (EDIT: OK, it is in your title... Don't hesitate to repeat the information given in your title in the body of the message...

)

But I see you use backquotes in your SQL statement. AFAIK, this syntax is specific to MySQL and not standard SQL, so I am not sure if they are understood / handled by SQLite.
Beside, these backquotes are not necessary, as there are no special characters in the names of your columns (a bad idea in general, anyway).

knuppel

Re: Ketai Library and SQLite

3 months ago

Well, i figured it out.

But until my smartphone isn't rooted i can not look into the database.

Top Reply