6 Replies Latest reply on Jun 30, 2015 2:34 PM by philmodjunk

    executesql () function and external (filemaker) data source



      executesql () function and external (filemaker) data source




      I am trying to use the executesql()  function and right after evaluation the SELECT statement, I get an error message "the specified table cannot be found"  

      After having tried to provide table names instead of table occurence names without succes, I realised that the cause of the problem might be  that there are not tables in my file, all the tables are in an external , filemaker, data source, as I have split the user interface an logic from the data.

      Is my diagnose of the problem correct, is there a solution? I am afraid I painted myself in a corner.