We were connecting/disconnecting too, but in our case it took about 5 seconds to connect. Funny how 5 seconds seems like an eternity to a user! So we switched back to leaving open (not-compiled).
Karen -----Original Message----- From: jan johansen <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tue, Nov 5, 2013 3:57 pm Subject: [RBASE-L] - Re: compiled apps best practice I've done this either way. I had followed the approach of CONNecting/DISConnecting. But some sort of network security settings were causing delays so I discontinued the practice. -----Original Message----- From: "Dan Goldberg" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 5 Nov 2013 13:51:21 -0800 Subject: [RBASE-L] - Re: compiled apps best practice Interesting. I am opposite. It connects to the database when they open the compiled app and it stays open until they close it. Dan From: [email protected] Sent: Tuesday, November 05, 2013 1:45 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: [RBASE-L] - Re: compiled apps best practice Yes, Dan. BD ----- Reply message ----- From: "Dan Goldberg" <[email protected]> To: <[email protected]>, <(RBASE-L Mailing List)> Subject: [RBASE-L] - Re: compiled apps best practice Date: Tue, Nov 5, 2013 1:37 PM So each item in your menu you connect to the database and then disconnect when it is done? Dan Goldberg -----Original Message----- From: Brad Davidson Sent: Tuesday, November 05, 2013 12:13 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: compiled apps best practice Razzak, I'd like to piggy-back onto Dan's request to see the code you recommend for option #2. I've been applying a connect/disconnect to each app in my external form file (main menu) which is compiled, for some time. However, a user reports a "freeze" of a form, or, navigation between applications form time-to-time (for example, no issues for a week, then just today, 2 issues). Looking to my code to see where/if it can be improved... Thank you, Brad Davidson -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Tuesday, November 05, 2013 11:09 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! >--
