Subject | Actual field names |
---|---|
Author | russellbelding |
Post date | 2006-06-22T09:57:45Z |
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
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