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

    ExecuteSQL not working with ODBC datasources?


      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