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 Go

RE: [RBASE-L] - select in problem

2016-09-02 Thread Dan Goldberg
It works if the list is small but I guess there is a limit on the number of items. Dan Goldberg From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Friday, September 2, 2016 6:52 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - select in problem I never use that

Re: [RBASE-L] - select in problem

2016-09-02 Thread karentellef via RBASE-L
You could be right! Karen -Original Message- From: Dan Goldberg To: rbase-l 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 on the number of items. Dan Goldberg From: karentellef via

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 &vList Karen -Original Message- From: Dan Goldberg T