Subject Re: [firebird-support] Select works, view fails
Author Dimitry Sibiryakov
Post date 2004-08-12T07:40:30Z
On 12 Aug 2004 at 5:47, mikcaau wrote:

>attempt to store duplicate value (visible to active transactions) in
>unique index "RDB$INDEX_15"*/
>
>What did I do wrong?

Use explicit list of names for output fields.

CREATE VIEW YourView (Name1, Name2, ....) and so on.

SY, Dimitry Sibiryakov.