AnsweredAssumed Answered

ExecuteSQL not working with ODBC datasources?

Question asked by thomas_staehli on Sep 15, 2015
Latest reply on Sep 15, 2015 by Mike_Mitchell

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