Hi.



Getting some strange behaviour for the ordering items for a IB_Query.



Ordering items set as follows:

DRSURNAME=DRSURNAME,FIRSTNAME;DRSURNAME DESC

Ordering Links

DRSURNAME=ITEM=1



Gives the following result:

COMBRINK WILHELM

CRONJE ANDRI

CRONJE DAWID

CRONJE JAN

CRONJE LOUW

CRONJE WILLIE

DABEK ELIZABETH

This is correct





When I Sort the column by clicking on the Grid Column Title to change the
sort order the result is as follows:

DABEK ELIZABETH

CRONJE WILLIE

CRONJE DAVID

CRONJE LOUW

CRONJE ANDRI

CRONJE JAN

COMBRINK WILHELM



The DRSURNAME column is correctly sorted in descending order, but the
DRFIRSTNAME not!

Changing the sort order to ascending will return a correctly sorted result
set.



IF I change the ordering items to:

DRSURNAME=DRSURNAME,FIRSTNAME;DRSURNAME,FIRSTNAME DESC



Gives the following result:

COMBRINK WILHELM

CRONJE ANDRI

CRONJE DAWID

CRONJE JAN

CRONJE LOUW

CRONJE WILLIE

DABEK ELIZABETH



This is correct



Now when I change the sort order, I get:

COMBRINK WILHELM

CRONJE WILLIE

CRONJE LOUW

CRONJE JAN

CRONJE DAWID

CRONJE ANDRI

DABEK ELIZABETH

The DRSURNAME column remains in ascending order, only the FIRSTNAMES are now
sorted correctly in Descending.



Please I must be doing something wrong with the Ordering items when using
more than one column to sort on.



Hope someone can help.



Regards



Adrian Wreyford



















[Non-text portions of this message have been removed]