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.