mjp

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,

Markus

Outcomes