Subject RE: [IBO] Sorting in a grid
Author Support List
Marcin & Set,

> > I use TIB_Grid.OnGetDisplayText to modify the text shown in some fields.
> When trying to sort, the underlying values of the field are used rather
> than the value I display and the sorting appears random to the user. How
> do I sort on the value I display rather than the value that is stored in
> the table?
> >
> > I think I'm asking more out of curiosity than necessity, in this
> particular case using a filter might be a good alternative to sorting, and
> that I can do easily.
> As far as I know the sorting is done via underlying IB_Query or similar
> IB_Dataset - IB_Grid is only used for displaying fields values. You
> might try declaring some calculated column and then add it to
> OderingItems...
> I don't know how it will work but...

The sorting is handled on the server. IBO has no client-side sorting
mechanisms. You would need to have a computed column or to have your select
statement provide the sorting you desire.