AnsweredAssumed Answered

Count works on OS X but not iOS

Question asked by ScottBleackley on Apr 27, 2016
Latest reply on Apr 28, 2016 by ScottBleackley

FMGo 14.04 iPad 9.3.1 (13E238) 128GB 95 available
FM Pro A 14.05 OS X 10.11.4

 

Use in a script of Count ( tableName::FieldName ) returns a value in OS X but only ? in iOS
Same code different behaviour.

 

In the code sample below values are put into existing fields UTM Zone, Easting, Northing
for diagnostic purposes on FMGo ( would love debug and data viewer on iPad )

 

On OS X for the true if condition I get values 1, 1, 4 for the else condition 0, 0, 5 as it should be.

On FMgo for the true if condition I get values 1, ?, 4 for the else condition 1, ?, 4 which is not correct.

 

Critical issue.  Any work arounds possible?
I need to know if there are any related records in the tableName,
since it is a list of 23 thousand unique values there will only be one match if any.

Screen Shot 2016-04-27 at 1.47.45 PM.png

 

Thank you

Outcomes