AnsweredAssumed Answered

Cannot delete portal row when script trigger "onObjectExit" is enabled

Question asked by Antony on May 31, 2011
Latest reply on Jun 1, 2011 by Antony

Summary

Cannot delete portal row when script trigger "onObjectExit" is enabled

Product

FileMaker Pro

Version

11v1

Operating system version

XP SP3

Description of the issue

Context :
Table "students" with student ID, name, etc.
Table "grades" with student ID, class ID, etc. (multiple grades for one student)
I have a portal in my "student" layout which shows the grades of the student. The portal has row deletion enabled. It works fine this way.

I have a script step to calculate the cumulative mean of the student. This script is activated by the "OnObjectExit" trigger on the portal. If this trigger is activated, I cannot delete the rows of my portal.

Steps to reproduce the problem

I tried deleting the row with a script, didn't work.
I tried deleting the row manually. FM ask me if I want to delete the related record. If I click "yes", nothing happens (no error message).

If I disable the "OnObjectExit" trigger step, it works (successful deletion). If I re-enable it, it doesn't work (no  deletion)

Expected result

Deletion of the row even if OnObjectExit trigger is active.

Actual result

The row is not deleted if OnObjectExit trigger is active.

Exact text of any error message(s) that appear

No error message.

Workaround

Using the script trigger OnObjectSave instead of OnObjectExit.

Outcomes