Subject Re: error 204/indexes not working
Author alex_vnru
--- In ib-support@y..., "jonathanmfreedman" <jonathanmfreedman@h...>
wrote:
> i can't seem to make firebird work correctly...each time i set up a
> database i get this error when i click on the indexes symbol in
> ibconsole...what is going wrong?
>
> > Dynamic SQL Error
> > SQL error code = -204
> > Ambiguous field name between table RDB$INDICES and table
> RDB$INDEX_SEGMENTS
> > RDB$INDEX_NAME

Jonathan, this higly erronous tool use inside ambigious queries
(don't specify to which table RDB$INDEX_NAME is relevant). IB allows
to use such a queries and perhaps get wrong result, FB - not. Take
another, good, tool - free IB_WISQL or commercial IBExpert,
IBWorkbench, IBAdmin, EMS QuickDesk ...

Best regards, Alexander V.Nevsky.