Subject | Firebird 2.0 Curiosity |
---|---|
Author | dr_bentonquest |
Post date | 2006-12-07T21:39Z |
Hi there,
Table TAMACONT has one field only, field name is VALOR.
In Firebird 2.0,
SELECT VALOR,VALOR FROM TAMACONT ORDER BY VALOR
causes this error:
Undefined name.
Dynamic SQL Error.
SQL error code = -204.
Ambiguous field name between a field and a field in the select list
with name.
VALOR.
Same statement was working fine in Firebird 1.5.x. It does not affect
me at all but I thought it was worth mentioning it here.
Best Regards,
-Benton
Table TAMACONT has one field only, field name is VALOR.
In Firebird 2.0,
SELECT VALOR,VALOR FROM TAMACONT ORDER BY VALOR
causes this error:
Undefined name.
Dynamic SQL Error.
SQL error code = -204.
Ambiguous field name between a field and a field in the select list
with name.
VALOR.
Same statement was working fine in Firebird 1.5.x. It does not affect
me at all but I thought it was worth mentioning it here.
Best Regards,
-Benton