ExecuteSQL query against external ODBC-Table

Discussion created by mjp on Sep 4, 2015
Latest reply on Jan 27, 2016 by mjp

Hi there,


i want to execute a simple SQL query against a table (docs) which is in external data source linked via ODBC. Is that possible? When I do:


ExecuteSQL ( "select max(created_at) from docs" ; ";"; "")

The return value is just a question mark?


The other way to figure out the maximum - sorting by created_at asc and getting the last value - is quite slow due to more than a million records. And I also think using the Filemaker Max-Function with a self-referencing is slow, too.


Any hints?


Thanks very much,