Hi,
I am using the Dev Express Quantum grid in grid mode and in order to sort I have to implement the sorting changed event and handle the sort there, this is not a problem and I have it working, but when I add a string to IndexFieldnames with multiple columns, it does not appear to sort properly when using text columns.
It says in the help that it will not sort blobs. I know a text field in some DBs si a blob, but does this also apply to text fields?
Ideas?
IndexFieldNames and multiple text columns
Hello
To resolve this issue we can propose you the following variants:
1. Ask Dev Express to support Blob sorting.
2. Wait while we support data mapping. In this case you will be able to choose Delphi data type (Blob, Memo or String) for the TEXT data type in PostgreSQL. We plan to implement it in approximately 2-3 months.
3. Use the following query:
Or text_value::varchar(2000) - depending on the max length of your text in TEXT field
To resolve this issue we can propose you the following variants:
1. Ask Dev Express to support Blob sorting.
2. Wait while we support data mapping. In this case you will be able to choose Delphi data type (Blob, Memo or String) for the TEXT data type in PostgreSQL. We plan to implement it in approximately 2-3 months.
3. Use the following query:
Code: Select all
select *, text_value::varchar(1000) from text_teable