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?
Thanks in advance for your help