Toad Version: 188.8.131.529
In creating an App that uses the "Export Dataset" (with Excel), I am wanting to create a copy of an a "template" workbook, then create several sheets that correspond to different SQL statements.
I created the following app: (Note: the timeout shells are because the app runs faster than Excel can handle the open-write-close of the workbook. It causes a Unable to open an open workbook error).
The problem I'm having is with the "Shell Create_Copy.BAT" shell execute step.
Even though it is in the "Connection Iterator 1" loop, it only executes once. (It is a simple copy with a Command Shell parameter to name the Template correctly)
The program flow doesn't follow the listing of the program, hence, it is creating workbooks and worksheets out of order, and makes everything completely wonky. If I only have one connection, it works perfectly.
Seems like a basic Program Flow Control issue. What am I missing.