Thanks for all the info and idears (as senior would say). On the Arrays, do you have a decent site I could visit? I am very array challenged. I don't mind updating the code every time I update the array.
Thanks. Brian Bennett Affinity Health Systems Systems Analyst PBS\Clinic Billing (920)628-9055 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] Sent: Friday, February 20, 2009 11:50 AM To: [email protected] Subject: [talkbws] RE: Whats better than Select Case? In vb a select case statement is much more efficient than a series of If Then statements. You can create arrays in vb which should be slightly more efficient than select case if the program was running continuously for a considerable time. The difference would be negligible unless you had hundreds or thousands of values. Both select case or an array is much more efficient that opening a text file and reading values from it. The main benefit of the text file, it is easier to maintain if values will be added, removed or changed on a regular basis. The difficulty with either select case or an array is that if values must be added, removed or changed the program must be updated and recompiled. Thus one must analyze will the values change often and if so who will maintain it, a programmer or end user? If they won't change often (or maybe even if they will) is program efficiency more important than ease of administration? My 2 pennies worth. -- Bill Palmer Financial Systems Analyst Mid-Columbia Medical Center The Dalles, OR 97058 541-296-7417 CONFIDENTIALITY NOTICE: This e-mail message (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, and is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any unauthorized review, use, disclosure, dissemination, copying, forwarding or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are the intended recipient but do not wish to receive communication through this medium, please advise the sender immediately. --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may contain confidential and privileged information for the use of the designated recipient(s) named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify the sender at the electronic mail address noted above and destroy all copies of this communication and any attachments. Thank you for your cooperation. --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
