title: Android SQLiteDatabase inserting error
body: <p>some problems with my simple accountbook code.</p>
  
  <p>I want to insert a row when I click the save button.</p>
  
  <p>I checked my table created successfully.</p>
  
  <pre><code>save.setOnClickListener(new Button.OnClickListener(){
  
          @Override
          public void onClick(View v) {
              // TODO Auto-generated method stub
  
              mDbOpenHelper.open();
  
              try{
              mDbOpenHelper.insertColumn(
                      rButton, 
                      mEditTexts[1].getText().toString().trim(), 
                      spinnerSelected, 
                      mEditTexts[0].getText().toString().trim());
              }catch(Exception e){
                  Log.d("TAG","error");
              }
  
              mDbOpenHelper.close();
              mCursor.close();
  
          }
  
      });
  </code></pre>
  
  <p>insertColumn( )</p>
  
  <pre><code>// Insert DB
          public long insertColumn(String cashORcard, String amount, String category, String detail){
              mDB = mDBHelper.getWritableDatabase();
              ContentValues values = new ContentValues();
              values.put(Database.CreateDB.CASH, cashORcard);
              values.put(Database.CreateDB.AMOUNT, amount);
              values.put(Database.CreateDB.CATEGORY, category);
              values.put(Database.CreateDB.DETAIL, detail);
  
              return mDB.insert(Database.CreateDB.TABLENAME, null, values);
  
          }
  </code></pre>
  
  <p>define of my database table</p>
  
  <pre><code>public class Database {
  
  public static final class CreateDB implements BaseColumns{
      public static String firstCash="0";
      public static String firstAccount="0";
      public static String allMoney="0";
      public static final String CASH="cash";
      public static final String CATEGORY="category";
      public static final String DETAIL="detail";
      public static final String AMOUNT="0";
      public static final String ID="0";
      public static final String TABLENAME="Accountbook";
      public static final String CREATE=
              "CREATE TABLE "+TABLENAME
              +" ( _id integer primary key autoincrement, "
              +" CASH text not null , "
              +" AMOUNT text not null , "
              +" CATEGORY text not null , "
              +" DETAIL text , "
              +" firstCash text not null , "
              +" firstAccount text not null , "
              +" allMoney text not null );";  
      }
  }
  </code></pre>
  
  <p>log </p>
  
  <pre><code>04-17 02:53:11.471: E/SQLiteLog(877): (1) near "0": syntax error
  04-17 02:53:11.501: E/SQLiteDatabase(877): Error inserting cash=cash detail=asdf category=salary 0=567
  04-17 02:53:11.501: E/SQLiteDatabase(877): android.database.sqlite.SQLiteException: near "0": syntax error (code 1): , while compiling: INSERT INTO Accountbook(cash,detail,category,0) VALUES (?,?,?,?)
  04-17 02:53:11.501: E/SQLiteDatabase(877):  at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
  04-17 02:53:11.501: E/SQLiteDatabase(877):  at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:882)
  04-17 02:53:11.501: E/SQLiteDatabase(877):  at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:493)
  04-17 02:53:11.501: E/SQLiteDatabase(877):  at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
  04-17 02:53:11.501: E/SQLiteDatabase(877):  at android.database.sqlite.SQLiteProgram.&lt;init&gt;(SQLiteProgram.java:58)
  04-17 02:53:11.501: E/SQLiteDatabase(877):  at android.database.sqlite.SQLiteStatement.&lt;init&gt;(SQLiteStatement.java:31)
  04-17 02:53:11.501: E/SQLiteDatabase(877):  at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1467)
  04-17 02:53:11.501: E/SQLiteDatabase(877):  at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339)
  04-17 02:53:11.501: E/SQLiteDatabase(877):  at com.android.accountbook_edit.DbOpenHelper.insertColumn(DbOpenHelper.java:82)
  04-17 02:53:11.501: E/SQLiteDatabase(877):  at com.android.accountbook_edit.Income$3.onClick(Income.java:99)
  04-17 02:53:11.501: E/SQLiteDatabase(877):  at android.view.View.performClick(View.java:4204)
  04-17 02:53:11.501: E/SQLiteDatabase(877):  at android.view.View$PerformClick.run(View.java:17355)
  04-17 02:53:11.501: E/SQLiteDatabase(877):  at android.os.Handler.handleCallback(Handler.java:725)
  04-17 02:53:11.501: E/SQLiteDatabase(877):  at android.os.Handler.dispatchMessage(Handler.java:92)
  04-17 02:53:11.501: E/SQLiteDatabase(877):  at android.os.Looper.loop(Looper.java:137)
  04-17 02:53:11.501: E/SQLiteDatabase(877):  at android.app.ActivityThread.main(ActivityThread.java:5041)
  04-17 02:53:11.501: E/SQLiteDatabase(877):  at java.lang.reflect.Method.invokeNative(Native Method)
  04-17 02:53:11.501: E/SQLiteDatabase(877):  at java.lang.reflect.Method.invoke(Method.java:511)
  04-17 02:53:11.501: E/SQLiteDatabase(877):  at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793)
  04-17 02:53:11.501: E/SQLiteDatabase(877):  at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
  04-17 02:53:11.501: E/SQLiteDatabase(877):  at dalvik.system.NativeStart.main(Native Method)
  </code></pre>
  
  <p>need more code, plz let me know!
  Thanks !</p>