3 Replies Latest reply on May 27, 2012 1:35 PM by datastride

    OnExit Trigger Limbo

    StephenWonfor

      Hi

       

      An FMP12 db running on server 12 and accessed by four Lion Macs. I have a very simple OnExit trigger on a field that checks to see if a payment amount = invoice total so a cheque request can be generated.

       

      If( paidamount = invoice total)

      SetVariable( $id_invoice; Invoices::id_invoice)

      Go to la yout Cheque request etc.

      etc.

       

      Fairly consistently it was noted that sometimes the cursor remained trapped in the field, the debugger said no script was running, the database window could not be closed. The only solution was a ForceQuit of FMP12.

       

      I was able to stop this behaviour by adding a Commit Records as the first step in the script. Rather odd though that this was a "fix" in that no script was apparently running. Although maybe it was running and the debugger was immue to it.

       

      Stephen

       

      "Don't knock the weather; nine-tenths of the people couldn't start a conversation if it didn't change once in a while." --- Kin Hubbard