1 Reply Latest reply on Jun 13, 2017 7:57 AM by beverly

    Import from host to local FM go




      I have a quick question.


      I have a standalone iPhone/iPad app local to the device.

      Let me call my files FIle_Local and File_Hosted

      Every time the user opens the app, I have a script that checks for connection to the FM Server.

      If there is connection available, I run a script from File_Local that calls another script in File_Hosted which runs a Stored Procedure to populate a SQL table, tbl_WKO

      Both File_Hosted and File_Local has a reference to this SQL table tbl_WKO.

      Once the table tbl_WKO is populated, I run a Import statement in my file_Local, to Import these recently populated records into a local table in file_Local.

      It all works fine in Filemaker Pro Advanced, but when I run the exact same scripts from FM Go, the Stored procedure is executed properly and the table tbl_WKO is populated properly, but the local_File could not access this tbl_WKO and hence the Import doesn't work in FM go.


      Some one please tell me how can I get this populated vales from tblWKo into a local table in File_Local.