Calculation refresh issue

Classic Servoy
1

Hi there,

I have a calculation field as follows:

   if (g_student_parent_id__parent_to_student_parent.parent_id == null) {
      return 0;
   }
   else {
      return 1;
   }

I calculation is not actively refreshed. Sometimes it does and sometimes i does not.
The calculation should refresh when new related records are created/deleted. It is not consistent.

Also do you advise me to the following when going the list which has that related calculated field so that the calculated field refresh better?

var frmObjLink = globals.mod_functions_path_layout("getMainFrmObj"); // returns a form object
frmObjLink.controller.loadAllRecords();
databaseManager.recalculate(frmObjLink.foundset);
2

faheemhameed:
Hi there,

I have a calculation field as follows:

   if (g_student_parent_id__parent_to_student_parent.parent_id == null) {

  return 0;

}
else {
return 1;
}




I calculation is not actively refreshed. Sometimes it does and sometimes i does not.
The calculation should refresh when new related records are created/deleted. It is not consistent.

Also do you advise me to the following when going the list which has that related calculated field so that the calculated field refresh better?

var frmObjLink = globals.mod_functions_path_layout(“getMainFrmObj”); // returns a form object
frmObjLink.controller.loadAllRecords();
databaseManager.recalculate(frmObjLink.foundset);

faheemhameed:

I’m having similar problems. It may be a bug. Hang in there, maybe we will hear something today.

Regards,
Lee Snover

3

Hi Lee Snover;

var frmObjLink = globals.mod_functions_path_layou("getMainFrmObj"); // returns a form object 
frmObjLink.controller.loadAllRecords(); 
databaseManager.recalculate(frmObjLink.foundset);

The above code works for me. But I am unsure it will cause problem with large foundsets[/code]