Dan,
Your IN list has to be properly formatted for use.
Here are a couple literal examples:
IF vchar NOT IN ('0','1','2','3','4','5','6','7','8','9')
IF (LASTKEY(1)) NOT IN ('>','<','>>','<<') THEN
And here is one that is constructed on the fly:
The following vCho variable was constructed from a CheckBox Choose.
SET VAR vList = .vCho
IF (ItemCnt(.vCho)) > 1 THEN
SET VAR vCho = ('''' + (SRPL(.vList,',',''',''',0)) + '''')
ENDIF
SELECT COUNT (*) INTO vCount IND vIn0 FROM AgCompany WHERE +
(CoNo IN (&vCho))
IF (ItemCnt(.vList)) <> .vCount THEN
GOTO ndProc1
ENDIF
On Friday, October 16, 2020 at 10:48:48 AM UTC-4 dang wrote:
> 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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/44d0b8c6-f695-4ad6-834a-6be1622ab400n%40googlegroups.com.
