Could you draw your values for vlist into a temporary table, and then select * from inquiry where InquiryDate bet 1/1/2014 and 12/31/2014 and cust_zip in (sel yourvalue from temptable)
? Jeff Richardson | Project Manager, Asset Verification Services (AVS) DMA – DuCharme, McMillen & Associates, Inc. | 828 S Harrison Street Suite 650, Fort Wayne, IN 46802 Cell: 724-366-1724 Connect: [email protected]<mailto:[email protected]> | Website<http://www.dmainc.com/> | LinkedIn<https://www.linkedin.com/company/ducharme-mcmillen-&-associates> | Twitter<https://twitter.com/DMATAX> | Facebook<https://www.facebook.com/DMAtaxservices> ___________________________________________________________ ATTENTION: This message and all attachments are PRIVATE, and may contain information that is CONFIDENTIAL and PRIVILEGED. If you have received this message in error, please notify the sender by reply e-mail and delete the message immediately. From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Friday, September 2, 2016 9:48 AM To: [email protected] 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. ATTENTION: This message and all attachments are PRIVATE, and may contain information that is CONFIDENTIAL and PRIVILEGED. If you have received this message in error, please notify the sender by reply e-mail and delete the message immediately. -- 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.
