Javier,
Thank you for jumping in with your suggestion.
I correctly get:
R>sho v vvaluelist
'YELLOW JACKET CONSTRUCTION,
INC.','YELLOW JACKET
OILFIELD','YELLOWHOUSE
MACHINERY CO.'
For some reason, however, the choose command result vpickname yields:
R>sho v vpickname
'YELLOW JACKET CONSTRUCTION
In other words it stops at the comma and doesn’t see INC. and the EDI USI fails
even though I changed the command to:
EDIT USING companies WHERE ('''' + company_name + '''') = .vPickName
Frustrating problem but Mike’s solution is solid so I’m happy right now.
And your suggestion will be applicable to other scenarios.
Claudine
From: [email protected] [mailto:[email protected]] On Behalf Of
Michael Byerley
Sent: Sunday, October 28, 2018 11:38 AM
To: RBASE-L
Subject: Re: [RBASE-L] - LISTOF question 10.0.4.10913
Good Call Javier...
On Saturday, October 27, 2018 at 10:53:57 PM UTC-4, javier.valencia wrote:
Claudine,
Try the following:
SELECT LISTOF('''' + your column + '''') into xxx from your_table WHERE …
All the items should have single quotes and the comma should be inside the
quotes.
Javier,
Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
From: [email protected]<javascript:>
[mailto:[email protected]<javascript:>] On Behalf Of Claudine Robbins
Sent: Friday, October 26, 2018 3:08 PM
To: [email protected]<javascript:>
Subject: [RBASE-L] - LISTOF question 10.0.4.10913
Hello all,
My experience with LISTOF is that it automatically puts quotes around fields
that contain commas but I’m running into a situation where it does not.
One of the fields is YELLOW JACKET CONSTRUCTION, INC., LISTOF returns the space
plus INC. as a separate value.
However, it correctly returns 3 for the ITEMCNT variable.
What am I overlooking?
R>sho v vValueList
YELLOW JACKET CONSTRUCTION,
INC.,YELLOW JACKET
OILFIELD,YELLOWHOUSE
MACHINERY CO.
[cid:[email protected]]
--
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]<javascript:>.
For more options, visit https://groups.google.com/d/optout.
--
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]<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.
--
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].
For more options, visit https://groups.google.com/d/optout.
