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.
Thanks very much,