Subject | Re: [IBO] IB_Query Ordering Problems |
---|---|
Author | Paul Vinkenoog |
Post date | 2003-05-13T11:28:32Z |
Hi Kenneth,
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
> Thanks Paul, I will try this one out. By the way, do you know howThe SQLWhereItems are a lot different from the other SQLxxx properties.
> 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.
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