AnsweredAssumed Answered

Execute SQL ( )

Question asked by deninger on Jan 20, 2015
Latest reply on Nov 27, 2015 by beverly

I have thoroughly explored the ExecuteSQL() script step and have put it to a lot of use.

 

NOW I am trying to get my head around the potential uses of the EXECUTE SQL () step. In looking thru the script steps reference, I can see how it can used to add or delete data directly on the SQL source. I imagine that I could run stored procedures as well...

 

What would make things more interesting, and what I am not seeing (and am hopefully missing) is how to return values from the executed SQL call without having to round-trip the whole data batch into FileMaker Pro. Is it possible to use Execute SQL ( ) on SQL Server and then grab (save to a variable) the return a value(s) for further processing?


Outcomes