Hi Rob,

> The change in syntax works great. However the numeric syntax you
> suggest fails to change the column sort order at all for me, which
> is sad because it would be my preferred method if it worked.

You mean referring to the columns by numbers? I just looked again at
your message and noticed that you use TIBOQuery etc., not TIB_Query. I
use the latter, maybe it simply doesn't work with the TIBO* strain.

One drawback of using column numbers is that if you change the SQL so
that columns move up or down, and you forget to change the
OrderingItems, you're in for some weird surprises ;-)


Greetings,
Paul Vinkenoog