× Components and Libraries for Database Development, discussions, problems and suggestions

Question RxDBGrid, sorting (rdgAllowSortForm), PostgreSQL, mixed-cases field names

  • tatamata
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
1 year 7 months ago #14578 by tatamata
Using rxdbgrid in CodeTyphon 7.10.
RxDBGrid sorting option (rdgAllowSortForm) 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,'"');

Please Log in or Create an account to join the conversation.

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
More
1 year 7 months ago #14581 by Sternas Stefanos
Thanks Sir

PilotLogic Architect and Core Programmer

Please Log in or Create an account to join the conversation.