Scriptcase sorting is totally messed up

Please ask them to fix it, send the email to: bugs@scriptcase.net

What am I missing? First one is sorted by name. Second by Description.

First column should be sorted A,a,B,b,C,c…Z,z
this sorting is wrong

if unsure open File explorer in Windows and check how the files in a folder are sorted

just click on the header “project”,

image

Yes…more sensible answer than mine. I figured he had sorted by description.

@mollyshark You are right. We can see the arrow in Description.

image

yep, it’s sorted by descritpion, but still “iTRACKER COLUD” is listed after “WebService Samples” so maybe aklass has a point.

It is the only lower case description there. I looked at mine and it does, indeed, sort upper case FIRST and then lower case. Not being controlled by Windows and I don’t see any setting that would change that. Obvious solution is make the first letter same case for all project names and descriptions, but it is still a curious behavior.

Just do the same test in the grid. That is more important to get correctly than list of projects, but I believe there is the same issue. If you have i.e list of people like this:

john
Tim
John
alice
1alice

should be sorted:
1alice
alice
John
john
Tim

verify if Scriptcase does this correctly, cause I believe it is all wrong

In GRID the sorting is done by your database

You can do ORDER BY lower(Field) or ORDER BY binary(Field) to fix it.

You can also ORDER BY Field COLLATE ‘Latin1_general_ci’