Is it possible to re-arrange primary key sequence?

[beans]

Hello

I am facing a problem with my application when someone deletes a record and hence its key disappears breaking the sequence e.g

1 - entry
2 - entry
(3 - deleted no mere here)
4 - entry
5 - entry

When key is not there my AJAX application fails to run properly due to not finding next id.

Is there any method to re-arrange primary key values to a proper sequence when one or more numbers are missing?

So that I will write a query and whenever user deletes an item I will re-arrange the primary key sequence automatically.

Thanks in advance for giving your advise -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[bestguy]

Originally Posted by beans

When key is not there my AJAX application fails to run properly due to not finding next id.

There's the problem right there.
You need to redesign your application so that it does not rely on consecutive ids. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --