AnsweredAssumed Answered

Issue with ExecuteSQL calculation

Question asked by jamest on Jul 2, 2012
Latest reply on Jul 5, 2012 by greglane

I'm wondering if I'm doing something wrong, I'm running the ExecuteSQL calculation on an external ODBC data source. I'm not using the script step, perhaps I should be. Upon running the following statement, FileMaker 12 A hangs indefinately. Access to the data source is not an issue as the layout shows the data with no issues.

 

Is this mearly a case of the calculation not being able to be run on external data sources?

 

 

ExecuteSQL(

"SELECT *

FROM External_STUDENTS

WHERE STU_ID = ?";

""; ""; External_STUDENTS::STU_ID)

 

 

Regards,

James

Outcomes