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