title: Android insert into sqlite database
body: <p>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:</p>
  
  <pre><code>//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);
  </code></pre>
  
  <p>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.</p>
  
  <p>Any help would be greatly appreciated.  Thanks!</p>