#40 RxDBGrid, sorting, Postgresql mixed-case fieldnames should be enclosed with double quotes

[Zlatko Matić]

Using rxdbgrid in CodeTyphon 7.10. Sorting for Postgresql database dataset with TSQLQuery is not working properly if field name contains mixed cases (lower and upper cases), because then fields names should be enclosed with double quotes.
I have temporarily solved this in unit exsortsql, in procedure TSQLQuerySortEngine.SortList, by replacing S:=S + ListField; with the S:=S + AnsiQuotedStr(ListField,'"');

[Zlatko Matić]

If I was not clear enough, I am talking about RxDBGrid's rdgAllowSortForm option.

[Zlatko Matić]

Additionaly, it fails also if in the SQL.Text property of an TSQLQuery there was an "order by" expression defined in design time.