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:[email protected]] Sent: Friday, September 2, 2016 6:52 AM To: [email protected] Subject: Re: [RBASE-L] - select in problem 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 <[email protected]<mailto:[email protected]>> To: rbase-l <[email protected]<mailto:[email protected]>> Sent: Fri, Sep 2, 2016 8:47 am Subject: [RBASE-L] - select in problem I have a selection form that selects zip codes on a map. Then I set it to view the inquiries in the selected zip codes. select * from inquiry where InquiryDate bet 1/1/2014 and 12/31/2014 and cust_zip in (.vlist) If the user selects too many zipcodes I get the error. ERROR- Syntax is incorrect for the command -ERROR- More than 10000 characters or 400 items on input line ( 14) (2045) I have been thinking of a way around this but I am drawing a blank. Does anybody have any ideas on how to get it to run? TIA Dan Goldberg -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
