Hi,
Well I didn't reply because I agreed with Fred.

I reviewed the spec and javadocs, and my conclusion is that the spec does
not define the behaviour except in the case of a query on one table with no
calculated or aliased columns. Even then it doesn't really define the
behaviour expected. So I think relying on any specific behavior in a tool
will result in unpredictable behavior across databases.

I think the spec is not very well thought out. It says getXXX(colname) can
be fed either name or label which can't work with aliases:

select col1 as col2, col2 as col1 from mytable m;
unless getXXX("col1") and getXXX("col2") both retireve the first column.

There are hints that colname refers to underlying column name in the
relation referred to, with table and schema name removed, if you retrieve
it with getCoumnName(index)

The only other resource to consult I can think of is the cts. Have you
looked at it? Pointers to tests there would be appreciated.

david jencks

On 2001.05.23 03:22:59 -0400 Dietrich Schulten wrote:
> Hi Fred,
>
>
> > This is the third post in which I've said the
> > same thing and that's just about enough.
>
> Well, I didn't ask you alone but wanted to hear other people's opinions,
> too.
> I'm still not convinced that this shouldn't be solved on the driver
> level, but I think I'll leave Interclient alone for now.
>
> Greetings,
> Dietrich
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> IB-Java-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>