Subject Re: [firebird-support] Doubt creating index
Author W O
Yes, of course, if column A is a primary key (or part of it) then should be
not updatable. But for the context I didn't understood it was a PK.

Greetings.

Walter.




On Thu, Feb 14, 2013 at 1:39 AM, Helen Borrie <helebor@...> wrote:

> **
>
>
> At 05:48 p.m. 14/02/2013, W O wrote:
> >So, Helen, if an index use the column A, then (ideally) the column A
> should
> >not be updatable?
> >
> >That's new for me.
>
> It is also a wrong take on what I said. "Column A" in this case is a field
> in the Primary Key. It is extremely poor design to have PK's that have
> updateable fields.
>
>
> Helen Borrie, Support Consultant, IBPhoenix (Pacific)
> Author of "The Firebird Book" and "The Firebird Book Second Edition"
> http://www.ibphoenix.com/products/books/firebird_book
> __________________________________________________________
>
>
>


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