Javier,Use of stored_procedure has been greatly enhanced in v10.0. Editing has
be greatly enhanced and the new unload procedures have made updating odther
databases easy as the required PUT command is now created ina ".RMD" file. As
to ease of use RUN SELECT etc vs CALL prcedurename(requiredparameters)One
advantage of the stored_procedure route is that you can use the following
syntaxSET VAR varname DataType=(CALL procedureName(requiredparamteres))SET VAR
varname DataType=(CALL pocedurename())or CALL procedurename() or CALL
procedurename(requiredparamterss) -- if a return value is not needed Jim
Bentley,
American Celiac Society
1-504-737-3293
From: Javier Valencia <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Friday, May 29, 2015 11:53 AM
Subject: [RBASE-L] - Re: Forms: Custon Form Action
<!--#yiv5108254132 _filtered #yiv5108254132 {font-family:Helvetica;panose-1:2
11 6 4 2 2 2 2 2 4;} _filtered #yiv5108254132 {font-family:Helvetica;panose-1:2
11 6 4 2 2 2 2 2 4;} _filtered #yiv5108254132 {font-family:Calibri;panose-1:2
15 5 2 2 2 4 3 2 4;} _filtered #yiv5108254132 {font-family:Tahoma;panose-1:2 11
6 4 3 5 4 4 2 4;} _filtered #yiv5108254132 {font-family:Consolas;panose-1:2 11
6 9 2 2 4 3 2 4;} _filtered #yiv5108254132 {font-family:"Lucida
Console";panose-1:2 11 6 9 4 5 4 2 2 4;}#yiv5108254132 #yiv5108254132
p.yiv5108254132MsoNormal, #yiv5108254132 li.yiv5108254132MsoNormal,
#yiv5108254132 div.yiv5108254132MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New
Roman", "serif";color:black;}#yiv5108254132 a:link, #yiv5108254132
span.yiv5108254132MsoHyperlink
{color:blue;text-decoration:underline;}#yiv5108254132 a:visited, #yiv5108254132
span.yiv5108254132MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv5108254132 pre
{margin:0in;margin-bottom:.0001pt;font-size:10.0pt;font-family:"Courier
New";color:black;}#yiv5108254132 p.yiv5108254132MsoAcetate, #yiv5108254132
li.yiv5108254132MsoAcetate, #yiv5108254132 div.yiv5108254132MsoAcetate
{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma",
"sans-serif";color:black;}#yiv5108254132 span.yiv5108254132HTMLPreformattedChar
{font-family:Consolas;color:black;}#yiv5108254132
span.yiv5108254132EmailStyle19 {font-family:"Calibri",
"sans-serif";color:#1F497D;}#yiv5108254132 span.yiv5108254132BalloonTextChar
{font-family:"Tahoma", "sans-serif";color:black;}#yiv5108254132
span.yiv5108254132SpellE {}#yiv5108254132 .yiv5108254132MsoChpDefault
{font-size:10.0pt;} _filtered #yiv5108254132 {margin:1.0in 1.0in 1.0in
1.0in;}#yiv5108254132 div.yiv5108254132WordSection1 {}-->Albert, I find the
RUN SELECT approach to be easier to understand and to maintain, maybe in part
because I really don’t use stored procedures that much since I started using
RUN SELECT. When you store the code in a column, you can go to it and edit it
as needed and also makes it very easy for me to upgrade client‘s databases with
very simple code. You can always restrict access to the table so users do not
modify the code. Javier, Javier Valencia, PEO: 913-829-0888H: 913-397-9605C:
913-915-3137 From: [email protected] [mailto:[email protected]] On Behalf Of
Albert Berry
Sent: Friday, May 29, 2015 11:25 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Forms: Custon Form Action I use stored procedures a
lot, but have never even tried RUN SELECT a command file. I wonder what the
advantage is of one over the other.
AlbertOn 5/28/2015 1:56 PM, James Bentley wrote:
Thanks to all who offered suggestions. I had one other thought and that is to
store the code in a STORED_PROCEDUREthen a simple CALL procedurename () would
execute the code. I do have a table where I store code for execution. Jim
Bentley, American Celiac Society 1-504-737-3293 From: A. Razzak Memon
<[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Thursday, May 28, 2015 11:27 AM
Subject: [RBASE-L] - Re: Forms: Custon Form Action
At 12:15 PM 5/28/2015, James Bentley wrote:
>Within a form you can define eeps for the following events:
> * On Before Start EEP
> * On After Start EEP
> * On Before Design Action
> * On Close Designer Action
>
>my question is if I have defined a Custom Form Action
>Say "DefFormVariables"
>
>Are there restrictions on when I can use
> PROPERTY RBASE_FORM_ACTION DefFormVariables ' '
>
>I have several forms that require extensive
>SET VARIABLE statements.
>
>I would like to consolidate them into a Form Custom Action
>and call them in then above mentioned EEPs. I can not find
>in the Help Documentation a mention of restrictions on using a
>PROPERTY RBASE_FORM_ACTION command.
>
>Any help would be appreciated.
James,
Technically, all Custom Form Actions, if defined, are accessible
right after the form is completely drawn/loaded. Thus, the first
opportunity to use/execute the Custom Form Action would be the
"On After Start" and anywhere after that.
Hope that helps!
Very Best R:egards,
Razzak.
www.rbase.com
www.rbaseX.com
www.facebook.com/rbase
--
32 years of continuous innovation!
17 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
-- A democracy ..." can only exist until the majority discovers it can vote
itself largess out of the public treasury."Attributed to Alexander Fraser
Tytler 1747-1813
