Subject Re: [ib-support] Firebird vs. IBConsole
Author Christian G├╝tter
Hi Bernhard,

you wrote:
> 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"

AFAIK IBConsole cannot be used with FB 1.0.

FB rejects ambigous field names in queries, IB does not.
The Firebird developers and users decided to reject these
queries because it cannot be guaranteed that the result of
these queries is always OK/always the same.

IBConsole uses ambigous queries for the system tables, so
it won't work until someone forks IBConsole. The person
maintaining IBConsole, a TeamB member, has already stated
that he won't do this (I don't know this for sure, I just
read it somewhere).

So it would be better if you look for another tool.
IB_SQL of Jason Wharton (www.ibobjects.com) is quite
nice - and I guess it works with FB 1.0 (others may
correct me).


With regards,

Christian