/// <summary> /// Update Value/Description after change of /// account element value/description. /// </summary> /// <param name="ctx">context</param> /// <param name="where">where clause</param> /// <param name="trxName">transaction</param> public static void UpdateValueDescription(Ctx ctx, String where, Trx trxName) { String sql = "SELECT * FROM C_ValidCombination"; if (where != null && where.Length > 0) { sql += " WHERE " + where; } sql += " ORDER BY C_ValidCombination_ID"; int count = 0; int errors = 0; DataSet ds = new DataSet(); try { ds = DataBase.DB.ExecuteDataset(sql, null, trxName); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow rs = ds.Tables[0].Rows[i]; MAccount account = new MAccount(ctx, rs, trxName); account.SetValueDescription(); if (account.Save()) { count++; } else { errors++; } } ds = null; } catch (Exception e) { _log.Log(Level.SEVERE, sql, e); } _log.Fine(where + " #" + count + ", Errors=" + errors); }