Subject | Re: [firebird-support] join and columns with the same name on diferent tables |
---|---|
Author | Alexandre Benson Smith |
Post date | 2004-04-06T19:57:27Z |
At 21:29 06/04/2004 +0200, you wrote:
SQL warning code = 204
-Ambiguous field name between table TABLE1 and table TABLE2
-NUMBER
and stops, don't return any row...
The others mentioned tools, don't show any message/warning/error and
returns wrong resultset.
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
----------
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.631 / Virus Database: 404 - Release Date: 17/03/2004
[Non-text portions of this message have been removed]
>I'm not sure, but I don't think the bug is in ISQL.ISQL reports it as a Warning.
>
>If ISQL reports ambiguitythingy (or whatever you write it),
>it's most probably an SQL WARNING instead of an error.
SQL warning code = 204
-Ambiguous field name between table TABLE1 and table TABLE2
-NUMBER
and stops, don't return any row...
The others mentioned tools, don't show any message/warning/error and
returns wrong resultset.
>Or does ISQL have parsing etc build in?Thank you very much for your time...
>
>With regards,
>
>Martijn Tonies
>Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
>Server.
>Upscene Productions
>http://www.upscene.com
>
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
----------
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.631 / Virus Database: 404 - Release Date: 17/03/2004
[Non-text portions of this message have been removed]