Error in SQLite tables

nithin.warier · by **nithin.warier** » Fri Feb 29, 2008 3:53 pm

Syntax: [ Download ] [ Hide ]

Using sql Syntax Highlighting

myDatabase.execSQL("CREATE TABLE IF NOT EXISTS Testing"
 
           +" (age INT(2), sex VARCHAR, height INT(3);");
 
AND inserting TO TABLE USING
 
myDatabase.execSQL("INSERT INTO Testing (age,sex,height) VALUES ("+getAge+",'"+getSex+"',"+getHeight+");");
Parsed in 0.002 seconds,  using GeSHi 1.0.8.4

but it is showing run time error.. the error is Application error, table Testing has no cloumn named age

Waiting for your valuable comments

Thanks
Nithin

cadlg · by **cadlg** » Fri Feb 29, 2008 4:20 pm

Hello nithin.warier,

My first thought was:

Maybe the table already exists, but with another structure from your first tests, and since you are using CREATE IF NOT EXISTS, the table is never created with the structure you want now...

You could try removing the "IF NOT EXIST" and run the application once, to see what happens, or run the emulator with -wipe-data (that I assume will clean all user data, so be careful).

It's just an idea.

Regards,

cadlg

nithin.warier · by **nithin.warier** » Fri Feb 29, 2008 4:23 pm

thanks

Error in SQLite tables

Error in SQLite tables

First thought

Who is online