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
>
>
>
>
>
