Bob Pawley wrote:
> Your missing the point.
>
> I am creating a design system for industrial control.
>
> The control devices need to be numbered. The numbers need to be
> sequential. If the user deletes a device the numbers need to regenerate
> to again become sequential and gapless.
How many control devices are there, and how often do deletes happen? If
there are only 30 devices, and deletes only happen on the order of one
per week, then you could simply run a delete trigger to renumber them.
--
Guy Rouillier