Razzak,
Would love to see it also !
Bill Eyring
-------- Original Message --------
Subject: [RBASE-L] - Re: compiled apps best practice
From: "Mohammed Sattar" <moham...@utahgroup.net>
Date: Mon, November 25, 2013 12:27 am
To: rbase-l@rbase.com (RBASE-L Mailing List)
Hi Razzak
I would love to see the COOOL application also please
Mohammed Sattar
Utah Group of Companies
-----Original Message-----
From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] On Behalf Of A. Razzak
Memon
Sent: Wednesday, November 6, 2013 1: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!
>--
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to rbase-l@rbase.com
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to rbase-l@rbase.com
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to rbase-l@rbase.com
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to rbase-l@rbase.com
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.
================================================
