search

little-brother / sqlite-gui

Lightweight SQLite editor for Windows
GNU General Public License v2.0
1.07k stars 51 forks source link

Home/End keys don't work with drop down column list #121

Closed jungle-boogie closed 1 year ago

jungle-boogie commented 1 year ago

Hi,

When you're typing a query out, sqlite-gui will auto complete the column names, but you cannot use the home, end, page up, page down keys to scroll through the list.

image

If I want available, I can type an a or arrow down.

I would like home/end keys to work in this drop down list.

Thanks!

wdscxsj commented 1 year ago

Agreed. And can we use Tab-completion in addition to Enter-completion?

Another suggestion is an option to turn off the auto-completion. This will help (or force) novices to memorize the correct SQL syntax, rather than rely on tools too quickly.

little-brother commented 1 year ago

Done.

can we use Tab-completion in addition to Enter-completion?

Maybe later. I already have this point in my ToDo list.

option to turn off the auto-completion

Ok. It will be added in the next release. ``

wdscxsj commented 1 year ago

The Tab-completion in v1.7.7 is quite nice. And the option to turn off auto-completion... Maybe the next release? :smile:

little-brother commented 1 year ago

Since 1.7.7 you can turn off the autocomplete in the terminal by .set use-autocomplete 0.

wdscxsj commented 1 year ago

Thanks!