Re: How to increased by exactly 1 ?

I agree, there isn't any business purpose to do this. The requirement; as stated; says, "The
business rule is that the system should have an option to assign the lowest
next available Control Code for the new item created." Lowest, next available, is sequence folks. If you're multiuser, it's the way to go.
If you really try hard to have 1,2,3,4 etc, and someone deletes a row, what will happen
if you then have 1,2,4,5 etc? Received on Mon Jan 24 2005 - 10:16:40 CST