Topic: Sort by National Charset, Button background color,

Hi,

a)
i think is a good idea to write here some help with sorting Table grid by National charset.
because now keys like Č or Š is on the last places.

b)
is posible to set Button background color ?

Thx,

K.

Re: Sort by National Charset, Button background color,

I already asked question b and answer was negative smile

Re: Sort by National Charset, Button background color,

b)
Just with picture under Button big_smile ...but it is working

4 (edited by tcoton 2015-09-07 14:49:41)

Re: Sort by National Charset, Button background color,

Oh! yikes

I would like to see a screenshot of your method since I tried with no luck! My buttons are still grey!

Re: Sort by National Charset, Button background color,

This is the easiest way how to do it :

procedure Form1_OnShow (Sender: string; Action: string);
begin
               Form1.Image2.cursor := crHandPoint;
end;

procedure Form1_Image2_OnClick (Sender: string);
begin
               Form1.Button15.Click();
end;

Than you can make invisible all buttons and replace it with some image.

I sending screenshot.

Post's attachments

Attachment icon Capture1.JPG 108.15 kb, 331 downloads since 2015-09-08 

Re: Sort by National Charset, Button background color,

But the question a) is the largest problem i dont see there any solution.

Nobody has some great idea ? how can i sort Table grid by National charset.?

Thx,

K.

Re: Sort by National Charset, Button background color,

I was pretty sure the button trick was not as straight forward as it seems smile Thanks for the tip.

What about the "Localized" option in SQL Query? http://stackoverflow.com/questions/1324 … abetically


SELECT column1, Column2 FROM Table ORDER BY column1 COLLATE LOCALIZED ASC

Re: Sort by National Charset, Button background color,

Hi,
i try this COLLATE before i writing here. But not working.
Maybe i just must try it again and again.
Thx for help big_smile

I go testing now !

K.

Re: Sort by National Charset, Button background color,

krokodil_sk
In the current version is not possible, sqlite by default sorts only by ascii letters.
Need some improving to sort unicode symbols.

Dmitry.

10 (edited by tcoton 2015-09-08 13:45:33)

Re: Sort by National Charset, Button background color,

I found this which confirms the lack of Unicode management (utf) in SQLite http://forums.devart.com/viewtopic.php?t=18222
alongside this http://site.icu-project.org/