getting this warning on deleteAllRecords();
2012-01-24 14:05:54,494 WARN [pool-3-thread-1] com.servoy.j2db.util.Debug - Could not connect next foundset chunk, re-loading entire PK set
I think this is because my dataset result is > 200. Can anyone help me on how can i correct this?
function deleteOrganizationData(orgIDList) {
var serverTables = databaseManager.getTableNames(globals.DB_SERVER_NAME);
for (var index = 0; index < serverTables.length; index++) {
var tblFoundset = databaseManager.getFoundSet(globals.DB_SERVER_NAME,serverTables[index]);
var orgIndex = tblFoundset.alldataproviders.indexOf("username");
if (orgIndex != -1) {
var tablePk = databaseManager.getTable(tblFoundset).getRowIdentifierColumnNames()[0]
var sql = "SELECT " + tablePk + " FROM " + serverTables[index] + " WHERE username IN (?)";
var ds = globals.cmn_executeQuery(sql,["ABC"],-1);
if (ds.getMaxRowIndex() > 0) {
tblFoundset.loadRecords(ds);
tblFoundset.deleteAllRecords();
}
}
}
}