Subject | Re: [Firebird-Java] Re: How to get table alias from SQL for columns |
---|---|
Author | Roman Rokytskyy |
Post date | 2008-02-24T00:14:40Z |
> Thanks Roman for the answer. Can you tell me where can I register theI have bad news for you - at the moment I'm not able to get the table
> feature request?
alias for the column. I was confused by the new info constant in FB 2.1,
however it turns out that it is used for different purposes. So at the
moment 2.1.3 release won't have new method.
However, your issue is easily solved by using the column index - you can
use "select A.*, B.* from TABLE_A A left outer join TABLE_B on ....
order by 1, 3, 5". And this is probably even easier for you, since you
always know the column index when user clicks on the header.
Roman