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 lordif 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] <mailto:[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
