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