Hi Razzak, I would be interested in this application, too.
Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: November-05-13 2:09 PM 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! >-- --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
