Re: Non-skipping IDs with Master-Detail


In many accounting and invoice apps, ID numbers cannot skip. I
have done a few apps like this without problems using other
programming tools such as VB and Powerbuilder. I just don't
understand why this is so complicated with Delphi. I'm
probably missing something and I would like to know what.

By the way, in most applications, orders cannot be deleted..
just cancelled. And cancelling each and every order simply
because the user aborts the entry is definetely not good
practice.


"Kevin Frevert" <kevin@xxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>"Michelle Brennan" <mibi222@xxxxxxxxxxx> wrote in message
>news:435c5b05$1@xxxxxxxxxxxxxxxxxxxxxxxxx
>> This is a common real world situation, where order numbers
>> must not skip
>
>Why can't the numbers skip?
>
>>
>> It is so frustrating to know that a simple task like this is
>> so complicated to implement in Delphi!!! Or am I missing
>> something??
>
>This issue has nothing to do with Delphi. Sounds like you are letting
>non-technical users make technical decisions. There are a lot 'what if'
>situations where gaps will happen, like what if the order has to be deleted?
>My advice is to let the numbers 'skip'.
>
>Good luck,
>krf
>
>

.