2) Is there any way to manipulate the Execute SQL script to return SELECT results when talking to an ODBC source?
You have to use the "Import Records" from ODBC datasource script-step. If you query returns a single value, you can import into a global field or to field in a single record table. For multiple row results, you'd need a special import table, maybe add a import-id to the query for multiuser capability and for grabbing the relevant records for further processing...
To return SELECT results from Execute SQL on ODBC source you will need to trigger the query through the Import Records > ODBC Data Source and map it to a FileMaker table
2 of 2 people found this helpful
As stated: Import to SELECT from ODBC source.
& "Automating ODBC import using the Import Records script step"
& "Storing an SQL query in a field"
the data is "live" at the moment of import. use Execute SQL to INSERT, UPDATE or DELETE (the sql source), only. If you need to 'refresh' your query, you can reimport and use the update feature of the import dialog.