Thanks Martijn.

The problem was other: I had a FB 2.1 fbclient.dll (windows\system) and I
was trying to create view in a 2.0.1 engine. That´s all ... (but, could this
be a bug? Shouldn´t be fbclient.dll backward compatible?)

Regards!


2007/8/10, Martijn Tonies <m.tonies@...>:

>
> Jorge,
>
> If you don't supply column names for the views columns, Firebird
> will attempt to create some of its own, by using your resultset.
>
> If any of these name is a duplicate (eg, an column ID in 2 tables),
> you will get this somewhat weird error.
>
> Martijn Tonies
> Database Workbench - development tool for Firebird and more!
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
> I want to create a new view, and I´m getting the following error:
>
> unsuccessful metadata update.
> STORE RDB$RELATION_FIELDS failed.
> attempt to store duplicate value (visible to active transactions) in
> unique
> index "RDB$INDEX_15".
>
> ¿What it means? view name is unique ...
>
> Using FB 2.0.1
>
> Thanks
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>

[Non-text portions of this message have been removed]