AnsweredAssumed Answered

Execute SQL script step

Question asked by EdwardNovak on Feb 3, 2015

Title

Execute SQL script step

Post

We use FM to access our SQL data for some now. I have created the ODBC external source and for the most part simply added SQL fields to our FM layouts adding a Commit Record trigger to those fields. All works fine. Now I'd like to explore using the Execute SQL script step, however when I go to set it up and try to specify the ODBC data source, none of my external sources display as options to select. I was anticipating that if they were set up for accessing SQL fields OK they would also be available for this step. What am i missing?

Outcomes