Lizhe

Calculation error on Filemaker 14 and 15

Discussion created by Lizhe on Sep 27, 2016
Latest reply on Sep 27, 2016 by Lizhe

I have a script which does not produce the expectedt result. So I looked at the debug trace and find a problem below (screenshot of Dataview):

the statement is {set variable [$reaId; Value: Case(IsEmpty($reaId); REA Reagent::_pk_Reagent; $reaId & return sign & REA Reagent::_pk_Reagent}

The screen shot was taken just before the execution of the statement.

 

$reaId has a value of 1. After the execution of the statement, I expect $reaId has value 1 and 3 separated by return. However, I got "empty return 3". This was produced on Win7 with Filemaker 15. Then I tested on Mac with Filemaker 14 and got the same result. I don't understand what goes wrong. Please help! Thanks.

 

BTW, the only different between FM15/Win7 and FM14/Mac is on Mac before the execution of the statement, the second line shows value is "1 3"; after the execution of the first statement, the second line shows " 3 3". However, the $reaId is " 3" for both versions.

Outcomes