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 >>> > >>> > >>> > >>> > >>> > >> >> >> >> >> > > --- RBASE-L ================================================ 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) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ 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. ================================================
