Thx guys I will give them both a try.

Dan


From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of Buddy 
Walker
Sent: Friday, October 16, 2020 10:28 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - using choose in where clause

Dan
  I wanted to mention that if your selections contain spaces it may break. If 
possible I would return a unique ID from the choose process.

Buddy

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 1: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/002301d6a3e0%24886ec190%24994c44b0%24%40comcast.net<https://groups.google.com/d/msgid/rbase-l/002301d6a3e0%24886ec190%24994c44b0%24%40comcast.net?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/002a01d6a3e1%24baf9a3e0%2430eceba0%24%40comcast.net<https://groups.google.com/d/msgid/rbase-l/002a01d6a3e1%24baf9a3e0%2430eceba0%24%40comcast.net?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/2E4830CEC16615458329D3D83342F8D0014E62D0CD%40EXCHANGE10.

Reply via email to