db.beginTransaction();
try {
int orderNo = 0;
- for (MobileLedgerProfile p : Data.profiles.getList()) {
- db.execSQL("update profiles set order_no=? where uuid=?",
- new Object[]{orderNo, p.getUuid()});
- p.orderNo = orderNo;
- orderNo++;
+ for (int i = 0; i < Data.profiles.size(); i++) {
+ MobileLedgerProfile p = Data.profiles.get(i);
+ db.execSQL("update profiles set order_no=? where uuid=?",
+ new Object[]{orderNo, p.getUuid()});
+ p.orderNo = orderNo;
+ orderNo++;
}
db.setTransactionSuccessful();
}
public void removeFromDB() {
SQLiteDatabase db = MLDB.getDatabase();
Log.d("db", String.format("removing profile %s from DB", uuid));
+ db.beginTransaction();
try {
- db.beginTransaction();
db.execSQL("delete from profiles where uuid=?", new Object[]{uuid});
db.execSQL("delete from accounts where profile=?", new Object[]{uuid});
db.execSQL("delete from account_values where profile=?", new Object[]{uuid});