The file must be hosted on FileMaker Server, with a system DSN pointing to the SQL source, but yes, filemaker go can make the update.
Since you can't configure DSNs on FileMaker Go, it's impossible to get it to work unless you're connected to a hosted file.
Thank you so much for the reply.
The file I am running is hosted from a Filemaker Server.
I figured that Execute SQL script is not compatible in iOS, hence it works from Filemaker Pro desktop app and not from Filemaker Go in ipad.
I understand that I could use Perform on Server Script,but not sure what alternative I could use for Execute SQL to insert or update values in External SQL Sources.
Your use case is exactly what perform script on server was designed for. Setup a system DSN on the server and send commands for the server to run your SQL actions.
Are you perhaps misunderstanding what perform script on server does and how it functions?
I have made ODBC connections to the data sources in the filemaker Pro App.
Then enabled JDBC/ODBC connections in sharing.Also sharing it with Filemaker clients.
Then I have executed Execute SQL script to insert values to a table in this External Data table. it works fine from Pro Advanced,. How do I write a Database Query stmt inside Perform on Server Script.
I am a newbie to Filemaker and hence still finding my way around it.
Thanks in advance
Also how to setup a System DSN form Filemaker Server??
Hi - the following guides may be helpful for you:
The help guides that you access from within FM also have helpful information.
If you are just wanting the ability to edit / update / enter field data from FileMaker Go without a scripted process you could do it by having a layout that displays the fields from the external source and allows users to edit them. You would want to ensure you have adequate permissions / privilege sets setup so that only users that should have the ability to make changes can do so.
To round up all the answers:
ExecuteSQL will only read data.
If you can see the External SQL tables in your FM Relationship graph, the fields can be added to a FMGo layout and can be updated. I would advise using a refresh window script step with a flush of the cache and updating all ESS data. The really seems to ensure the data is updated in a timely manner and only takes a second or so to process. I do ESS data manipulation on the iPad all the time.