RE: [RBASE-L] - LISTOF question 10.0.4.10913

[Claudine Robbins]

Mike,

Apparently, passing parameters via the CAPTION is not documented so it’s hard 
(for me) to understand how this works.

The choose form works like a charm.

Claudine

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Michael Byerley
Sent: Tuesday, October 30, 2018 3:31 PM
To: RBASE-L
Subject: Re: [RBASE-L] - LISTOF question 10.0.4.10913


  One limitation though is from testing, the CAPTION string in RBase forms is 
limited to 1023 characters.  Windows forms can hold more than a 100K.
  1023 Chars is still a fair amount, but If one were to desire to pass more, it 
would likely have to be via a write to disk and subsequent retrieval and 
execution.  I guess I am kind of writing and thinking in terms of passing 
"actual" object names, Propertes and values at runtime, which if lengthy could 
consume a fair patch of 1K.



On Tuesday, October 30, 2018 at 3:46:24 PM UTC-4, crobbins wrote:
Thanks Mike. I can’t wait to tear into it!  You’ve totally awoken my curiosity.

Claudine
Sent from my iPhone

On Oct 29, 2018, at 9:56 PM, Michael Byerley > 
wrote:


Go ahead and download the RBase Calendar from Here:

http://byerley.net/(S(syqysn45jp2uc3quom5gtl2t))/Download_A/RbCalendar.zip

1.  Load the calendar into a non production database.  You may find it useful :)
2.  Read the comments in the CalDemo.rmd file to see the valuelist that is 
passed in the Caption String.
3.  Look at the OnAfterStart EEP to see how the string is parsed, utilizing the 
values passed.

Now taking a cue from that process, you could take a step further and make each 
element of the string and instead of passing just a value to be used, you could 
put Name / Value pairs in the following fashion:

EDIT USING rbcalendar CAPTION 
'FormWidth=180,FormHeight=500,FormColor=red,ReturnVarName=,vRetDate,'

Then modify slightly the parsing method I used to a Switch/Endsw that could 
track to the NAME half of the name value pairs passed, with the VALUE half 
being consumed appropriately by PROPERTY, GETPROPERTY, or direct usage as a var.



On Monday, October 29, 2018 at 1:10:55 PM UTC-4, crobbins wrote:
Thank you Mike.  I’ve already included your form in an SP and understand the 
passing of parameters.  I also understand property commands located immediately 
after calling the SP.  However, using the CAPTION string for anything more than 
cosmetics escapes me.

Claudine

From: rba...@googlegroups.com [mailto:rba...@googlegroups.com] On Behalf Of 
Michael Byerley
Sent: Sunday, October 28, 2018 12:47 PM
To: RBASE-L
Subject: Re: [RBASE-L] - LISTOF question 10.0.4.10913



  One further comment on this.  You can blackbox the form solution in a couple 
of ways, one being to put the form inside of a stored procedure so you can call 
it from there,
then using property commands to change the table name and colum spec for the 
listbox, or simply utilize the CAPTION string that is the argument of Edit 
Using or Enter Using to contain an argument of the elements you want to change 
in the onAfter start of the form.

  If you have ever used my RBase form based Calendar, you will see its' 
procedure there.

  So by doing that, you could change the properties of the pseudo Choose box on 
the fly, and reuse it anytime the need arises in lieu of having a separate form 
for each problem.

  Over the course of time since the humble 7.0, RBase has provided many 
pathways to problem solution and when there is none apparent, there is always a 
reasonably willing RDCC..  :)



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: rba...@googlegroups.com [mailto:rba...@googlegroups.com] On Behalf Of 
Claudine Robbins
Sent: Friday, October 26, 2018 3:08 PM
To: rba...@googlegroups.com
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:image002.png@01D46D3C.007A56F0]
--
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+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit 
ht

Re: [RBASE-L] - LISTOF question 10.0.4.10913

[Michael Byerley]

  One limitation though is from testing, the CAPTION string in RBase forms 
is limited to 1023 characters.  Windows forms can hold more than a 100K.  
  1023 Chars is still a fair amount, but If one were to desire to pass 
more, it would likely have to be via a write to disk and subsequent 
retrieval and execution.  I guess I am kind of writing and thinking in 
terms of passing "actual" object names, Propertes and values at runtime, 
which if lengthy could consume a fair patch of 1K.



On Tuesday, October 30, 2018 at 3:46:24 PM UTC-4, crobbins wrote:
>
> Thanks Mike. I can’t wait to tear into it!  You’ve totally awoken my 
> curiosity.  
>
> Claudine 
>
> Sent from my iPhone
>
> On Oct 29, 2018, at 9:56 PM, Michael Byerley  > wrote:
>
>
>
> Go ahead and download the RBase Calendar from Here: 
>
> http://byerley.net/(S(syqysn45jp2uc3quom5gtl2t))/Download_A/RbCalendar.zip
>
> 1.  Load the calendar into a non production database.  You may find it 
> useful :)
> 2.  Read the comments in the CalDemo.rmd file to see the valuelist that is 
> passed in the Caption String.
> 3.  Look at the OnAfterStart EEP to see how the string is parsed, 
> utilizing the values passed.
>
> Now taking a cue from that process, you could take a step further and make 
> each element of the string and instead of passing just a value to be used, 
> you could put Name / Value pairs in the following fashion:
>
> EDIT USING rbcalendar CAPTION 
> 'FormWidth=180,FormHeight=500,FormColor=red,ReturnVarName=,vRetDate,'
>
> Then modify slightly the parsing method I used to a Switch/Endsw that 
> could track to the NAME half of the name value pairs passed, with the VALUE 
> half being consumed appropriately by PROPERTY, GETPROPERTY, or direct usage 
> as a var.
>
>  
>
> On Monday, October 29, 2018 at 1:10:55 PM UTC-4, crobbins wrote: 
>>
>> Thank you Mike.  I’ve already included your form in an SP and understand 
>> the passing of parameters.  I also understand property commands located 
>> immediately after calling the SP.  However, using the CAPTION string for 
>> anything more than cosmetics escapes me.
>>
>>  
>>
>> Claudine
>>
>>  
>>
>> *From:* rba...@googlegroups.com [mailto:rba...@googlegroups.com] *On 
>> Behalf Of *Michael Byerley
>> *Sent:* Sunday, October 28, 2018 12:47 PM
>> *To:* RBASE-L
>> *Subject:* Re: [RBASE-L] - LISTOF question 10.0.4.10913
>>
>>  
>>
>>  
>>
>>  
>>
>>   One further comment on this.  You can blackbox the form solution in a 
>> couple of ways, one being to put the form inside of a stored procedure so 
>> you can call it from there,
>>
>> then using property commands to change the table name and colum spec for 
>> the listbox, or simply utilize the CAPTION string that is the argument of 
>> Edit Using or Enter Using to contain an argument of the elements you want 
>> to change in the onAfter start of the form.
>>
>>  
>>
>>   If you have ever used my RBase form based Calendar, you will see its' 
>> procedure there.
>>
>>  
>>
>>   So by doing that, you could change the properties of the pseudo Choose 
>> box on the fly, and reuse it anytime the need arises in lieu of having a 
>> separate form for each problem.
>>
>>  
>>
>>   Over the course of time since the humble 7.0, RBase has provided many 
>> pathways to problem solution and when there is none apparent, there is 
>> always a reasonably willing RDCC..  :)
>>
>>  
>>
>>
>>
>> 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:* rba...@googlegroups.com [mailto:rba...@googlegroups.com] *On 
>> Behalf Of *Claudine Robbins
>> *Sent:* Friday, October 26, 2018 3:08 PM
>> *To:* rba...@googlegroups.com
>> *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 

Re: [RBASE-L] - LISTOF question 10.0.4.10913

[Claudine Robbins]

Thanks Mike. I can’t wait to tear into it!  You’ve totally awoken my curiosity.

Claudine

Sent from my iPhone

On Oct 29, 2018, at 9:56 PM, Michael Byerley 
mailto:bauer...@gmail.com>> wrote:



Go ahead and download the RBase Calendar from Here:

http://byerley.net/(S(syqysn45jp2uc3quom5gtl2t))/Download_A/RbCalendar.zip

1.  Load the calendar into a non production database.  You may find it useful :)
2.  Read the comments in the CalDemo.rmd file to see the valuelist that is 
passed in the Caption String.
3.  Look at the OnAfterStart EEP to see how the string is parsed, utilizing the 
values passed.

Now taking a cue from that process, you could take a step further and make each 
element of the string and instead of passing just a value to be used, you could 
put Name / Value pairs in the following fashion:

EDIT USING rbcalendar CAPTION 
'FormWidth=180,FormHeight=500,FormColor=red,ReturnVarName=,vRetDate,'

Then modify slightly the parsing method I used to a Switch/Endsw that could 
track to the NAME half of the name value pairs passed, with the VALUE half 
being consumed appropriately by PROPERTY, GETPROPERTY, or direct usage as a var.



On Monday, October 29, 2018 at 1:10:55 PM UTC-4, crobbins wrote:
Thank you Mike.  I’ve already included your form in an SP and understand the 
passing of parameters.  I also understand property commands located immediately 
after calling the SP.  However, using the CAPTION string for anything more than 
cosmetics escapes me.

Claudine

From: rba...@googlegroups.com [mailto:rba...@googlegroups.com] On Behalf Of 
Michael Byerley
Sent: Sunday, October 28, 2018 12:47 PM
To: RBASE-L
Subject: Re: [RBASE-L] - LISTOF question 10.0.4.10913



  One further comment on this.  You can blackbox the form solution in a couple 
of ways, one being to put the form inside of a stored procedure so you can call 
it from there,
then using property commands to change the table name and colum spec for the 
listbox, or simply utilize the CAPTION string that is the argument of Edit 
Using or Enter Using to contain an argument of the elements you want to change 
in the onAfter start of the form.

  If you have ever used my RBase form based Calendar, you will see its' 
procedure there.

  So by doing that, you could change the properties of the pseudo Choose box on 
the fly, and reuse it anytime the need arises in lieu of having a separate form 
for each problem.

  Over the course of time since the humble 7.0, RBase has provided many 
pathways to problem solution and when there is none apparent, there is always a 
reasonably willing RDCC..  :)



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: rba...@googlegroups.com [mailto:rba...@googlegroups.com] On Behalf Of 
Claudine Robbins
Sent: Friday, October 26, 2018 3:08 PM
To: rba...@googlegroups.com
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:image002.png@01D46D3C.007A56F0]
--
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+u...@googlegroups.com.
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 rbase-l+u...@googlegroups.com.
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 
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
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

Re: [RBASE-L] - LISTOF question 10.0.4.10913

[Michael Byerley]

Go ahead and download the RBase Calendar from Here:

http://byerley.net/(S(syqysn45jp2uc3quom5gtl2t))/Download_A/RbCalendar.zip

1.  Load the calendar into a non production database.  You may find it 
useful :)
2.  Read the comments in the CalDemo.rmd file to see the valuelist that is 
passed in the Caption String.
3.  Look at the OnAfterStart EEP to see how the string is parsed, utilizing 
the values passed.

Now taking a cue from that process, you could take a step further and make 
each element of the string and instead of passing just a value to be used, 
you could put Name / Value pairs in the following fashion:

EDIT USING rbcalendar CAPTION 
'FormWidth=180,FormHeight=500,FormColor=red,ReturnVarName=,vRetDate,'

Then modify slightly the parsing method I used to a Switch/Endsw that could 
track to the NAME half of the name value pairs passed, with the VALUE half 
being consumed appropriately by PROPERTY, GETPROPERTY, or direct usage as a 
var.

 

On Monday, October 29, 2018 at 1:10:55 PM UTC-4, crobbins wrote:
>
> Thank you Mike.  I’ve already included your form in an SP and understand 
> the passing of parameters.  I also understand property commands located 
> immediately after calling the SP.  However, using the CAPTION string for 
> anything more than cosmetics escapes me.
>
>  
>
> Claudine
>
>  
>
> *From:* rba...@googlegroups.com  [mailto:
> rba...@googlegroups.com ] *On Behalf Of *Michael Byerley
> *Sent:* Sunday, October 28, 2018 12:47 PM
> *To:* RBASE-L
> *Subject:* Re: [RBASE-L] - LISTOF question 10.0.4.10913
>
>  
>
>  
>
>  
>
>   One further comment on this.  You can blackbox the form solution in a 
> couple of ways, one being to put the form inside of a stored procedure so 
> you can call it from there,
>
> then using property commands to change the table name and colum spec for 
> the listbox, or simply utilize the CAPTION string that is the argument of 
> Edit Using or Enter Using to contain an argument of the elements you want 
> to change in the onAfter start of the form.
>
>  
>
>   If you have ever used my RBase form based Calendar, you will see its' 
> procedure there.
>
>  
>
>   So by doing that, you could change the properties of the pseudo Choose 
> box on the fly, and reuse it anytime the need arises in lieu of having a 
> separate form for each problem.
>
>  
>
>   Over the course of time since the humble 7.0, RBase has provided many 
> pathways to problem solution and when there is none apparent, there is 
> always a reasonably willing RDCC..  :)
>
>  
>
>
>
> 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:* rba...@googlegroups.com [mailto:rba...@googlegroups.com] *On 
> Behalf Of *Claudine Robbins
> *Sent:* Friday, October 26, 2018 3:08 PM
> *To:* rba...@googlegroups.com
> *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.
>
>  
>
> [image: cid:image002.png@01D46D3C.007A56F0]
>
> -- 
> 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+u...@googlegroups.com.
> 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 rbase-l+u...@googlegroups.com .
> 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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - LISTOF question 10.0.4.10913

[Claudine Robbins]

Thank you Mike.  I’ve already included your form in an SP and understand the 
passing of parameters.  I also understand property commands located immediately 
after calling the SP.  However, using the CAPTION string for anything more than 
cosmetics escapes me.

Claudine

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Michael Byerley
Sent: Sunday, October 28, 2018 12:47 PM
To: RBASE-L
Subject: Re: [RBASE-L] - LISTOF question 10.0.4.10913



  One further comment on this.  You can blackbox the form solution in a couple 
of ways, one being to put the form inside of a stored procedure so you can call 
it from there,
then using property commands to change the table name and colum spec for the 
listbox, or simply utilize the CAPTION string that is the argument of Edit 
Using or Enter Using to contain an argument of the elements you want to change 
in the onAfter start of the form.

  If you have ever used my RBase form based Calendar, you will see its' 
procedure there.

  So by doing that, you could change the properties of the pseudo Choose box on 
the fly, and reuse it anytime the need arises in lieu of having a separate form 
for each problem.

  Over the course of time since the humble 7.0, RBase has provided many 
pathways to problem solution and when there is none apparent, there is always a 
reasonably willing RDCC..  :)



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: rba...@googlegroups.com 
[mailto:rba...@googlegroups.com] On Behalf Of Claudine Robbins
Sent: Friday, October 26, 2018 3:08 PM
To: rba...@googlegroups.com
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:image002.png@01D46D3C.007A56F0]
--
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+u...@googlegroups.com.
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 
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - LISTOF question 10.0.4.10913

[Michael Byerley]

  One further comment on this.  You can blackbox the form solution in a 
couple of ways, one being to put the form inside of a stored procedure so 
you can call it from there,
then using property commands to change the table name and colum spec for 
the listbox, or simply utilize the CAPTION string that is the argument of 
Edit Using or Enter Using to contain an argument of the elements you want 
to change in the onAfter start of the form.

  If you have ever used my RBase form based Calendar, you will see its' 
procedure there.

  So by doing that, you could change the properties of the pseudo Choose 
box on the fly, and reuse it anytime the need arises in lieu of having a 
separate form for each problem.

  Over the course of time since the humble 7.0, RBase has provided many 
pathways to problem solution and when there is none apparent, there is 
always a reasonably willing RDCC..  :)



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:* rba...@googlegroups.com  [mailto:
> rba...@googlegroups.com ] *On Behalf Of *Claudine Robbins
> *Sent:* Friday, October 26, 2018 3:08 PM
> *To:* rba...@googlegroups.com 
> *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.
>
>  
>
> [image: cid:image002.png@01D46D3C.007A56F0]
>
> -- 
> 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+u...@googlegroups.com .
> 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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - LISTOF question 10.0.4.10913

[Claudine Robbins]

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: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] 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: rba...@googlegroups.com 
[mailto:rba...@googlegroups.com] On Behalf Of Claudine Robbins
Sent: Friday, October 26, 2018 3:08 PM
To: rba...@googlegroups.com
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:image002.png@01D46D3C.007A56F0]
--
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+u...@googlegroups.com.
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 
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - LISTOF question 10.0.4.10913

[Michael Byerley]

  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:* rba...@googlegroups.com  [mailto:
> rba...@googlegroups.com ] *On Behalf Of *Claudine Robbins
> *Sent:* Friday, October 26, 2018 3:08 PM
> *To:* rba...@googlegroups.com 
> *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.
>
>  
>
> [image: cid:image002.png@01D46D3C.007A56F0]
>
> -- 
> 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+u...@googlegroups.com .
> 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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - LISTOF question 10.0.4.10913

[Javier Valencia]

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: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Claudine Robbins
Sent: Friday, October 26, 2018 3:08 PM
To: rbase-l@googlegroups.com
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:image002.png@01D46D3C.007A56F0
-- 
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.
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - LISTOF question 10.0.4.10913

[Claudine Robbins]

I’m getting the same result with other datasets.  I’ll report it to RDCC.

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Claudine Robbins
Sent: Friday, October 26, 2018 6:49 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - LISTOF question 10.0.4.10913

Good idea. I’ll let you know what I come up with.
Sent from my iPhone

On Oct 26, 2018, at 6:37 PM, Albert Berry 
mailto:alb...@albertberry.com>> wrote:
Have you tried another set of data with an embedded comma? If you hit the same 
problem again, it might be something for RDCC. They are pretty good at fixing 
inadvertent boo-boos. My latest was RSTYLE telling me the NO_FOCUS option on 
PAUSE was not a legal command. They fixed it and told me so Wednesday. I sent 
it in late Friday (when everyone was in Vegas!).

Albert


On Oct 26, 2018, at 2:52 PM, Albert Berry 
mailto:alb...@albertberry.com>> wrote:

Wild guess. Try increasing 32 to 40. I have absolutely no idea if this would 
make any difference, but it’s a cheap try.




On Oct 26, 2018, at 2:07 PM, Claudine Robbins 
mailto:crobb...@iexgroup.com>> wrote:

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.



--
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>.
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 
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
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 
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - LISTOF question 10.0.4.10913

[Claudine Robbins]

Good idea. I’ll let you know what I come up with.

Sent from my iPhone

On Oct 26, 2018, at 6:37 PM, Albert Berry 
mailto:alb...@albertberry.com>> wrote:

Have you tried another set of data with an embedded comma? If you hit the same 
problem again, it might be something for RDCC. They are pretty good at fixing 
inadvertent boo-boos. My latest was RSTYLE telling me the NO_FOCUS option on 
PAUSE was not a legal command. They fixed it and told me so Wednesday. I sent 
it in late Friday (when everyone was in Vegas!).

Albert

On Oct 26, 2018, at 2:52 PM, Albert Berry 
mailto:alb...@albertberry.com>> wrote:

Wild guess. Try increasing 32 to 40. I have absolutely no idea if this would 
make any difference, but it’s a cheap try.



On Oct 26, 2018, at 2:07 PM, Claudine Robbins 
mailto:crobb...@iexgroup.com>> wrote:

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.



--
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.
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 
rbase-l+unsubscr...@googlegroups.com.
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - LISTOF question 10.0.4.10913

[Albert Berry]

Have you tried another set of data with an embedded comma? If you hit the same 
problem again, it might be something for RDCC. They are pretty good at fixing 
inadvertent boo-boos. My latest was RSTYLE telling me the NO_FOCUS option on 
PAUSE was not a legal command. They fixed it and told me so Wednesday. I sent 
it in late Friday (when everyone was in Vegas!). 

Albert

> On Oct 26, 2018, at 2:52 PM, Albert Berry  wrote:
> 
> Wild guess. Try increasing 32 to 40. I have absolutely no idea if this would 
> make any difference, but it’s a cheap try. 
> 
> 
> 
>> On Oct 26, 2018, at 2:07 PM, Claudine Robbins > > wrote:
>> 
>> 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.
>>  
>> 
>> 
>> -- 
>> 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 
>> .
>> 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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - LISTOF question 10.0.4.10913

[Claudine Robbins]

Thanks for the clarification Albert.

Interesting. I had 64 bit version of V8 as well.

Now back to LISTOF...

Claudine

Sent from my iPhone

On Oct 26, 2018, at 4:51 PM, Albert Berry 
mailto:alb...@albertberry.com>> wrote:

79/18 is the 32 bit version. Your dat file is probably dated back in RBG95 
days, before you went RBG95_64 and/or RBGXE
Albert


On Oct 26, 2018, at 3:30 PM, Claudine Robbins 
mailto:crobb...@iexgroup.com>> wrote:

Albert,

Setting namewidth to 40 didn’t work but it brings an interesting question I’ve 
never asked myself before because I “assumed” that all settings could be reset 
in the .DAT file and namewidth is not one I have an entry for.  So I don’t know 
why 79/18 is my default setting.  Looks like I seriously need to review my .DAT 
file.

Corrections/comments welcome.

TIA,

Claudine





From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Albert Berry
Sent: Friday, October 26, 2018 3:53 PM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: Re: [RBASE-L] - LISTOF question 10.0.4.10913

Wild guess. Try increasing 32 to 40. I have absolutely no idea if this would 
make any difference, but it’s a cheap try.




On Oct 26, 2018, at 2:07 PM, Claudine Robbins 
mailto:crobb...@iexgroup.com>> wrote:

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.



--
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>.
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 
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
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 
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
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 
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - LISTOF question 10.0.4.10913

[Albert Berry]

79/18 is the 32 bit version. Your dat file is probably dated back in RBG95 
days, before you went RBG95_64 and/or RBGXE
Albert


> On Oct 26, 2018, at 3:30 PM, Claudine Robbins  wrote:
> 
> Albert,
>  
> Setting namewidth to 40 didn’t work but it brings an interesting question 
> I’ve never asked myself before because I “assumed” that all settings could be 
> reset in the .DAT file and namewidth is not one I have an entry for.  So I 
> don’t know why 79/18 is my default setting.  Looks like I seriously need to 
> review my .DAT file.
>  
> Corrections/comments welcome.
>  
> TIA,
>  
> Claudine
>  
>  
> 
>  
>  
> From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 
> [mailto:rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>] On Behalf 
> Of Albert Berry
> Sent: Friday, October 26, 2018 3:53 PM
> To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
> Subject: Re: [RBASE-L] - LISTOF question 10.0.4.10913
>  
> Wild guess. Try increasing 32 to 40. I have absolutely no idea if this would 
> make any difference, but it’s a cheap try. 
>  
> 
> 
> 
> On Oct 26, 2018, at 2:07 PM, Claudine Robbins  <mailto:crobb...@iexgroup.com>> wrote:
>  
> 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.
>  
> 
>  
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php 
> <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>.
> For more options, visit https://groups.google.com/d/optout 
> <https://groups.google.com/d/optout>.
>  
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php 
> <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>.
> For more options, visit https://groups.google.com/d/optout 
> <https://groups.google.com/d/optout>.
> 
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php 
> <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>.
> For more options, visit https://groups.google.com/d/optout 
> <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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - LISTOF question 10.0.4.10913

[Albert Berry]

Wild guess. Try increasing 32 to 40. I have absolutely no idea if this would 
make any difference, but it’s a cheap try. 



> On Oct 26, 2018, at 2:07 PM, Claudine Robbins  wrote:
> 
> 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.
>  
> 
> 
> -- 
> 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 
> .
> 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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - LISTOF question 10.0.4.10913

[Claudine Robbins]

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:image002.png@01D46D3C.007A56F0]

-- 
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.
For more options, visit https://groups.google.com/d/optout.