> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Florian Hector
> Sent: Saturday, 25 June 2005 4:27 PM
> To: IBObjects
> Subject: Re: [IBO] Novice need's help on IB_Grid ordering
>
>
> > I have a query with the following script
> > select pkey
> > ,afield
> > ,lkey
> > ,yesno
> > , (select lname
> > from ltable
> > where ltable.pkey=mtable.lkey) as lname
> > from mtable
> >
> > my question is there a way to set the ordeing on lname without ibo
> > responding with an error "SQl error -206 Column unknown"
> > I want the user to be able to search and sort on lname
> > Please help
>
> Instead of ...order by lname you can use ...order by 4 as lname is the
> 4th field of your query
>
> 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 !
>
> Yahoo! Groups Links
>
>
>
>
>
>
>