Subject Re: [IBO] IB_Query Ordering Problems
Author Paul Vinkenoog
Hi Kenneth,

> Thanks Paul, I will try this one out. By the way, do you know how
> to do the same thing using SQLOrder? I do the same thing as shown in
> GSG but without using the SQLWhereItems and I always get the Invalid
> Token Error.

The SQLWhereItems are a lot different from the other SQLxxx properties.

Properties like SQLOrder, SQLWhere, SQLHaving etc. contain the entire
clause including the keyword. So you have to set SQLOrder like this:

MyQuery.SQLOrder.Text := 'ORDER BY ARTNO, SIZE, PRICE';

or in BCB (don't remember what you use, yesterday's messages on other
OS ;-)) :

MyQuery->SQLOrder->Text = "ORDER BY ARTNO, SIZE, PRICE";


HTH,
Paul Vinkenoog