Florian,

Thank you so much for your detailed answer. I apprecieate it very much. My
real name is Mo. I will sign that on my future posts. Thanks for the heads
up.

Mo

""Florian Hector"" <FHector@...> wrote in message
news:b7hbd3$h08$1@......

> Stinky,
>
> seems you are running into the same problems I did some time ago. I don't
> know how much you know so far regarding the topic, therefore some basics:
> Once you are done with defining your query using the component editor,

click

> on the tab Ordering, click on Create and select the columns you want your
> query ordered by. Click OK and all the settings for OrderingItemNo,
> OrderingItems, and OrderingLinks are automatically defined. Thing is,
> ordering is only defined for one column at the time.
> Using your fields IDNumber, FirstName, and LastName, the query would be
> "Select IDNumber, FirstName, LastName from tabCustomers"
> After the steps in paragraph 1, OrderingItems would look like this:
>
> IDNumber=IDNumber
> FirstName=FirstName
> LastName=LastName
>
> and Ordering Links like this:
>
> IDNumber=ITEM=1
> FirstName=ITEM=2
> LastName=ITEM=3
>
> Now, if you want to order by IDNumber, LastName, FirstName, you manually

add

> these two fields to the first row so that it looks like this:
> IDNumber=IDNumber, LastName, FirstName
> FirstName=FirstName
> LastName=LastName
>
> OrderingLinks remains as it is.
>
> At runtime, you only have to set OrderingLinks to the desired value and

the

> query will be reorderd, e.g qryCustomers.OrderingLinks := 1
>
> One more thing unrelated to your question. It would be nice if you

provided

> a real name, some people here on the list don't bother answering if they
> have to deal with nameless people.
>
> Florian
>
>
>
>
>

___________________________________________________________________________

> IB Objects - direct, complete, custom connectivity to Firebird or

InterBase

> without the need for BDE, ODBC or any other layer.
>

___________________________________________________________________________

> http://www.ibobjects.com - your IBO community resource for Tech Info

papers,

> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>