periodId=uniqnum.GetUniqueNumber("PeriodId="+ rsPeriods.getDate(1) + "-"
+ rsPeriods.getDate(2), 1, 999999999,new Integer(lastCompId));
break; //we found the period we need
}
}
dc.con.createStatement().executeQuery(dc.filterSQL(
"UPDATE Activity2 SET PeriodId=" + periodId + " WHERE CompId=" + lastCompId + " AND Act_id=" + rsOldTrans.getInt(2)));
workDialog.SetProgress((rsOldTrans.getRow() * 100) / (numRecs));
}
} catch (Exception e) {
e.printStackTrace();