This is an IBConsole thing. I forgot that I'd downloaded version
1.0.0.339 a few days ago.

I hadn't noticed that this new version has a new treeview table
branch for indexes. Previous versions didn't have this, as I
recall. I just checked my verion 1.0.0.320 and yes, that's the case.

So perhaps this new feature that Jeff added only works with IB. Or
perhaps it's still buggy. Going into the tables and viewing indexes
from there also causes the error message. Perhaps Jeff is giving FB
a sneaky 'Fork you' message. Who knows.

In my defense, I do use IB_SQL, but IBConsole is my comfy hammock for
when I'm feeling lazy.

Regards
Andrew Ferguson
-- Our dazzling special effects conceal the absence of a plot.

--- In ib-support@y..., "csswa" <csswa@y...> 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
>
> However, IB_SQL has no problem showing all indexes for tables.
>
> One thing I'd like to check is:
>
> ADD CONSTRAINT ACT_PARENT_FK
> FOREIGN KEY (ACT_PARENT_FK) REFERENCES T_ACTION (ACT_PK)^
>
> Is there a problem giving a constraint the same name as an existing
> field?
>
> Regards,
> Andrew Ferguson
> -- Finding work for idle hands.