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
> 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.

Andrew Ferguson
-- Diagonally parked in a parallel universe.