Description: Tools > SQL opens a dialog from which ad-hoc SQL statements can be submitted. As someone who uses Base as a tool for quick ad-hoc data massaging, this is among my most frequently used tools; however, I feel UX could be improved in a few ways: * Don’t make it a modal dialog. There’s really no need why I should not be able to do anything in the main window while this dialog is open. In fact, I would recommend making this not only a non-model dialog but a side pane, similar to the Document Navigator or Styles and Formatting in other LO apps. * Save the list of previous commands at least for the entire session (i.e. do not clear it when the dialog is closed and reopened), maybe even across sessions. * For select statements, display the number of rows returned (maybe even if “show output of SELECT statements” is unchecked) Steps to Reproduce: This field does not apply to enhancements. Actual Results: This field does not apply to enhancements. Expected Results: This field does not apply to enhancements. Reproducible: Always User Profile Reset: No Additional Info: This field does not apply to enhancements.
This bug (enhancement) isn't reported only for one part, which should be changed. So it is difficult to give a comment to all. Might be it is better to write 3 bugs to get a good answer. 1. Dialog Tools → SQL shouldn't suppress any other action 2. Commands should be be saved 3. Numbers of affected rows should be shown I will answer only to 2: Previous commands will be saved while the dialog is opened. But they will be deleted when dialog will be closed. I would prefer to save the commands in the Base file. You should also be able to delete a command you don't need any more in the list of commands. This possibility isn't offered at this moment. So it is bug-description for a new enhancement. I will switch this one to "NEW".