Subject Re: Ambiguous field name between table
Author csswa
--- In ib-support@y..., Daniel Rail <daniel@a...> wrote:
> IBConsole has a bug, in regards with Firebird(not Interbase). It's
doing a
> query using multiple tables, but not specifying from which table a
certain
> field is supposed to come from. This is due to a bug correction in
> Firebird 1.0. These type of queries have unpredictable results.
> >However, IB_SQL has no problem showing all indexes for tables.

The thing was, the slightly older version of IBConsole that I was
using up until a day or two ago -- that had no problems. I've been
running FB1.0 for quite a while now. Jeff must be using the old
buggy select method in the left treeview pane where he's added the
new index branch.

Thanks for the info, Daniel.

Regards,
Andrew Ferguson
-- Diagonally parked in a parallel universe.