That should be COUNT and not COUNT(*)
Buddy
-Original Message-
From: Buddy Walker [mailto:walker.bu...@comcast.net]
Sent: Friday, October 6, 2017 2:24 PM
To: 'rbase-l@googlegroups.com' <rbase-l@googlegroups.com>
Subject: RE: [RBASE-L] - Select
Richard
You could use
Richard
You could use
SELECT * FROM tableName WHERE COUNT(*) >= someNumberHere
OR
SELECT colList INTO varList FROM tableName WHERE COUNT(*) >= someNumberHere
Buddy
-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
Did you know that your system clock (Date/Time) is years behind? Is
that by design, or
SELECT * FROM tableviewname name WHERE COUNT > nn
SELECT * FROM tableviewname name WHERE COUNT >= nn
Very Best R:egards,
Razzak
At 02:16 PM 5/6/2014, richard jasinski wrote:
I know there is a
Thanks we will give it a try.
Dan
-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
A. Razzak Memon
Sent: Friday, September 2, 2016 9:10 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - select in problem
At 10:35 AM 9/2/2016, Dan
At 10:35 AM 9/2/2016, Dan Goldberg wrote:
It works if the list is small but I guess there is a limit on the
number of items.
Change your holding variable to either NOTE or VARCHAR, as you see fit.
Very Best R:egards,
Razzak
--
You received this message because you are subscribed to the
You could be right!
Karen
-Original Message-
From: Dan Goldberg <d...@lancecamper.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Fri, Sep 2, 2016 9:35 am
Subject: RE: [RBASE-L] - select in problem
It works if the list is small but I guess there is a limit o
I never use that syntax. Too many times it has not evaluated the "(.vList)"
type of syntax.
Not sure if this fixes your particular issue, but my code would be:
set var vList = ( '(' + .vlist + ')' )
select ... cust_zip in
Karen
-Original Message-
From: Dan Goldberg
Bruce
Try adding a where clause
WHERE EvenCount > 0 AND EvenCount IS NOT NULL
Buddy
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
Bruce Chitiea
Sent: Tuesday, May 3, 2016 4:03 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Select
8 matches
Mail list logo