- Posts: 37
- Thank you received: 3
- Forum
- CodeTyphon Studio
- CodeTyphon Studio Components and Libraries
- Database Development
- RxDBGrid, sorting (rdgAllowSortForm), PostgreSQL, mixed-cases field names
×
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
-
Less
More
2 years 2 months ago #14578
by tatamata
RxDBGrid, sorting (rdgAllowSortForm), PostgreSQL, mixed-cases field names was created 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,'"');
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
-
- Offline
- Moderator
-
- Ex Pilot, M.Sc, Ph.D
2 years 2 months ago #14581
by Sternas Stefanos
PilotLogic Architect and Core Programmer
Replied by Sternas Stefanos on topic RxDBGrid, sorting (rdgAllowSortForm), PostgreSQL, mixed-cases field names
Thanks Sir
PilotLogic Architect and Core Programmer
Please Log in or Create an account to join the conversation.