I don't have any queries. All I have is Tables, Indexes,
Generators, and Triggers.

Could it be anything else?

Thanks in advance

--- 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