Drew Wutka
DWUTKA at marlow.com
Fri Feb 14 18:27:00 CST 2003
It's kind of odd that this has come up, right after Darren's thread of a scheduler. I started writing a scheduler that stored time slots as numbers. You break the time slots down to be represented by the bits in a number. Thus, for any given day, an appointment only takes up one record. And to 'replicate' that same appointment, you can use a bitmask scheme to determine if the appoint is repeated. I am going to incorporate it into my new MiniCalendar, so I guess I'll have to demo it then. Drew -----Original Message----- From: Brett Barabash [mailto:BBarabash at tappeconstruction.com] Sent: Friday, February 14, 2003 4:05 PM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] OT: Programming Logic Bit logic is pretty handy. AND, when applied to 2 numerical arguments, returns the common bits between the two. For example, using your 84 example, type in the Debug window: ?84 And 1 0 ?84 And 2 0 ?84 And 4 4 ?84 And 8 0 ?84 And 16 16 ?84 And 32 0 ?84 And 64 64 Based off of our above process, we have determined that 84 consists of 4+16+64. One area where this came in handy was with my lightweight security code, which had an inherent many->many relationship. One form can be available to many groups, and one user may be a member of many groups. I needed to determine if there was a "hit" between the user's security credentials and the authorized groups. For example, if I had the following groups: 1: Managers 2: Sales 4: HR 8: Accounting I might want to say that the form is only available to Accounting and Managers, so it has a security level of 1+8=9. Take the HR manager, for example. They would have a security level of 1+4=5. Now, I said earlier that AND returns back the common bits, so if it returns a non-zero value, we have a hit: ?9 And 5 1 The HR manager isn't part of Accounting, but can view the form because they are a manager! Normally I wouldn't go into this much detail, but I have explained my security code to coworkers about 3 times, so it's become kinda second nature to me by now... -----Original Message----- From: Jim DeMarco [mailto:Jdemarco at hshhp.org] Sent: Friday, February 14, 2003 2:53 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] OT: Programming Logic Joe, this came up while back so you'll probably find the answer in the archives. HTH, Jim DeMarco Director of Product Development HealthSource/Hudson Health Plan -----Original Message----- From: Joe Rojas [mailto:JRojas at tnco-inc.com] Sent: Friday, February 14, 2003 3:27 PM To: 'accessd at databaseadvisors.com' Subject: [AccessD] OT: Programming Logic Hi All, I have seen in a couple of programs that use flags to set options that work by giving a "binary" value, if you will, to each setting. For example, the first setting has the value 1, the second 2, then 4, 8,16,32,64,etc. Then it will add up the values of the settings that have been turned on. So if the 3rd, 5th, and 7th settings were turned on the value would be 84 (4+16+64). The totaled value generated would be unique, i.e. no two combinations of settings would produce the same totaled value. Here is the part that I get stumped on...how would one program a function that would take a totaled value and "break it up" into the individual values that made it up? For example, if given the value 84, it would "break it up" as 4, 16, and 64. Any ideas would be appreciated. Thanks, Joe Rojas This electronic transmission is strictly confidential to TNCO, Inc. and intended solely for the addressee. It may contain information which is covered by legal, professional, or other privileges. If you are not the intended addressee, or someone authorized by the intended addressee to receive transmissions on behalf of the addressee, you must not retain, disclose in any form, copy, or take any action in reliance on this transmission. If you have received this transmission in error, please notify the sender as soon as possible and destroy this message. While TNCO, Inc. uses virus protection, the recipient should check this email and any attachments for the presence of viruses. TNCO, Inc. accepts no liability for any damage caused by any virus transmitted by this email. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com **************************************************************************** ******* "This electronic message is intended to be for the use only of the named recipient, and may contain information from HealthSource/Hudson Health Plan (HS/HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HS/HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". **************************************************************************** ******* _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com