Re: remove gaps in a table
From: J.O. Aho <user_at_example.net>
Date: Thu, 21 Dec 2017 19:38:53 +0100
Message-ID: <fa2ddtF5jivU2_at_mid.individual.net>
>
> It is infinitely easier and makes much more sense to have a field that says
> “if I have a certain value, this order was made but canceled later”. And
> that is what is usually done. Usually the type of that field is BOOLEAN or
> INT.
You missed the other thread.
Date: Thu, 21 Dec 2017 19:38:53 +0100
Message-ID: <fa2ddtF5jivU2_at_mid.individual.net>
On 12/21/17 19:00, Thomas 'PointedEars' Lahn wrote:
> J.O. Aho wrote:
>
>> For you if you want completely gapless order numbers, don't delete, when >> an order is "deleted", you generate a new order which is the complete >> opposite of the original order, […]
>
> It is infinitely easier and makes much more sense to have a field that says
> “if I have a certain value, this order was made but canceled later”. And
> that is what is usually done. Usually the type of that field is BOOLEAN or
> INT.
You missed the other thread.
This is the way accounting works, so make it simpler for them to understand things and you get a few nights of peace.
-- //AhoReceived on Thu Dec 21 2017 - 19:38:53 CET