Subject Re: [firebird-support] Stored Procedure strange behaviour
Author Jorge Andrés Brugger

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
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@...

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