> 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