AnsweredAssumed Answered

Execute SQL script step

Question asked by EdwardNovak on Feb 3, 2015


Execute SQL script step


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?