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”,
Yes…more sensible answer than mine. I figured he had sorted by description.
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’