I have a script step that is set up to import records from a SQL Server DB into FM using calculated SQL Text. The step works fine only after I have unchecked the "Perform without Dialog" option and set up the mapping the first time.
After the first time, I can uncheck the option and the script works flawlessly thereafter.The problem is, that the mapping appears to be forgotton again after I close the file and re-open it.
Is there something I am missing in order to make this stick? Having the end-user navigate these screens would be unacceptible.