RE: [RBASE-L] - Select

2017-10-06 Thread Buddy Walker
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

RE: [RBASE-L] - Select

2017-10-06 Thread Buddy Walker
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

Re: [RBASE-L] - Select

2017-10-06 Thread A. Razzak Memon
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

RE: [RBASE-L] - select in problem

2016-09-02 Thread Dan Goldberg
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

RE: [RBASE-L] - select in problem

2016-09-02 Thread A. Razzak Memon
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

Re: [RBASE-L] - select in problem

2016-09-02 Thread karentellef via RBASE-L
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

Re: [RBASE-L] - select in problem

2016-09-02 Thread karentellef via RBASE-L
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

RE: [RBASE-L] - Select Statement Divide by Zero Errors

2016-05-03 Thread Buddy Walker
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