You are right, bad reading, he says "composite primary key", sorry.

Greetings.

Walter.

On Thu, Feb 14, 2013 at 3:13 AM, W O <sistemas2000profesional@...>wrote:

> 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]