| Subject | Re: [ib-support] error 204/indexes not working |
|---|---|
| Author | Nando Dessena |
| Post date | 2002-02-19T09:30:40Z |
Jonathan,
InterBase will let such select pass (and possibly return incorrect
results), whereas Firebird will stop it. There's nothing you can do
unless you dump (or modify and recompile) IBConsole. It should be a
trivial fix do apply.
BTW, given that IBConsole is based on IBX, and that IBX is not supposed
to support Firebird in the medium to long term, switching to a different
admin tool is a wise move anyway.
You can find rather complete lists of tools in www.interbase2000.org and
www.ibphoenix.com.
Ciao
--
____
_/\/ando
> > Dynamic SQL ErrorIBConsole is doing an ambiguous query to retrieve the index list.
> > SQL error code = -204
> > Ambiguous field name between table RDB$INDICES and table
> RDB$INDEX_SEGMENTS
> > RDB$INDEX_NAME
InterBase will let such select pass (and possibly return incorrect
results), whereas Firebird will stop it. There's nothing you can do
unless you dump (or modify and recompile) IBConsole. It should be a
trivial fix do apply.
BTW, given that IBConsole is based on IBX, and that IBX is not supposed
to support Firebird in the medium to long term, switching to a different
admin tool is a wise move anyway.
You can find rather complete lists of tools in www.interbase2000.org and
www.ibphoenix.com.
Ciao
--
____
_/\/ando