RE: [RBASE-L] - LISTOF question 10.0.4.10913

2018-11-15 Thread Claudine Robbins
, 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

Re: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-30 Thread Michael Byerley
nderstand property commands located >> immediately after calling the SP. However, using the CAPTION string for >> anything more than cosmetics escapes me. >> >> >> >> Claudine >> >> >> >> *From:* rba...@

Re: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-30 Thread Claudine Robbins
audine 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

Re: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-29 Thread Michael Byerley
ay, 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 procedur

RE: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-29 Thread Claudine Robbins
@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

Re: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-28 Thread 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

RE: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-28 Thread Claudine Robbins
estion 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

Re: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-28 Thread 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

RE: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-27 Thread 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:

RE: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-26 Thread 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

Re: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-26 Thread 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

Re: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-26 Thread 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

Re: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-26 Thread Claudine Robbins
ooglegroups.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

Re: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-26 Thread Albert Berry
ber 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. > >

Re: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-26 Thread 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