Not wishing to repeat Helen's recent response to the same question....

I think you will discover that the "bug" is in your SQL. Firebird will no
longer tolerate ambiguous column designators in joined datasets. Look for a
missing table identifier on one of your columns...

Bad SQL coding on behalf of the Tools writers, designers etc.

Regards
Paul Beach
Main Tel (UK):+44 (0) 1844 354465
Mobile: (UK): +44 (0) 7764 188603
http://www.ibphoenix.com
For all your upto date Firebird and
InterBase information

----- Original Message -----
From: <Marcos.Nobre@...>
To: <ib-support@yahoogroups.com>
Sent: Wednesday, October 10, 2001 4:38 PM
Subject: [ib-support] Strange Behaviour with some tools and Firebird Beta 2


> 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?
>
> TIA,
>
> MNobre.
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>