Welcome, Guest
Username: Password: Remember me
Components and Libraries for Database Development, discussions, problems and suggestions
  • Page:
  • 1

TOPIC:

RxDBGrid, sorting (rdgAllowSortForm), PostgreSQL, mixed-cases field names 4 years 8 months ago #14578

  • tatamata
  • tatamata's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 37
  • Thank you received: 3
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.

RxDBGrid, sorting (rdgAllowSortForm), PostgreSQL, mixed-cases field names 4 years 8 months ago #14581

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
  • Posts: 4538
  • Thank you received: 1116
Thanks Sir
PilotLogic Architect and Core Programmer

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

  • Page:
  • 1