Subject Re: [ib-support] Ambiguous field name between table
Author Daniel Rail
At 04/30/2002 05:15 PM, you wrote:
>Hello all.
>I'm trying to pinpoint a DML code error in a script. The script
>executes without problem to build the db, but when I try to view
>indexes via IBConsole it gives me:
>Dynamic SQL Error
>SQL error code = -204
>Ambiguous field name between table RDB$INDICES and table

IBConsole has a bug, in regards with Firebird(not Interbase). It's doing a
query using multiple tables, but not specifying from which table a certain
field is supposed to come from. This is due to a bug correction in
Firebird 1.0. These type of queries have unpredictable results.

>However, IB_SQL has no problem showing all indexes for tables.

Jason made the correction(if one was needed) as soon as it was known.

Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (