Thx all. Buddy’s worked like a charm. Simple and works! Dan Goldberg
From: 'Jim Belisle' via RBASE-L <rbase-l@googlegroups.com> Sent: Friday, October 16, 2020 11:14 AM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - using choose in where clause Dan, I believe Buddy’s example is the way to go. I use that all the time in my application. Simple and it works great. Jim From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> <rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>> On Behalf Of Buddy Walker Sent: Friday, October 16, 2020 12:20 PM To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> Subject: RE: [RBASE-L] - using choose in where clause Dan I believe what you need to do once selection is made is to enclose the vpartprefix open and close paren and then use the & instead of the . SET VAR vpartprefix = (‘(‘ + .vpartprefix + ‘)’) EDIT USI FormName WHERE colname IN &vpartprefix Buddy From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> <rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>> On Behalf Of Dan Goldberg Sent: Friday, October 16, 2020 10:49 AM To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> Subject: [RBASE-L] - using choose in where clause For some reason I cannot remember on how to do this properly. Maybe Friday blanking out for me. I have a choose command that has multiple item selection. I want to use that multiple selection in a where clause My commands are: CHOOSE vpartprefix FROM #VALUES FOR (partprefix&'-'&descript),partprefix + FROM masterindex + ORDER BY partprefix CHKBOX 10 TITLE 'Pick List' + CAPTION 'Select Up to 10 items' LINES 15 FORMATTED OPTION + LIST_FONT_SIZE 24 | TITLE_FONT_SIZE 20 Edit Using Formname where columnname in (.vpartprefix) If I select one item it works fine. But if I select more that one item then it says no rows exist. Does anyone know what I am doing wrong? TIA Dan Goldberg -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E62CAD7%40EXCHANGE10<https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E62CAD7%40EXCHANGE10?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB3394FEB5657BC7B3763251B8A0030%40CY4PR0201MB3394.namprd02.prod.outlook.com<https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB3394FEB5657BC7B3763251B8A0030%40CY4PR0201MB3394.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- 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 rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E62D41E%40EXCHANGE10.