Subject Re: [firebird-support] Can't create VIEW
Author Ivan Prenosil
> CREATE VIEW HISTORIAL
>
(FECHA,HORA,TRACTOR,CAROVAC,DESCRIP,NOMBRE,CONTROL,DESCRIP,NOMCORTO,NOMBRE,NOMBRE,OPERFORAN,OBSERVA,
STATUS)
> The error I get is this:
>
> This operation is not defined for system tables.
> unsuccessful metadata update.
> STORE RDB$RELATION_FIELDS failed.
> attempt to store duplicate value (visible to active transactions) in
> unique index "RDB$INDEX_15".

Column names must be unique (you have two times DESCRIP, three times NOMBRE)

Ivan