But they ordered integer quantities.

Post #423,328 by Another Scott 4/12/18 10:56:40 PM 4/12/18 10:56:40 PM Reply	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.
Post #423,333 by mmoffitt 4/13/18 8:10:07 AM 4/13/18 8:10:07 AM Reply	But can you explain this? Decimal(5, 0) for surrogate key values in tables? bcnu, Mikem It's mourning in America again.
Post #423,335 by Another Scott 4/13/18 8:16:04 AM 4/13/18 8:16:04 AM Reply	Nope. I never was a dB coder.
Post #423,338 by mmoffitt 4/13/18 9:31:44 AM 4/13/18 9:31:44 AM Reply	It wouldn't have helped if you had been. ;0) bcnu, Mikem It's mourning in America again.
Post #423,336 by drook 4/13/18 9:11:47 AM 4/13/18 9:11:47 AM Reply	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
Post #423,341 by Another Scott 4/13/18 11:11:22 AM 4/13/18 11:11:22 AM Reply	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.

Welcome to IWETHEY!