mercredi 9 septembre 2015

Table not getting copied while coping from one sqlite DB to another DB using ATTACH command

I am coping some table from one DB to another DB by using the below command

  mSQLiteDB.execSQL("ATTACH DATABASE '" + TaskSetupContract.TASK_SETUP_DB_PATH_TEMP
                              + "' AS SourceDB");
 taskSetupDB.execSQL(
              "CREATE TABLE IF NOT EXISTS " + tableName + " AS SELECT * FROM SourceDB." + tableName);

All the tables are getting copied except one table. The previous data of the table is getting deleted and I am getting a table with no data. I could not able to find what is the issue. Please help me with this ....Thanks a lot in advance.

Aucun commentaire:

Enregistrer un commentaire