S sigster Active Member Licensed User Longtime User Feb 21, 2012 #1 Hi need help with this Please I am try to sort the sqlite listview I use --> order by hverfi ASC in the list I have word what start with Á that word are last in the list but need to be the first Regards Sigster
Hi need help with this Please I am try to sort the sqlite listview I use --> order by hverfi ASC in the list I have word what start with Á that word are last in the list but need to be the first Regards Sigster
NJDude Expert Licensed User Longtime User Feb 21, 2012 #2 Have you tried using "COLLATE NOCASE"? Upvote 0
S sigster Active Member Licensed User Longtime User Feb 21, 2012 #3 Yes COLLATE NOCASE don't work Upvote 0
M Mahares Expert Licensed User Longtime User Feb 22, 2012 #4 If it is last in the list and you want it to appear first, try using DESC instead. order by hverfi DESC Upvote 0
If it is last in the list and you want it to appear first, try using DESC instead. order by hverfi DESC
T timo Active Member Licensed User Longtime User Feb 22, 2012 #5 Did you try adding 'ListView1.clear' before quering the cursor? Upvote 0
margret Well-Known Member Licensed User Longtime User Feb 22, 2012 #6 I believe the sort function uses the code value of the character to sort. The character you have listed in your first post is an extended character and will not show first unless you remove it from the list, then sort the list and then insert this character in the first position. Upvote 0
I believe the sort function uses the code value of the character to sort. The character you have listed in your first post is an extended character and will not show first unless you remove it from the list, then sort the list and then insert this character in the first position.
NJDude Expert Licensed User Longtime User Feb 22, 2012 #7 sigster said: Yes COLLATE NOCASE don't work Click to expand... I haven't tested this but try: COLLATE BINARY Upvote 0
sigster said: Yes COLLATE NOCASE don't work Click to expand... I haven't tested this but try: COLLATE BINARY
