date:20181115

RE: [RBASE-L] - RE: LISTOF question 10.0.4.10913 F I X E D !

2018-11-15 Thread Claudine Robbins

Absolutely!  And thanks to the issue in the first place, I have Mike’s 
wonderful form and all the help I need from this list to boot!

Feeling very thankful.

Claudine

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Albert Berry
Sent: Thursday, November 15, 2018 4:02 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - RE: LISTOF question 10.0.4.10913 F I X E D !

Aren’t they just great? The slightest problem, no matter how insignificant, is 
fixed as if the whole program was failing.
Albert


On Nov 15, 2018, at 11:36 AM, Claudine Robbins 
mailto:crobb...@iexgroup.com>> wrote:

This issue is fixed in the next update.  Thank you R:DCC and staff at RBTI!

Claudine

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.


--
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.

-- 
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] - RE: LISTOF question 10.0.4.10913 F I X E D !

2018-11-15 Thread Albert Berry

Aren’t they just great? The slightest problem, no matter how insignificant, is 
fixed as if the whole program was failing. 
Albert

> On Nov 15, 2018, at 11:36 AM, Claudine Robbins  wrote:
> 
> This issue is fixed in the next update.  Thank you R:DCC and staff at RBTI!
>  
> Claudine
>  
> 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.
>  
> 
> -- 
> 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] - Stored Procedures

2018-11-15 Thread Claudine Robbins

Thanks Karen.  I had just come to that conclusion and was about to report my 
mistake.

Have a great day!

Claudine

From: 'Karen Tellef' via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Thursday, November 15, 2018 12:58 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Stored Procedures

The problem is that you bring up the form in MDI mode.  When you do that, the 
procedure that calls it ALWAYS continues.  You cannot bring up a form in MDI 
unless the rest of the program code doesn't rely on anything in that form.  
Take out the MDI

Karen




-Original Message-
From: Claudine Robbins 
To: rbase-l@googlegroups.com 
Sent: Thu, Nov 15, 2018 12:52 pm
Subject: [RBASE-L] - Stored Procedures
I have a new issue with a stored procedure routine which goes like this:

I call the SP NewCompanies(1) to pass a value of 1 to the SP

STEP 1 I use the DIALOG to get the user’s input on the company name they want 
to add.

STEP 2 I then EDIT USING FORMCHOOSE MDI AS ‘PICKONE’  which takes the user 
value and bring up the form.

On the form is a button to (i) set a variable vContinue to Y in order to 
proceed and (ii) to CLOSEWINDOW PICKONE

STEP 3 Back in the SP, I test the vContinue value for further action.

The problem is the SP code runs all the way through to the return before the 
FORMCHOOSE comes up on the screen.

It goes STEP 1, STEP 2, tests vContinue which is initialized to N, exits the 
SP, then shows the FORMCHOOSE…

Any ideas?

TIA,

Claudine
--
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] - Stored Procedures

2018-11-15 Thread 'Karen Tellef' via RBASE-L

The problem is that you bring up the form in MDI mode.  When you do that, the 
procedure that calls it ALWAYS continues.  You cannot bring up a form in MDI 
unless the rest of the program code doesn't rely on anything in that form.  
Take out the MDI
Karen
 
 
 
-Original Message-
From: Claudine Robbins 
To: rbase-l@googlegroups.com 
Sent: Thu, Nov 15, 2018 12:52 pm
Subject: [RBASE-L] - Stored Procedures

 !-- #yiv9876259704 _filtered #yiv9876259704 
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} #yiv9876259704 
#yiv9876259704 p.yiv9876259704MsoNormal, #yiv9876259704 
li.yiv9876259704MsoNormal, #yiv9876259704 div.yiv9876259704MsoNormal 
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", 
"sans-serif";} #yiv9876259704 a:link, #yiv9876259704 
span.yiv9876259704MsoHyperlink {color:blue;text-decoration:underline;} 
#yiv9876259704 a:visited, #yiv9876259704 span.yiv9876259704MsoHyperlinkFollowed 
{color:purple;text-decoration:underline;} #yiv9876259704 
span.yiv9876259704EmailStyle17 {font-family:"Calibri", 
"sans-serif";color:windowtext;} #yiv9876259704 .yiv9876259704MsoChpDefault 
{font-family:"Calibri", "sans-serif";} _filtered #yiv9876259704 {margin:1.0in 
1.0in 1.0in 1.0in;} #yiv9876259704 div.yiv9876259704WordSection1 {} --I 
have a new issue with a stored procedure routine which goes like this:    I 
call the SP NewCompanies(1) to pass a value of 1 to the SP    STEP 1 I use the 
DIALOG to get the user’s input on the company name they want to add.    STEP 2 
I then EDIT USING FORMCHOOSE MDI AS ‘PICKONE’  which takes the user value and 
bring up the form.    On the form is a button to (i) set a variable vContinue 
to Y in order to proceed and (ii) to CLOSEWINDOW PICKONE    STEP 3 Back in the 
SP, I test the vContinue value for further action.    The problem is the SP 
code runs all the way through to the return before the FORMCHOOSE comes up on 
the screen.    It goes STEP 1, STEP 2, tests vContinue which is initialized to 
N, exits the SP,then shows the FORMCHOOSE…    Any ideas?    TIA,    Claudine -- 
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] - Stored Procedures

2018-11-15 Thread Claudine Robbins

I have a new issue with a stored procedure routine which goes like this:

I call the SP NewCompanies(1) to pass a value of 1 to the SP

STEP 1 I use the DIALOG to get the user's input on the company name they want 
to add.

STEP 2 I then EDIT USING FORMCHOOSE MDI AS 'PICKONE'  which takes the user 
value and bring up the form.

On the form is a button to (i) set a variable vContinue to Y in order to 
proceed and (ii) to CLOSEWINDOW PICKONE

STEP 3 Back in the SP, I test the vContinue value for further action.

The problem is the SP code runs all the way through to the return before the 
FORMCHOOSE comes up on the screen.

It goes STEP 1, STEP 2, tests vContinue which is initialized to N, exits the 
SP, then shows the FORMCHOOSE...

Any ideas?

TIA,

Claudine

-- 
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

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

[RBASE-L] - RE: LISTOF question 10.0.4.10913 F I X E D !

2018-11-15 Thread Claudine Robbins

This issue is fixed in the next update.  Thank you R:DCC and staff at RBTI!

Claudine

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] - RE: LISTOF question 10.0.4.10913 F I X E D !

Re: [RBASE-L] - RE: LISTOF question 10.0.4.10913 F I X E D !

RE: [RBASE-L] - Stored Procedures

Re: [RBASE-L] - Stored Procedures

[RBASE-L] - Stored Procedures

RE: [RBASE-L] - LISTOF question 10.0.4.10913

[RBASE-L] - RE: LISTOF question 10.0.4.10913 F I X E D !

7 matches

Site Navigation

Mail list logo

Footer information