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.