| Subject | Re: error 204/indexes not working | 
|---|---|
| Author | alex_vnru | 
| Post date | 2002-02-18T19:28:49Z | 
--- In ib-support@y..., "jonathanmfreedman" <jonathanmfreedman@h...> 
wrote:
(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.
            wrote:
> i can't seem to make firebird work correctly...each time i set up aJonathan, this higly erronous tool use inside ambigious queries
> 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
(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.