These are my ordering items generated by IBO:
STOCKCODENO=STOCKCODENO;STOCKCODENO DESC
LINKTOSTONEGROUP=LINKTOSTONEGROUP;LINKTOSTONEGROUP DESC
LINKTOSTONEDESC=LINKTOSTONEDESC;LINKTOSTONEDESC DESC
LINKTOSTOCKTYPE=LINKTOSTOCKTYPE;LINKTOSTOCKTYPE DESC

these are the ordering links generated by IBO:
STOCKCODENO=ITEM=1
LINKTOSTONEGROUP=ITEM=2
LINKTOSTONEDESC=ITEM=3
LINKTOSTOCKTYPE=ITEM=4

Now my computed field for IB_LookupCombo and aliased in the full select
creates fields of
LUSTONEGROUP
LUSTONEDESC
LUSTOCKTYPE
instead of
LINKTOSTONEGROUP
LINKTOSTONEDESC
LINKTOSTOCKTYPE

So I just edit the ordering links to the lines below and I get the correct
sorting (ordering)

STOCKCODENO=ITEM=1
LUSTONEGROUP=ITEM=2
LUSTONEDESC=ITEM=3
LUSTOCKTYPE=ITEM=4

But if I want to add another field and change or add to the ordering, I need
to wipe/clear all these out, get IBO to generate them again with the
addition then edit the field names in te ordering links back to my computed
fields

Hope that's clear enough? tell me if not
Alan

> -----Original Message-----
> From: Gerard J.M.Houtenbos [mailto:gh@...]
> Sent: Sunday, 8 December 2002 21:58
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Ordering Items
>
>
> I don't know exactly what you mean. Can you give us an example?
>
> tia,
>
> Gerard
>
> On Sun, 8 Dec 2002 13:37:57 +1100, you wrote:
>
> >actually I have found that if you get IBO to generate the items
> based on the
> >key source, you can then edit the ordering links description to
> reflect the
> >computed field. It worls OK but if yo change the query (ordering
> items) you
> >have to clear them and start again.
> >Alan
> >
> >> -----Original Message-----
> >> From: Paul Vinkenoog [mailto:paulvink@...]
> >> Sent: Sunday, 8 December 2002 13:36
> >> To: IBObjects@yahoogroups.com
> >> Subject: Re: [IBO] Ordering Items
> >>
> >>
> >> Hi Alan,
> >>
> >> > How do you setup the ordering items where the columns are lookup
> >> > computed fields with IB_LookupCombo controls?
> >> > Ordering on the real field (key) does not activate the title
> >> > ordering, and ordering on the computed field causes a column unkown
> >> > error
> >>
> >> You can use the 1-based column number. If you have IBO generate the
> >> ordering items at design time it produces the field name but alas, at
> >> run time this gives you the field unknown error. Hope this will change
> >> someday - especially since column names tend to stay the same whereas
> >> column positions may change as you develop the query...
> >>
> >> Greetings,
> >> Paul Vinkenoog
> >>
> >>
> >>
> >> __________________________________________________________________
> >> _________
> >> 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/
> >>
> >>
> >>
> >
> >
> >
> >
> >_________________________________________________________________
> __________
> >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/
> >
>
> _________________________
>
> Gerard J.M. Houtenbos
> DoubleWood Software
>
>
> __________________________________________________________________
> _________
> 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/
>
>
>