List:General Discussion« Previous MessageNext Message »
From:Stut Date:September 18 2008 8:58am
Subject:Re: Finding gaps
View as plain text  
On 18 Sep 2008, at 07:45, Joerg Bruehe wrote:
> Stut schrieb:
>> On 17 Sep 2008, at 22:12, Jerry Schwartz wrote:
>>> I have records that should be sequentially (not auto-increment)  
>>> numbered,
>>> but there are gaps. Is there any elegant way of finding the gaps?
>> Why do they need to be sequential? When this requirement comes up  
>> it's
>> usually for illogical reasons.
> I don't know his application,
> but I do remember a similar requirement caused by some German rules on
> bookkeeping which demanded that booking numbers were assigned  
> without gaps.
> That law may be illogical, but for the DB application designer this
> doesn't help - s/he has no choice but to follow it.

Autonumber will accomplish that, so long as you don't delete any. And  
if you do, renumbering the bookings would cause more problems than it  

This reminds me of when my parents used to make me account for every  
cheque I'd written, and they did it by ensuring I had a reason for  
each sequentially numbered cheque in the cheque book. Any I had  
written and then destroyed had to be marked as destroyed - it  
couldn't actually be missing!! I see the same issue here and the same  
solution works.


Finding gapsJerry Schwartz17 Sep
  • Re: Finding gapsStut17 Sep
    • Re: Finding gapsPeter Brawley17 Sep
      • RE: Finding gapsJerry Schwartz8 Oct
        • Re: Finding gapsGerald L. Clark8 Oct
          • RE: Finding gapsUS Data Export8 Oct
        • Re: Finding gapsPeter Brawley8 Oct
          • RE: Finding gapsUS Data Export9 Oct
            • Re: Finding gapsPeter Brawley9 Oct
              • RE: Finding gapsJerry Schwartz10 Oct
                • Re: Finding gapsMoon's Father25 Oct
                  • Re: Finding gapsMoon's Father25 Oct
                  • RE: Finding gapsUS Data Export27 Oct
    • RE: Finding gapsJerry Schwartz17 Sep
      • Re: Finding gapsStut18 Sep
        • Re: Finding gapsMr. Shawn H. Corey18 Sep
        • RE: Finding gapsJerry Schwartz18 Sep
          • Re: Finding gapsMike Diehl18 Sep
            • RE: Finding gapsJerry Schwartz18 Sep
    • RE: Finding gapsMartin Gainty18 Sep
      • RE: Finding gapsJerry Schwartz18 Sep
    • Re: Finding gapsJoerg Bruehe18 Sep
    • Re: Finding gapsJoerg Bruehe18 Sep
      • Re: Finding gapsStut18 Sep
        • Re: Finding gapsMr. Shawn H. Corey18 Sep