jeudi 3 mars 2016

android.database.sqlite.SQLiteException: near "ce": syntax error (code 1): , while compiling: INSERT INTO

I am initializing my variables as follows:

String separator = "" ;
String insertQuery1 = "INSERT INTO " + PhoneContactsTable.TABLE_PHONE_CONTACTS + " (" +
          PhoneContactsTable.KEY_NAME +"," +  PhoneContactsTable.KEY_PH_NO +"," 
          + PhoneContactsTable.KEY_SNID +","+ PhoneContactsTable.KEY_EMAIL +") VALUES " ;

StringBuilder insertQuery2 = new StringBuilder();

I am generating insertQuery2(stringbuilder) as follows:

try
{
    JSONArray jsonArray = new JSONArray(returndResultForSNID);

    for(int i = 0; i < jsonArray.length(); i++)
    {
        snid = jsonArray.getJSONObject(i).getString("snid");
        insertQuery2.append(separator).append("('").append(contactNameArr.get(i).toString()).append("','").append(contactPhoneNumberArr.get(i).toString()).append("','")
        .append(snid).append("',").append("''").append(")");
        separator = "," ;
    }

}
catch (Exception e)
{
    System.out.println( "Could not parse malformed JSONArray: " + e.toString() );
}

I am creating the last String as insertQuery3 which is being inserted into database:

try
{
    String insertQuery3 = insertQuery1 + (insertQuery2.toString()).toString();
    phoneContactsDAO.open(false);
    phoneContactsDAO.addFullStringToDb(insertQuery3);
    phoneContactsDAO.close();
}
catch (Exception e)
{
    System.out.println( "Could not added into database: " + e.toString() );
}

My database query is as follows which seem fine:

public void addFullStringToDb(String insertQuery3) 
{
  database.execSQL(insertQuery3);   
}

This code worked in 4phones. But is not working on a 5th device

Aucun commentaire:

Enregistrer un commentaire