Albert,
You no longer have to unload the STORED_PROCEDURE to edit it you can do so
directly fromthe Database Explorer. Jim Bentley,
American Celiac Society
1-504-737-3293
From: Albert Berry <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Friday, May 29, 2015 12:47 PM
Subject: [RBASE-L] - Re: Forms: Custon Form Action
I don't find modifying the stored procedures to be a hassle, myself. Even
were I to be using RUN SELECT, I would test the file outside the database
before making a permanent modification in any event, so unloading the stored
procedure and modifying it using RBEDIT is not any different to me. Different
strokes for different folks, I think.
Albert
On 5/29/2015 10:53 AM, Javier Valencia wrote:
<!--#yiv5714814596 _filtered #yiv5714814596 {font-family:Helvetica;panose-1:2
11 6 4 2 2 2 2 2 4;} _filtered #yiv5714814596 {font-family:Helvetica;panose-1:2
11 6 4 2 2 2 2 2 4;} _filtered #yiv5714814596 {font-family:Calibri;panose-1:2
15 5 2 2 2 4 3 2 4;} _filtered #yiv5714814596 {font-family:Tahoma;panose-1:2 11
6 4 3 5 4 4 2 4;} _filtered #yiv5714814596 {font-family:Consolas;panose-1:2 11
6 9 2 2 4 3 2 4;} _filtered #yiv5714814596 {font-family:"Lucida
Console";panose-1:2 11 6 9 4 5 4 2 2 4;}#yiv5714814596 #yiv5714814596
p.yiv5714814596MsoNormal, #yiv5714814596 li.yiv5714814596MsoNormal,
#yiv5714814596 div.yiv5714814596MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New
Roman", "serif";color:black;}#yiv5714814596 a:link, #yiv5714814596
span.yiv5714814596MsoHyperlink
{color:blue;text-decoration:underline;}#yiv5714814596 a:visited, #yiv5714814596
span.yiv5714814596MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv5714814596 pre
{margin:0in;margin-bottom:.0001pt;font-size:10.0pt;font-family:"Courier
New";color:black;}#yiv5714814596 p.yiv5714814596MsoAcetate, #yiv5714814596
li.yiv5714814596MsoAcetate, #yiv5714814596 div.yiv5714814596MsoAcetate
{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma",
"sans-serif";color:black;}#yiv5714814596 span.yiv5714814596HTMLPreformattedChar
{font-family:Consolas;color:black;}#yiv5714814596
span.yiv5714814596EmailStyle19 {font-family:"Calibri",
"sans-serif";color:#1F497D;}#yiv5714814596 span.yiv5714814596BalloonTextChar
{font-family:"Tahoma", "sans-serif";color:black;}#yiv5714814596
span.yiv5714814596SpellE {}#yiv5714814596 .yiv5714814596MsoChpDefault
{font-size:10.0pt;} _filtered #yiv5714814596 {margin:1.0in 1.0in 1.0in
1.0in;}#yiv5714814596 div.yiv5714814596WordSection1 {}--> 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, PE O:
913-829-0888 H: 913-397-9605 C: 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.
Albert On 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_PROCEDURE then 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
--
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
