Claudine, On the surface it may appear appealing to squirrel code away in MANY places such as a specific form. or report, or label, or in individual command files. Long term considerations for changing application requirements, or changing business environment my come back to haunt you. The only constant is that application continually evolve. If your code is located in many places it may be frustrating and time consuming to find where the problem is occurring since the processing of finding embedded code is still primitive.
One of the lessons I learned from my mainframe days is that when you hard code items the inevitably come back to bite ou. I generally have almost all of my code in stored procedures, code locked .APX files, or stored on tables. I have many lookup tables for supply and verify values. Often we concentrate on having data inputted from forms. In designing verification etc one should never assume that forms are the only way to input/edit data. One can import it from an external source by a load command, bring up the edit/browse function, type a command at the R>, or even from an ODBC connection. The safest way may be to use stored procedures/triggers since they can't be turned off like rules, always execute no matter the source of the INSERT/UPDATE/DELETE. Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 --- On Thu, 7/17/08, Marc <[EMAIL PROTECTED]> wrote: > From: Marc <[EMAIL PROTECTED]> > Subject: [RBASE-L] - Re: Property ID Directory .... > To: "RBASE-L Mailing List" <[email protected]> > Date: Thursday, July 17, 2008, 11:15 AM > Claudine > > I may give this a try and move a few blocks of > code. > > Thanks > Marc > > > > > ----- Original Message ----- > From: "Claudine Robbins" > <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" > <[email protected]> > Sent: Thursday, July 17, 2008 11:00 AM > Subject: [RBASE-L] - Re: Property ID Directory .... > > > > Marc, > > > > I've become comfortable with SPs and I've not > tried the code in a table > > option. I suspect it's six of one half a dozen of > the other. Sometimes > > it's worth the original discomfort of trying > something new to discover > > something nifty. For portability, the ultimate goal > is to embed all the > > code somewhere in the application. > > > > Claudine > > > > > > > > -----Original Message----- > > From: [email protected] [mailto:[EMAIL PROTECTED] On > Behalf Of Marc > > Sent: Thursday, July 17, 2008 10:26 AM > > To: RBASE-L Mailing List > > Subject: [RBASE-L] - Re: Property ID Directory .... > > > > Claudine > > > > I have thought about that and/or storing my app/apx > code > > in the db. I am not sure if one method has an > advantage > > over the other or not? > > > > Also, a few weeks ago someone posted something about > > a user hitting short cut keys while using forms and > the user > > can view the code in a EEP. I do not remember the > details. > > > > So, for privacy I thought the APX would be more > secure? > > > > Thanks > > Marc > > > > > > > > > > > > ----- Original Message ----- > > From: "Claudine Robbins" > <[EMAIL PROTECTED]> > > To: "RBASE-L Mailing List" > <[email protected]> > > Sent: Thursday, July 17, 2008 9:49 AM > > Subject: [RBASE-L] - Re: Property ID Directory .... > > > > > >> Marc, > >> > >> You need to look into Stored Procedures. You > don't have to have them > >> return > >> anything to use them. They can be created from EEP > code (Stored > >> Procedures > > > >> | > >> New | Browse), called (CALL(spname)) from anywhere > in the application and > >> they're as easy to maintain as an EEP. > >> > >> Claudine > >> > >> -----Original Message----- > >> From: [email protected] [mailto:[EMAIL PROTECTED] > On Behalf Of Marc > >> Sent: Wednesday, July 16, 2008 4:46 PM > >> To: RBASE-L Mailing List > >> Subject: [RBASE-L] - Re: Property ID Directory > .... > >> > >> Javier > >> > >> Yes, I thought about it but that is kind of new > ground for > >> me, so I stick to what I know. > >> > >> Most of my code is in Custom form actions and > EEPS. I > >> only use the APX for code that is used in several > forms or > >> new code I may change often and code I want to > keep private. > >> > >> One step at a time I am moving in that direction. > >> > >> Thanks > >> Marc > >> > >> > >> ----- Original Message ----- > >> From: "Javier Valencia" > <[EMAIL PROTECTED]> > >> To: "RBASE-L Mailing List" > <[email protected]> > >> Sent: Wednesday, July 16, 2008 4:08 PM > >> Subject: [RBASE-L] - Re: Property ID Directory > .... > >> > >> > >>> > >>> Marc: > >>> Have you considered doing away with your > external *.APX files? I have > >>> not > >>> used *.apx files for a while; all the code I > use is stored either in the > >>> forms or in a table from where I can execute > the code. I now have less > >>> clutter as there are fewer files to install at > the clients computers. > >>> You can technically store even your plug-ins > in the database and > >>> download > >>> the files when you start the application and > delete them when done. > >>> > >>> Javier, > >>> > >>> Javier Valencia > >>> 913-915-3137 > >>> -----Original Message----- > >>> From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of Marc > >>> Sent: Wednesday, July 16, 2008 3:08 PM > >>> To: RBASE-L Mailing List > >>> Subject: [RBASE-L] - Re: Property ID Directory > .... > >>> > >>> > >>> Jim > >>> > >>> Set Var VdbPath = (CVAL('DBPATH')) > >>> Property aaaID Directory .VdbPath > >>> > >>> Works and seems to reset something. > >>> > >>> I will check out the FindFile suggestion, > >>> sounds like it should work too. > >>> > >>> Thanks > >>> Marc > >>> > >>>> Don't forget the FILEFIND function. > Here is piece of code from one of > >>>> my > >>>> applications. Use it as you will. > >>>> > >>>> SET VAR gvApx > TEXT=(FINDFILE('DBDoc76.APX')) > >>>> IF gvApx IS NULL THEN > >>>> SET VAR vDlgMsg TEXT='Required files > missing from PATH:' > >>>> SET VAR vDlgMsg=(.vDlgMsg & > 'DBDoc76.APX') > >>>> SET VAR vDlgMsg= + > >>>> (.vDlgMsg + '. Place missing > file(s) in PATH. Then restart > >>>> application.') > >>>> PAUSE 1 USING .vDlgMsg AT CENTER CENTER > DEFAULT GRAY ON RED > >>>> EXIT > >>>> ENDIF > >>>> > >>>> > >>>> Jim Bentley > >>>> American Celiac Society > >>>> [EMAIL PROTECTED] > >>>> tel: 1-504-737-3293 > >>>> > >>>> > >>>> --- On Wed, 7/16/08, Marc > <[EMAIL PROTECTED]> wrote: > >>>> > >>>>> From: Marc > <[EMAIL PROTECTED]> > >>>>> Subject: [RBASE-L] - Re: Property ID > Directory .... > >>>>> To: "RBASE-L Mailing List" > <[email protected]> > >>>>> Date: Wednesday, July 16, 2008, 2:35 > PM > >>>>> HI Jim > >>>>> > >>>>> I never thought of that but I would > hate to do all that > >>>>> work. > >>>>> Trying to save energy you know! > >>>>> > >>>>> I was thinking about CVAL currDir or > something, then > >>>>> do the Property command on the 3rd tab > to reset it back to > >>>>> the > >>>>> correct dir. > >>>>> > >>>>> Leave it to me to so something > strange. > >>>>> > >>>>> Thanks > >>>>> Marc > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> ----- Original Message ----- > >>>>> From: "James Bentley" > >>>>> <[EMAIL PROTECTED]> > >>>>> To: "RBASE-L Mailing List" > >>>>> <[email protected]> > >>>>> Sent: Wednesday, July 16, 2008 2:17 PM > >>>>> Subject: [RBASE-L] - Re: Property ID > Directory .... > >>>>> > >>>>> > >>>>> > Marc, > >>>>> > > >>>>> > Not sure about the property > command. However, In my > >>>>> application I > >>>>> > actually set a global variable > with the full path to > >>>>> the ".APX" file such > >>>>> > as set gvapx text = > >>>>> 'c:\appdir\Prog7.apx'. > Then I would use: > >>>>> > Run Outone in &gvapx > >>>>> > That way no matter what the user > (or even worse me) > >>>>> does with directores > >>>>> > my application knows where the > ".APX" file > >>>>> is located. I got this idea > >>>>> > from a long ago technical > document. It was a lot of > >>>>> work to convert the > >>>>> > application, modifying forms, > reports, labels, and > >>>>> command file. Now the > >>>>> > only time I occasionally trip up > is when I am > >>>>> modifying a form or report > >>>>> > and forget to set the global > variable. > >>>>> > > >>>>> > Jim Bentley > >>>>> > American Celiac Society > >>>>> > [EMAIL PROTECTED] > >>>>> > tel: 1-504-737-3293 > >>>>> > > >>>>> > > >>>>> > --- On Wed, 7/16/08, Marc > >>>>> <[EMAIL PROTECTED]> wrote: > >>>>> > > >>>>> >> From: Marc > <[EMAIL PROTECTED]> > >>>>> >> Subject: [RBASE-L] - Property > ID Directory .... > >>>>> >> To: "RBASE-L Mailing > List" > >>>>> <[email protected]> > >>>>> >> Date: Wednesday, July 16, > 2008, 10:03 AM > >>>>> >> Hi > >>>>> >> > >>>>> >> Does PROPERTY scpathid > directory .vscanpath > >>>>> >> change the default folder > RBase looks for APEX > >>>>> files? > >>>>> >> > >>>>> >> I have a Tab form with 4 > tabs, on Tab 3 I have a > >>>>> Drop down > >>>>> >> menu to print reports the EEL > is like this > >>>>> >> Run Outone in Prog7.apx > --select printer... > >>>>> >> Print Report... > >>>>> >> > >>>>> >> On tab 4 I use the Property > ID Directory command > >>>>> to set a > >>>>> >> default > >>>>> >> folder to view files in a > File list view. > >>>>> >> > >>>>> >> If I click on the 4th tab > that run this Property > >>>>> command > >>>>> >> then click on > >>>>> >> Tab 3 the Run Outone in > Prog7.apx fails to run and > >>>>> I get an > >>>>> >> error saying > >>>>> >> can't find it in the > folder from the Property > >>>>> command. > >>>>> >> > >>>>> >> If I click on the 3rd tab > first it works fine. > >>>>> >> > >>>>> >> What am I missing? > >>>>> >> Marc > >>>>> >> > >>>>> >> > >>>>> >> > >>>>> >> ----- Original Message > ----- > >>>>> >> From: Marc > >>>>> >> To: RBASE-L Mailing List > >>>>> >> Sent: Wednesday, July 16, > 2008 8:31 AM > >>>>> >> Subject: [RBASE-L] - How > often should you Pack > >>>>> Index > >>>>> >> > >>>>> >> > >>>>> >> Hi > >>>>> >> > >>>>> >> We do a Unload all once a > month to rebuild the > >>>>> database > >>>>> >> but should I Pack the > Indexes once per week? > >>>>> >> > >>>>> >> Thanks > >>>>> >> Marc > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>>> > > >>>> > >>>> > >>>> > >>>> > >>>> > >>> > >>> > >> > >> > > > >
