Folks,
I've been searching through the forums all morning and can't find this one so here goes:
Environment:
FB7 IDE project with mulitple action lists.
1. Is it possible interactively have a prompt to select the action list you want to run?
Limitations:
I don't want a static variable/list/file with the names in it.
The list needs to be dynamically created at project startup and as new action lists are added in.
I need to automate the process as much as possible to avoid issues where a change is made and config file/setting/variable list is not updated.
The idea behind the project is that we have multiple SQL servers with differing scripts that need running.
I've setup a project for scheduling each script as an individual action list that's called through a set of If/Then/Else iterators when scheduled based on time/day/date and so on.
What I need to do now is convert the scheduled task into an ad-hoc run where the user choses the script & server to run.
I've thought of using a switch/case option with a prompt for "choose one" but I can't find how to make the "choice" the Action List name dynamically.
If there is a better way then let me know!
Cheers,
Steve