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
__________________________________________________________________