Hi,

I'm using D7 with IBO 4.5Ai.

I'm seeing some strange behavior when using OrderingItems with
TIBOQuery.

I have everything setup in TIBOQuery for OrderingItems. And, I even
have an OrderingItemNo that is set. What I'm seeing is that the rows
are not sorted properly.

Here's an example of a result set that I'm getting when the field is
chosen for the OrderingItmeNo:

Field that corresponds to the OrderingItemNo
============================================
Canada
USA
Canada
USA
Canada
Canada
USA
USA
USA
USA

I get this result in design-time and in run-time, and even in the
"Edit Query" dialog in design-time.

But, with TIB_Query, everything is perfect, and works as expected.

If I put an ORDER BY clause for the same field directly in the query,
the result set is sorted as expected.

And, it doesn't matter what the refinement value is, the result is
still the same.

Did someone else also encountered this problem?

--
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)