[lenochware]

1)

Step back/forward:

Well, I would like back/forward in what was executed, not plain undo/redo.

But maybe there can be problem, if there will be more than one queries in the editor…

It could be into the toolbar, I suppose – similar to internet browser back/forward.

Or I have yet another idea: improve history tab with possibility to hide “system” queries and copy sql code into editor when

I doubleclick on line in history.

Even without filtering feature “copy sql query from history-tab to editor with one click” would be nice, imho. Maybe better than back/fw buttons.

2) Thanks.

[lenochware]

Or offer preselected database for copying only in case there are opened only two tabs…

[lenochware]

>> You can multiple queries in one query tab. Also if you have multiple query tabs in one connection. In HISTORY there is no record of from what query tab a statement was executed….

I am not saying that it should be based on current history tab. Perhaps some new history connected to sql-query window, with queries executed from this window? In my work, I am often jumping between 3-6 queries, so I am searching for most comfortable way…plus back/forward is common concept, which anyone immediately understand. I know about other ways – multiple tabs and multiple queries in one window, but this seems better to me.

>> This I would find unsafe. I think that user should explicitly select. Automatics could be a big surprise for users. Could you elaborate the logic if a user has 5 or 10 connections open? Maybe display the open ones on top of the list?

Yes, or make it highlighted or so. I have typically open database to which I want copy into other tab, so if other people do it same way, it would be clever to offer this database for copying – at least I think so.

>> Having the columns in another order in that dialog than in the database/table would be a problem . It would generate and ALTER TABLE .. REORDER COLUMNS when saving. Also that dialog weill be compeltely redesigned in next maajor version (9.4), but same considerations would apply to both old and new version.

Yes, you are true, if I add/remove column in the dialog and do sorting, it would be probably confusing…it seems like bad idea, forget it.:)

[Author]

Posts