Set the OrderingItemNo to 0 (zero) and it will default to whatever is in
your SQL and thus if there was no ORDER BY there, it will give you natural
order.

Jason Wharton
www.ibobjects.com

> -----Original Message-----
> From: Robert martin [mailto:rob@...]
> Sent: Monday, November 29, 2004 4:11 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] OrderingItems
>
>
>
> Hi
>
> I am using the orderingitems property of a TIBOQuery to
> provide ordering
> from our custom DBGrid component. Once an order item index
> is specified how
> can I deactivate the Index and return to the Std / No order
> (Without having
> to clear the order items)?
>
> I think I am missing something :)
>
> Rob Martin
> Software Engineer
>
> phone +64 03 377 0495
> fax +64 03 377 0496
> web www.chreos.com
> Wild Software Ltd
>