> I'm using a tib_query and in the preparesql procedure I use
> SQLWhereItems and SQLOrder. The SQLWhereItems works fine but the
> SQLOrder doesn't. The statement is SQLOrder.Add('IT.ITEMID') and
> whenever I use it I get an SQL error 104 - token unknown 'IT' when
> the program runs. (It also doesn't work if I take out the 'IT.'.) The
> sql monitor dialog shows no 'order by'. The statement seems pretty
> straightforward, at least it is in the getting started guide. What am
> I doing wrong? This is the first time that I've tried SQLOrder.
> (Delphi 6, IBO 4.2fn)

You are using the SQLOrder property incorrectly.

Use the OrderingItems and OrderingLinks properties in conjunction with the
OrderingItemNo property.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com