IWETHEY v. 0.3.0 | TODO
1,095 registered users | 1 active user | 1 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New But they ordered integer quantities.
I would get a call at 11 PM - "This is store #23 - I need 6 flours (bags), 7 cheeses (bags), 5 peppers (bags), ..." It was all integers.

The dB would have a total of XXX.XX bags of flour in the warehouse that some nominal subtraction was done from, but that was integer items as well (though it was also a real in the dB).

Maybe they had to have the quantities as reals to do the division to get the average prices to 4-5 decimal places or something. I dunno. Nobody ever explained it to me. It just seemed funky to me and it seemed to invite data entry errors (I had to enter 10.00 for 10).

At least that's my fuzzy recollection. It was nearly 30 years ago now. (Sheesh!)

Cheers,
Scott.
New But can you explain this?
Decimal(5, 0) for surrogate key values in tables?
bcnu,
Mikem

It's mourning in America again.
New Nope. I never was a dB coder.
New It wouldn't have helped if you had been. ;0)
bcnu,
Mikem

It's mourning in America again.
New You *order* integer quantities, but stock on hand is fractional
Someone building the UI today would (obviously, I hope) not require entering the ".00" every time, but weren't greenscreen apps much more closely tied to the underlying data?
--

Drew
New My recollection is that it was a funky program.
I would often end up with totals that exceeded the listed stock in the warehouse. (Negative warehouse totals resulted.) It didn't seem to matter - I was told to ignore it. I gathered that whoever was in charge of ordering stuff for the warehouse had some different way of keeping track of what was needed and when (but it sorta made what I was doing kinda pointless as far as that goes).

¯\_(ツ)_/¯

Programs are weird sometimes. :-)

Cheers,
Scott.
     Subtle - (drook) - (12)
         We have AS400 databases with dozen upon dozen of those. Our RPG programmers refused to use Integer. -NT - (mmoffitt) - (10)
             Might make sense - (crazy) - (9)
                 Sounds vaguely familiar... - (Another Scott) - (7)
                     Why to do that for flour - (drook) - (6)
                         But they ordered integer quantities. - (Another Scott) - (5)
                             But can you explain this? - (mmoffitt) - (2)
                                 Nope. I never was a dB coder. -NT - (Another Scott) - (1)
                                     It wouldn't have helped if you had been. ;0) -NT - (mmoffitt)
                             You *order* integer quantities, but stock on hand is fractional - (drook) - (1)
                                 My recollection is that it was a funky program. - (Another Scott)
                 BCD and old mainfraimes. - (static)
         Saving space? - (scoenye)

Comfort the afflicted; afflict the comfortable.
63 ms