Updating SQL using FMGo 12
I need to find out advice on the best way to update a SQL DB using FMGo 12. I developed a program to interact with a SQL DB and it all worked well, that was until I ran the program remotely on an iPad. I had the SQL DB in the relationship graph and setup the ODBC connection and on the initial tests from my Mac, the SQL DB was updating. Now when I try and update the SQL table remotely, whether on an iPad or Mac, it's not updating properly.
I have uploaded the fmp12 file to FM Server 12 and got it working on the local LAN. So now the fmp12 file is on the server that is also hosting the SQL DB and I configured the ODBC connector to link to the now local SQL DB. Now I can see the file and run the file from the iPad, the only problem is that it seems the SQL DB is not updating properly.
Would it be better to rather run the fmp12 file directly from the iPad, and then have it sync back to the server when the button to process the SQL info is pressed, or would it be better to figure out if there is an issue with maybe the post script and keep it running on the server and access the file over the remote link. I do have to mention that I am not using the ExecuteSQL script, I am just updating the SQL table that I have linked to in the relationship graph.
Is there something that I am missing?