I remember when you were working out of Chicago! That was fun working with you! Smart of you to go back "home" though.
Karen -----Original Message----- From: Albert Berry <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Fri, Mar 6, 2015 10:23 am Subject: [RBASE-L] - Re: SELECT COUNT I think I learned that trick from you when I was in Chicago a (few) years back. Albert On 3/6/2015 8:04 AM, Karen Tellef wrote: Oh lord if I had a penny for every SELECT COUNT(*) that's in my code, it would add up to make me a millionaire! I am a firm believer in adding "WHERE LIMIT = 1" so that it stops counting as soon as it hits one record if that's all you need to know. Karen -----Original Message----- From: Jim Belisle <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Fri, Mar 6, 2015 8:40 am Subject: [RBASE-L] - SELECT COUNT I use a lot of SELECT COUNT(*) codes to check if information is in tables for processing, especially if I am printing multiple reports within a WHILE ENDWHILE loop. Of course along with that would be IF THEN or CASE statements to determine whether to print a report. Is this the best and most efficient way to accomplish this task? I am just trying to make things faster and more efficient (and less likely to "Break" the code during processing). James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] -- A democracy ..." can only exist until the majority discovers it can vote itself largess out of the public treasury." Attributed to Alexander Fraser Tytler 1747-1813
