Great!
Thanks
Dan
-----Original Message-----
From: A. Razzak Memon
Sent: Tuesday, November 05, 2013 11:08 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: compiled apps best practice
At 01:58 PM 11/5/2013, Dan Goldberg wrote:
>Thanks for the info. I see the form action to connect to the database but
>should I have one at the end of my code to disconnect from the database?
Dan,
Let me send you a cool application using the External Form File (.rff) to
illustrate everything you need to know.
Have fun!
Very Best R:egards,
Razzak
>-----Original Message-----
>From: A. Razzak Memon
>Sent: Tuesday, November 05, 2013 10:37 AM
>To: RBASE-L Mailing List
>Subject: [RBASE-L] - Re: compiled apps best practice
>
>At 12:48 PM 11/5/2013, Dan Goldberg wrote:
>
> >I am trying to figure out the best practice for compiled apps.
> >
> >I have a compiled app that users open. It is an external form file
> >that is ran.
> >
> >The question is should I:
> >
> >1. connect to the database when they open the app and leave it
> >connected until
> > they close the app.
> >
> >or
> >
> >2. open the app and stay disconnected. When they click on something
> >on the app,
> > connect to the database, process, and when it is done disconnect.
> >
> >Right now I use option 1 but from time to time the database gets
> >corrupted. I am
> >thinking maybe to do option 2 but do not know how that will work or
> >if it will
> >solve the corruption problem.
>
>
>Dan,
>
>Excellent question!
>
>Let me send you a personal invite to www.join.me/RazzakMemon to show you
>the
>practical approach and advantages of using option #2 to deploy an
>R:Compiled
>R:BASE eXtreme 9.5 (32/64) application in a multi-user environment.
>
>Using this approach you may also include all database maintenance and
>backup
>routines in External Form File (.rff), if you wish.
>
>Technically, you will have to define a Custom Form Action in External Form
>File, for example:
>
>-- Custom Form Action: CheckDBConnection (Check Database Connection)
>
>IF (CVAL('DATABASE')) <> 'RBU_SAT' OR (CVAL('DATABASE')) IS NULL THEN
> CONNECT RBU_SAT IDENTIFIED BY NONE
>ENDIF
>RETURN
>
>Then, add the following code for each TreeView Node, TreeView Item, Button,
>etc., that involves the database connection.
>
>PROPERTY RBASE_FORM_ACTION CheckDBConnection ' '
>-- continue with the code ...
>
>Hope that helps!
>
>Feel free to reach out to me with any questions.
>
>Very Best R:egards,
>
>Razzak
>
>www.rbase.com
>www.facebook.com/rbase
>--
>30+ years of continuous innovation!
>15 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
>--
