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]>
To: rbase-l <[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].
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.
