1 2 Previous Next 16 Replies Latest reply on Sep 15, 2015 4:44 PM by Mike_Mitchell

    ExecuteSQL not working with ODBC datasources?

    thomas_staehli

      I have a local filemaker database which has a few tables and an SQL Server as external datasource. I can create layouts based on the external datasource, create new records and make modifications without any particular issues.

       

      But when I try to use the "new" ExecuteSQL statement to quickly get some information from the external datasource, all I get is "?".I know my statement is not wrong, as I really tried the basics (select * from table), and if I put a local table instead of the external table, I get the correct result

       

      So I was wondering, does filemaker actually allow the ExecuteSQL function on ODBC external datasources?

       

      Any ideas?

       

      Thanks in advance for your help

        1 2 Previous Next