RE: Normalization was Left AS/400 and Returned

Good idea's all.

James, that would generally work.  But sometimes work plays games with 
holidays.  Let's say that I scheduled the week of December 20-23 of 2004 
off because the Christmas holiday would have been on that Friday.  Bang, 
less than a month prior, they move the holiday to Monday.  Now, because of 
the different customers they serve, and when those customers take their 
holiday, your plants go all willy-nilly with some taking Friday and some 
taking Monday.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





James Rich <james@xxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
05/04/2005 04:00 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Subject
RE: Normalization was Left AS/400 and Returned






On Wed, 4 May 2005, Joe Pluta wrote:

> For anyone else, I'll make the question a little more specific: a file
> holds maintainable calendar information (let's say for multiple
> warehouses), and the information in question is simply a flag that says
> whether the warehouse is open that day or not.  The data is stored in a
> file because ... well, because that's where everybody except Rob stores
> user-modifiable data.
>
> Would you store the data one flag per warehouse/date, with the warehouse
> and date as the keys to the file, or would you store the information in
> an array, perhaps by year or by some other arbitrary unit of time?

Neither.  I'd find out what the rules are for when it is open/closed and 
code those rules.  No file/table needed.  In fact, I've already done this.

James Rich

It's not the software that's free; it's you.
                 - billyskank on Groklaw
-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.