--- In IBObjects@yahoogroups.com, "Alan McDonald" <alan@...> wrote:

>
> > I have an "SQL script presenter" that presents in a TIB_GRID the

data

> > arriving from an SQL script fed to a TIB_QUERY. I want to allow

the

> > grid columns to be ordered by clicking on the column titles.
> >
> > Using a script like "select field01 from table" there is no

problem. I

> > use grid.gridFields to get fields names like "field01" and feed

these

> > into the ordering properties of the query.
> >
> > Using a script like "select field01 as alias01 from table",
> > I need "field01" for the query ordering properties. So far I can
> > find "alias01" and have not found "field01". Any suggestions as

to how

> > to find "field01" from the existing grid or query properties or
> > methods?
> > Thanks
> >
> >
>
> not sure why you're using the word script and not query - so I am

not sure I

> understand completely..
> but since the query after executing will only ever return the

alias name and

> not the original field, you will have to parse the original

query.text

> yourself
> Alan
>

Hi Alan.
It might be that IBO internals have a record of the table.field
names. Yes I could parse the SQL entered; I was hoping to avoid
that. Thanks, Russell