I inadvertently disabled TOAD’s ability to refresh the SQL after changes in QUery BUilder. Can anyone tell me how to change it back? Thanks
Were you adding to the SQL in the Query tab? If so you can refresh the Diagram tab by pushing the “Visualize the SQL statement in the query tab” tool button.
If you add more than one filter on the same column it will be displayed as a “Where Clause” circle. This is because the column grid has a limitation of one filter per column.
Forgive ny slowness but just where is the Visualize the SQL statement in the query tab" tool button?
See screenshot. If the tool button is not enabled, type a space in the Query Tab. It enables when it thinks there is a change.