> and (ib_query.Fields[ib_grid.DataCol[ACol]].FieldName
> = ib_query.OrderingField.FieldName)) then

This should be equivalent of using Index (since you are using the
index returned by the ib_grid.DataCol to get the fieldname anyway).

> but this got the same wrong result. Any more ideas? Thanks.

You could try:
ib_grid.GridFields[ACol].FieldName =
ib_query.OrderingField.FieldName

but I suspect you will continue to get the problem.

Can you send me your dfm (privately) so that I can try to setup a
similar query and grid and see what is happening. So far my
experiments using a simple query on the employee database seem to be
work well.


--
Geoff Worboys - TeamIBO
Telesis Computing