Alan:

Alan McDonald escribió:

>> Thanks Alan.
>>
>> What this means: "the deleted records will not change the order of the
>> PK fields"? Shouldnt PK fields get updated at indexes as soon as they
>> have new values?
>>
>> Regards
>>
>
> once a record is deleted, the value of the PK is gone. The index will, of
> course be updated, but the order of the records does not change (barring the
> now omitted record).
> i.e. before delete, PK values 1, 2, 3, 4, 5, 6 etc. Now delete record PK=3.
> new order is 1, 2, 4, 5, 6 etc i.e. the order has not changed.
> Alan
>

That´s what I´ve tought. If after delete PK=3, I want 4 -> 3, 5 -> 4,
etc, why doesn´t "always" work? (It works most of times!).

--
Jorge Andrés Brugger
Informática
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Teléfono (0297) 446-4444 int. 103
Correo electrónico: jbrugger@...
Website: www.dasu.com.ar



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