Re: remove gaps in a table

From: Thomas 'PointedEars' Lahn <PointedEars_at_web.de>
Date: Wed, 27 Dec 2017 21:32:36 +0100
Message-ID: <1817967.oMNUckLgyt_at_PointedEars.de>

J.O. Aho wrote:

> 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.

I did not.

> This is the way accounting works, so make it simpler for them to > understand things and you get a few nights of peace.

Nonsense.

-- 
PointedEars
Zend Certified PHP Engineer <http://www.zend.com/en/yellow-pages/ZEND024953>
<https://github.com/PointedEars> | <http://PointedEars.de/wsvn>
Twitter: _at_PointedEars2 | Please do not cc me./Bitte keine Kopien per E-Mail.

Received on Wed Dec 27 2017 - 21:32:36 CET