| Subject | SQLOrder doesn't work |
|---|---|
| Author | stanw1950 |
| Post date | 2002-01-16T21:41:38Z |
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)
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)