Sort arrows are wrong direction

[elijah-rappaport]

The arrows in the column headings to indicate sort direction are incorrect. They are the opposite of what they should be. An upward facing arrow means the sort is from smaller to bigger (or alphabetic). A downward facing arrow means the sort is from bigger to smaller (or reverse alphabetic).
Take a look at the arrows in the column headers of folders on a PC or a Mac, or in Outlook, or any other common software that allows sorting by columns, and you will see they are using them the way I am describing, which is the opposite of how you are.

[justinclift]

I'll check this out tonight too. 😄

[justinclift]

Hmmmm, on OSX 10.9 here, and it doesn't seem to be wrong for me. For example, the sort column here is the "hour" column. The little arrow is pointing downward which should mean biggest to smallest, and the sort order is doing that:

It seems to be correct in the other direction too:

If it's not doing this for you, are you ok to screenshot the problem?

[elijah-rappaport]

[justinclift]

Interesting. What data type is the parent_list_id field defined with there?

[elijah-rappaport]

[Z4us]

INT = short for INTEGER it's written full in 'list_id' to make it (synonym) of ROWID

ref. https://www.sqlite.org/lang_createtable.html#rowid

[elijah-rappaport]

It is sorting incorrectly for list_id too

[Z4us]

The arrow shows the order you can change the current one to so the opposite of what is the "status quo"

[ghost]

Ok, I think I got this fixed.
Apparently the problem happened when opening a table for the first time (either by opening a database file or switching tables) and clicking on a header. Then the data were sorted correctly (based on the order from the SQL query), but the arrow was upside-down.
Would be great if you could do some tests 😄

[justinclift]

Awesome @Samir-Aguiar. 😁

Just tried out the behaviour for this before-vs-after, and yeah, you guys are right. Here's a sort showing the wrong order (from the commit right before this one):

and the opposite direction:

Here's the same thing, but compiled with the fix:


Seems good now. 😀

@harrisrap Would you have a few minutes to try out the nightly build (tomorrow), and let us know if that works properly for you? 😄

[justinclift]

@harrisrap ping? 😄

[elijah-rappaport]

Sorry, I don’t see how to install the nightly build. Instructions please?

[justinclift]

No worries. 😄

1. Remove the existing DB4S / SQLite Browser application from your /Applications list.

2. Grab the .dmg here:

        http://mirror.salasaga.org/sqlitebrowser/nightly/sqlitebrowser_20150325.dmg

3. Open that dmg file (double click on it in Finder), then drag-n-drop the sqlitebrowser.app file to your /Applications folder.

In theory, that should install the latest nightly build. If it doesn't for some reason, let us know. 😄

[elijah-rappaport]

Eureka! You did it. Sort arrows are working perfectly now. Nice work
gentlemen.

[justinclift]

Awesome. You've nailed another one perfectly @Samir-Aguiar. 😁

@harrisrap Thank you very much for reporting the problem, and verifying the fix. It really helps. 😄