Devart Forums

Posted: **Tue 20 Dec 2011 20:04**

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?

Posted: **Thu 22 Dec 2011 11:03**

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:

Code: Select all

 select *,  text_value::varchar(1000) from text_teable

Or text_value::varchar(2000) - depending on the max length of your text in TEXT field

Devart Forums

IndexFieldNames and multiple text columns

IndexFieldNames and multiple text columns