Hello, I am using the sqlexecutor and I am populating the attributes to expose from sql query. It correctly displays them but there is a (ok) button missing to add them successfully. When I close the window (x), they won't be added.
Question
Why is the ok button missing when using sqlexecutor - attributes to expose ?
+12- Supporter
Whoops! Which version of FME are you using here?
FME 2022.1.1 After I closed and reopened the script, the button was there. I don't understand what can trigger it not be displayed.
+47- Celebrity
FME 2022.1.1 After I closed and reopened the script, the button was there. I don't understand what can trigger it not be displayed.
I know there was another bug in the SQLExcecutor in FME 2022 but that war related to embedded passwords in the connection parameters. Hopefully this weird bug is fixed in a later version.
+12- Supporter
@virtualcitymatt Hey, I just encountered the same error again. This how you can reproduce the bug. 1. Add a sql creator, 2. add the connection and 3.add your sql statement and hit ok button in sql statement window. 4. close sql statement window. 5.reopen the sql statement window and click cancel. 6.close the window. Do step 5 and 6 at least one more time, sometimes even more. Click on the three little dots to open enter attributes to expose window. the ok button is gone. This is definitely a bug.