Android insert into sqlite database

Posted by Josh on Stack Overflow See other posts from Stack Overflow or by Josh
Published on 2010-04-11T05:24:18Z Indexed on 2010/04/11 5:33 UTC
Read the original article Hit count: 278

Filed under:
|
|

I know there is probably a simple thing I'm missing, but I've been beating my head against the wall for the past hour or two. I have a database for the Android application I'm currently working on (Android v1.6) and I just want to insert a single record into a database table. My code looks like the following:

//Save information to my table
sql =   "INSERT INTO table1 (field1, field2, field3) " +
        "VALUES (" + field_one + ", " + field_two + ")";
Log.v("Test Saving", sql);
myDataBase.rawQuery(sql, null);

the myDataBase variable is a SQLiteDatabase object that can select data fine from another table in the schema. The saving appears to work fine (no errors in LogCat) but when I copy the database from the device and open it in sqlite browser the new record isn't there. I also tried manually running the query in sqlite browser and that works fine. The table schema for table1 is _id, field1, field2, field3.

Any help would be greatly appreciated. Thanks!

© Stack Overflow or respective owner

Related posts about android

Related posts about android-sdk