I have a very simple find script that works fine on FMP but in Go it returns a foundcount of 0 records.
I've been troubleshooting this for a couple of days and the only thing I can come up with is that my primary key field is a number field and the foreign key is a text field. Could that be the issue?
my primary key field is a number field and the foreign key is a text field
This could cause on all kinds of issue in FMP and FMGo. Both fields should be the same type.
You can force a square block into a round hole, but what's the point.
Just to make sure my original post isn't too confusing, the field I'm setting the variable from is a text field. The field I'm searching is a number field.
But as a test, I created a new text field and manually typed the ticket number into it and modified my script to search the new test field. Still foundcount 0 on FM Go. Works perfectly on FMP.
FMP version: 17.0.205
FM Go, I can't figure out how to get the version! Get(ApplicationVersion) just returns "Go_iPad". I did make sure I have the most recent version by going to app store though.
FM Server version: 17.01.146
thanks for any suggestions!
There is nothing in your script that should produce different results between Go and Pro. But such solutions often use different layouts for different devices. I’d first take a look at what layout is current when this script starts up. If it’s a different layout for Pro vs Go users, I’d double check the table occurrence specified for each layout. It’s also possible that set error capture is concealing an error condition in the first part of your script.
I disabled the error capture step and the only error I get is no records match this find criteria.
It is the same layout for Pro and Go.
This is such a simple script, this is weird!!
Just before the set field, use show custom dialog to show the value of the variable.
it returns the correct value: 2018_1334
it seems to work if I log in as admin. so I'm looking to see what in privileges could be wrong.
I think so it’s the issue. Both the primary and foreign key should be of same type. I guess that it shouldn’t work on Pro.
It would be interesting to know FMP and FM GO versions, and if file is open from FMS then the server version.