android - 没有这样的列名错误

Question

我定义了列名。但我遇到了这个错误。我检查了每一件事。我找不到这个错误的原因。

 try {
         myDB = this.openOrCreateDatabase("DatabaseName", MODE_PRIVATE, null);

         /* Create a Table in the Database. */
         myDB.execSQL("CREATE TABLE IF NOT EXISTS "
           + TableName
           + " (" +
           "name TEXT, " +
           "number TEXT" +
               ");"
           );

         /* Insert data to a Table*/
         myDB.execSQL("INSERT INTO "
           + TableName
           + "(name,number)"
           + " VALUES (name,number)");

        // retrieve data from database
         Cursor c = myDB.rawQuery("SELECT * FROM " + TableName , null);


         // Check if our result was valid.
         c.moveToFirst();


             while(c.moveToNext())
                {
                 Log.i("error",c.getString(0));
                 Log.i("error",c.getString(1) ); 
             contactname.add(c.getString(c.getColumnIndex("name")));
             contactnumber.add(c.getString(c.getColumnIndex("number")));

              }

Answer 1

问题是

/* Insert data to a Table*/
 myDB.execSQL("INSERT INTO "
   + TableName
   + "(name,number)"
   + " VALUES (name,number)");

尝试插入名称、数字，它们都被标识为列名，因为它们不是字符串。你应该像这样插入它:

/* Insert data to a Table*/
 myDB.execSQL("INSERT INTO "
   + TableName
   + "(name, number)"
   + " VALUES (\"name\",\"number\")");