GUI mode has suddenly "disappeared" from all my existing update queries.
Both SQL and GUI tabs are still present but clicking on the GUI tab has no effect. The SQL window remains in place whichever tab I click. In most cases the SQL window is blank because I have been using GUI mode for the table updates.
The query still runs and appears to do what it's supposed to, but there is no way to view or modify it.
I've tracked down a "cause".
I use the dynamic Resource Id, and as soon as I click the "F" icon, and the Resource Id appears instead of Resource name, then the GUI window disappears.
Resource by name...
Click on "F" for Dynamic resource...
Now I found the answer myself...
Apparently GUI mode isn't available when using dynamic resource setting...
So I guess the GUI mode has been missing ever since I switched to dynamic resource, and I just hadn't noticed it before.
(I updated the title to be clear what this is about)
Since the GUI action appears to work anyway even though the details are not visible; a simple work around seems to be to switch the query temporarily back to specific resource by name, work on the GUI settings as necessary, then when finished switch the query back to the dynamic resource.
Can I repy on the GUI mode working when "invisible" or are there any risks in doing this?
Very interesting findings, and good to know for the future. Thanks for all the details @davblo
