At 09:19 AM 28/04/2005 +0200, André Destal wrote:

>Hi,
>when a SELECT statement uses an alias named "field2" as first column,
>firebird reports an error:
>"A component named Field2 already exists"
>
>e. g.:
> select id as field2
> , code as field3
> from t_invline
>
>doesn't work, while
>
> select id as field1
> , code as field2
> from t_invline
>
>works fine, as it does, when the aliases don't start with 2:
>
> select id as field3
> , code as field2
> from t_invline
>
>works fine too.
>
>I've tested it with firebird 1.0 on win2k and firebird 1.5 on linux/fedora3.

I can't reproduce this on Windows or Linux, testing with isql and with IB_SQL.

The message "A component named Field2 already exists" is not a
Firebird/database engine message. Could it be that your alias somehow
duplicates some structure that you have already set up in your application?

./heLen