Subject | Re: [firebird-support] Ambiguous field name |
---|---|
Author | Helen Borrie |
Post date | 2005-07-07T01:21:23Z |
At 12:45 AM 7/07/2005 +0200, you wrote:
to extract info about the indices use ambiguous join syntax that is
accepted by InterBase and rejected by Firebird. Fair enough, IBConsole was
written for use with InterBase, not Firebird, and IB and Fb are NOT the
same DBMS,
Use a different DB tool.
./heLen
>Hello,It's an IBConsole problem. The queries over the system tables that it uses
>
>I've got the following error:
>
>Dynamic SQL Error
>SQL error code = -204
>Ambiguous field name between table RDB$INDICES and table RDB$INDEX_SEGMENTS
>RDB$INDEX_NAME
>
>What could be a reason for that problem?
>
>I'm connecting using IBConsole.exe 1.0.0.339 (this
>version that shows indexes) to Firebird 1.5.2.4731.
>
>How can I tack the field/index that cause the problem
>and how can I correct it?
>
>This problem exists even I import, export database.
to extract info about the indices use ambiguous join syntax that is
accepted by InterBase and rejected by Firebird. Fair enough, IBConsole was
written for use with InterBase, not Firebird, and IB and Fb are NOT the
same DBMS,
Use a different DB tool.
./heLen