Sort on calculated field

Andrew Tumpac

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Sort on calculated field

Can a TClientDataSet sort on a calculated field? I get an "Index out of
range" error when I try to set the IndexFieldNames property to the name of a
calculated field. Basically, I bring back a string field, but need to sort
on the uppercase of that field's values. Don't want to do the Upper in SQL
and bring back extra data for the sake of network efficiency.

Thanks,
Andrew

Juan Jimene

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Sort on calculated field

I don't think this can be done. You'll have to resort to creating the
field in the SQL statement and sorting on that.

Quote

Andrew Tumpach wrote:

> Can a TClientDataSet sort on a calculated field? I get an "Index out of
> range" error when I try to set the IndexFieldNames property to the name of a
> calculated field. Basically, I bring back a string field, but need to sort
> on the uppercase of that field's values. Don't want to do the Upper in SQL
> and bring back extra data for the sake of network efficiency.

> Thanks,
> Andrew

Kevin Frever

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Sort on calculated field

Andrew,

If your wanting to sort from within a grid (user clicking on the desired
column), check out ExpressGrid. It has column sorting (ascending and
descending) built-in.

http://www.devexpress.com

Good luck,
krf

Quote

Andrew Tumpach wrote in message <7onboa$80...@forums.borland.com>...
>Can a TClientDataSet sort on a calculated field? I get an "Index out of
>range" error when I try to set the IndexFieldNames property to the name of
a
>calculated field. Basically, I bring back a string field, but need to sort
>on the uppercase of that field's values. Don't want to do the Upper in SQL
>and bring back extra data for the sake of network efficiency.

>Thanks,
>Andrew

Other Threads

1. Sort on calculated fields ?

2. Sorting by calculated fields

3. Sort a calculated field possible?

4. Sorting on Calculated fields - Delphi 1

5. Sorting on calculated fields

6. Sort on calculated fields...

7. Paradox table, sorting on calculated field

8. Sorting on calculated field issue

9. Calculated Fields (Calculated & Internal Calculated)

10. ADO: 'Sort'-Property and calculated Fields