--- In ib-support@y..., Marcos.Nobre@s... wrote:

> With my IBAdmin I try to view a database table definition (Fields,
> indexes,...) opening the fields entry on its treeview, when I am
> receiving :
>
> SQL Error code = -204
> "Ambiguous field name between table/view RDB$INDEX_SEGMENTS
> and table view RDB$FIELDS RDB$FIELD_NAME."
>
> I ALREADY MADE A BACKUP / RESTORE BUT THE PROBLEM CONTINUES.
>
> With IBConsole (1.0.0.339) I get the same problem when I ask for
> "show indexes" view on the Properties window of ANY table.
>
> Does anybody have some idea?
>

Well, idea is simply - last FB builds reject ambigious statements -
when tables in join have columns with the same names and
statement contain references to this columns without pointing table or
tables's alias. It's rational feature and brings FB more close to
SQL92 standard but some application (evidently IBAdmin and IBConsole
too) use such statements. It can be serious problem with this
feature and tools if tool designers will'nt react smartly.

Best regards.