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
>RDB$INDEX_SEGMENTS
>RDB$INDEX_NAME

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. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)