At 02:03 AM 15/11/2003 +0000, you wrote:

>I don't have any queries. All I have is Tables, Indexes,
>Generators, and Triggers.
>
>Could it be anything else?

The error isn't coming from your indexes, it's coming from the query that
is being submitted to the system tables to display your indexes. Let me
guess - you are using IBConsole? It has this known bug.

Helen

>--- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
><rrokytskyy@a...> wrote:
> > > I get the following error on our indexes for firebird. Does
>anyone
> > > know why?
> > >
> > > Dynamic SQL Error
> > > SQL error code = -204
> > > Ambiguous field name between table RDB$INDICES and table
> > > RDB$INDEX_SEGMENTS
> > > RDB$INDEX_NAME
> >
> > Firebird does not allow ambigous names in database queries anymore
>(IB
> > 6.0 allowed them). You have to correct your queries to avoid
>ambiguity:
> >
> > If your query was
> >
> > select rdb$index_name from rdb$indices a, rdb$index_segments b
>where...
> >
> > you have to change it to
> >
> > select a.rdb$index_name from ...
> > or
> > select b.rdb$index_name from ...
> >
> > Best regards,
> > Roman Rokytskyy
>
>
>
>To unsubscribe from this group, send an email to:
>Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/