Subject SQLOrder doesn't work
Author stanw1950
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)