Razzak: Thank you for the clear 'splainin'.
Just another of R:BASE turning the most tortured logic into 'child''s play', in two flavors. Superb work, Dr. Memon. Thanks, and Cheers! Bruce -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Saturday, January 31, 2015 10:59 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Performance: IF/ELSE/ENDIF v SWITCH/ENDSW At 01:02 PM 1/31/2015, Bruce A. Chitiea wrote: >I've successfully coded the same critical piece of a tiny, single user >development database both ways. > >In your experience, are there any performance advantages for one over >the other, were this a live, monster, multi-user database? Bruce, Technically, the SWITCH statement is a control statement that handles multiple selections by passing control to one of the CASE statements within its body. The SWITCH statement allows the developer to control the order in which the codes are executed because it is a "conditional" statement. Nested "IF statement" can be rewritten as one SWITCH statement. The SWITCH and CASE keywords evaluate expression and execute any statement associated with constant-expression whose value matches the initial expression. Last but not least, to optimize the code, ALWAYS type the BREAK keyword at the end of each condition otherwise the compiler will execute every 'CASE' statement even if only one condition is met. Have fun! Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 32 years of continuous innovation! 17 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
