Option to find&replace in selection

[mdro]

Describe the new feature

I previously mentioned in #1612 that Visual Studio has a usefull feature for find&replace:
If you have more than one line highlighted when you open the replace menu, "replace all" will be limited to that part.

This is usefull for example when you want to add a CREATE TABLE statement (with separate PRIMARY KEY or FOREIGN KEY clauses) that is very similar to a different one in the same file: Ctrl+C, Ctrl+V, Highlight, Ctrl+H, change field names:

Visual Studio also prepopulates the search box (for search and find&replace) with selections smaller than a line or the word under the cursor. This feature would be less important to me.

Both features can be turned off in the settings menu of Visual Studio.

[SilvioGrosso]

I second that.
This feature would be extremely useful while working in the Execute SQL tab whenever you want to replace some SQL parts. With very long SQL scripts it might allow you to replace only the selected part of the code you are interested in.

Pretty much every text editor allows you to do so. Usually, there is check-box to tick to enable it :-)

[chrisjlocke]

The feature I thought I'd use a lot in Visual Studio is the multiple carats, so you can edit multiple places at once. So in your example, rather than search/replace 'foo_id' with 'bar_id', you simply multiple-click on each 'foo' (to create multiple carats) then delete 'foo' and type 'bar' - all are edited. However, in practice, I've not used it at all yet! 🤣

[mgrojo]

Another new feature ready for testing. I hope everything is working OK.

[SilvioGrosso]

Hello @mgrojo

Thanks a lot for your last awesome effort!
I have also noticed that this option (find > replace) is case-insensitive, which is an extra-bonus for me.
Keeps rocking :-)

I have tested this new option on Windows 10 - 64 bit, with DB.Browser.for.SQLite-win64.

Here is my screenshot where I have selected my text and then replaced the word mary with LUCY (just for testing purposes):

[justinclift]

@SilvioGrosso Out of curiosity, is that using a Windows nightly build from today?

Asking for an unrelated thing - I just upgraded the Qt version used for the Windows builds - so um... keep an eye out of any extra weirdness too. Just in case. 😄

[SilvioGrosso]

Hello @justinclift

I have dowloaded this build (3.11.99) this morning, an hour ago.
Judging by your latest github commits, I suppose it is after you Added Win64 nightly build script.

Here is my screenshot on Windows 10 (64 bit) though:

[justinclift]

Excellent, thanks heaps @SilvioGrosso. 😄

[SilvioGrosso]

Hello @chrisjlocke @mgrojo

In appreciation of your hard work on Db Browser for SQLite I have just increased my monthly payment on Patreon.
By doing so, it is for instance now possible to purchase the basic certificate for signing the builds on Windows (since the total sponsorship is now > 75$).

[justinclift]

Fantastic @SilvioGrosso. That's good timing, as the next release shouldn't be too far off now. 😄

[SilvioGrosso]

Yep. I know: I did it on purporse: to make Windows users happy  :-)

[mgrojo]

Thanks a lot, @SilvioGrosso!

By the way, curious location of the Help button in Windows. In Linux is at the left aligned relatively to the window, and Close right aligned. If at least the buttons were in different positions, with Close at the right end, it would look better. That's funny because the Help button under Windows wouldn't be necessary, since I see there is a [?] window button. The Help button enters also in What's This mode and I added it because in Linux there is no such thing as a [?] window button.

[SilvioGrosso]

Hello @mgrojo

This ? window button is indeed quite interesting :-)
Its own tooltip is another ?

When you press this button no action is triggered but, alongside the mouse's cursor, another ? appears.
Later on, whenever you click somewhere on the GUIs new tooltips show up to illustrate the part where your mouse in positioned.

For example, I have just clicked on this part of the GUI:

[mdro]

Works perfectly.
Thanks for the great work @mgrojo !

[mgrojo]

@SilvioGrosso

When you press this button no action is triggered but, alongside the mouse's cursor, another ? appears.
Later on, whenever you click somewhere on the GUIs new tooltips show up to illustrate the part where your mouse in positioned.

Yes, that's exactly it's use. It's the so called What's This? feature. You can also access it from the Help menu in the main window or almost everywhere pressing Shift+F1. We have included some helpful messages in some of them. Other are plain boring. If we don't use it more it's because we think they are usually overlooked by users 😄

I have code for adding all the editor shortcuts to the "Execute SQL" message, because it currently lacks one and QScintilla provides a list of them with short descriptions. The problem is that the text is then too large and these floating tips are not thought for so much content (the text is truncated at least on my computer). I've finally added the generated list to the wiki page: https://github.com/sqlitebrowser/sqlitebrowser/wiki/Keyboard-shortcuts#sql-json-and-xml-editors but I'm still thinking on how to add them to the application. Most are widely known, but there are also less known/standard shortcuts that are also useful.

[mgrojo]

Closing this as it was already confirmed.