AnsweredAssumed Answered

Execute SQL / Stored Procedure format?

Question asked by user5571 on Sep 16, 2015
Latest reply on Sep 21, 2015 by beverly

I have been given the following stored procedure that has 2 parameters.....

 

Exec iSM_Query6 ‘CTDS’, ‘01/09/2015’


How would I translate this in FileMaker's Execute SQL script step using the 'Calculated SQL text"? 

 

I'm assuming the results can only come into a single field within FileMaker (which isn't ideal).

 

Being a SQL novice I'm just not sure of the formatting.

 

Any advice would be greatly appreciated.

Outcomes