If you open both files on your mac and run the script does it work?
I've tried every combination of files being open or closed and nothing seems to change.
What I am asking is if you put both files.. target and source on your mac.. what are the results.. (not on fm go) If you have fm pro advanced you can run the script debugger and it will show you what is happening..
We're starting to get somewhere! I run the script in TestMSSTarget11.fmp12 on the macbook and I get back the following error:
There are less records in the data source than in the target table. Not all records were updated.
I click okay. Then:
Total records added/updated: 1
Total records skipped due to errors: 0
Total fields skipped due to errors: 0
Table created: <none>
The one record in source didn't change. The same record in Target11 was modified to match the source (I left 1 field different).
When I do this from the iPhone the record ISN'T changed.
And thanks for helping me! I'm appreciating it.
Another major revelation. I was getting confused by the terminology in the Documentation. The documentation uses remote source for the FM Pro computer and local database for the iPhone. I got in my head that the FM Pro computer should be the local, and the iPhone, being a mobile device, should be the remote. But the documentation is for FM Go, and hence written from the viewpoint of the iPhone.
That said, I still need the ability to pull info into the iPhone as well. Even though I had things backward, I had left differences in the Source file so in the event of me getting things backwards I should still see a difference.
I'm in the process of setting up a different test based on Example 2 on Page 9 of the FM Go developers documentation. Once I finish that I will report back.
So using example 2 on Page 9 of the documentation, I have successfully transferred data from the iPhone to the Macbook. This solves the first half of my situation, moving my data from iPhone to computer. It doesn't solve my need to also push data out to the iPhone at the start of the day. So I'm back to testing Example 1.