At 11:17 AM 3/22/2002 +0100, Bernhard Doebler wrote:

>Hi,
>
>I want to use IBConsole against a Firebird database.
>When I want to list the Indexes I get the error "Ambigous filed name
>between table RDB$INDICES and table RDB$INDEX_SEGMENTS RDB$INDEX_NAME"
>
>Is there something left out in Firebird?

No, there's something wrong with IBConsole - big surprise. Firebird
now insists that ambiguous field names in a join be qualified. Both
RDB$INDICES and RDB$INDEX_SEGMENTS include a field called RDB$INDEX_NAME.
Firebird insists on knowing which value of RDB$INDEX_NAME should be
returned. In all likelihood, the comparison is
RDB$INDEX_NAME = RDB$INDEX_NAME, so the two values are the same.
However, at the point where the ambiguity is determined, the higher
level semantics of the query are unavailable.


Regards,

Ann
www.ibphoenix.com
We have answers.