Servoy 4.1.0
Java 1.6
Windows XP pro
Mysql 5.x database
I am having a weird issue with performUpdate function.
I have 700 records in my forms.timesheet.foundset
When I try to update a column using the performUpdate, It updates only 400 rows
- Code: Select all
var theFoundsetUpdater = databaseManager.getFoundSetUpdater(forms.timesheet.foundset);
theFoundsetUpdater.setColumn('flag', 1);
theFoundsetUpdater.performUpdate();
databaseManager.saveData();
When I go to the timesheet layout I notice it alternately updates 200 rows (i.e updates first 200, followed by skipping the next 200, hence it updates 400 records and ignored 300 records)
But if I do the following it updates all the 700 rows
- Code: Select all
for(var i=1;i <= databaseManager.getFoundSetCount(forms.timesheet.foundset); i++)
{
forms.timesheet.controller.setSelectedIndex(i);
forms.timesheet.flag = 1;
}
databaseManager.saveData();
Am I missing something in the performUpdate that results in skipping 200 rows at a time when doing the update.
Regards
jdcunha