<HTML >
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2900.3132" name=GENERATOR></HEAD>
<BODY >
<DIV>
<DIV><SPAN class=604263719-09072007><FONT face=Arial color=#0000ff
size=2>Interesting idea. Can I get a feel from the list as to how often people
modify the PATH procedure? And would something like this reduce that need? Why
else do you write your own PATH procedures?</FONT></SPAN></DIV>
<DIV><SPAN class=604263719-09072007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=604263719-09072007><FONT face=Arial color=#0000ff size=2>We
generate the PATH and FIND based on ACCESS statements (specified or implied) for
the PRIMARY file. The two procedures are tied together. The generation is fairly
basic at this point.</FONT></SPAN></DIV>
<DIV><SPAN class=604263719-09072007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=604263719-09072007><FONT face=Arial color=#0000ff
size=2>Bob</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com
[mailto:powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com] <B>On Behalf
Of </B>Ken Langendock<BR><B>Sent:</B> June 25, 2007 8:33 AM<BR><B>To:</B>
powerh-l@lists.sowder.com<BR><B>Subject:</B> Powerhouse Enhancement - ACCESS,
VIA, USING, IF<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=187352512-25062007>Here is a new
enhancement targeted at reducing the number of times a programmer has
to hard code the PATH procedure.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=187352512-25062007></SPAN></FONT> </DIV>
<DIV><FONT face=Courier size=2><SPAN class=187352512-25062007>FILE Users
PRIMARY</SPAN></FONT></DIV>
<DIV><FONT face=Courier size=2><SPAN class=187352512-25062007> ACCESS
VIA UserId &</SPAN></FONT></DIV>
<DIV><FONT face=Courier size=2><SPAN
class=187352512-25062007> USING T-UserId
&</SPAN></FONT></DIV>
<DIV><FONT face=Courier color=#ff0000 size=2><SPAN
class=187352512-25062007>
IF T-UserId NE " "</SPAN></FONT></DIV>
<DIV><FONT face=Courier size=2><SPAN class=187352512-25062007> ACCESS
VIA UserId &</SPAN></FONT></DIV>
<DIV><FONT face=Courier size=2><SPAN
class=187352512-25062007> USING UserId
&</SPAN></FONT></DIV>
<DIV><FONT face=Courier size=2><SPAN
class=187352512-25062007> REQUEST
UserId</SPAN></FONT></DIV>
<DIV><FONT face=Courier size=2><SPAN class=187352512-25062007> ACCESS
SEQUENTIAL</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=187352512-25062007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=187352512-25062007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=187352512-25062007>This new feature
would generate a PATH statement similar to the following thus removing the
requirement of hard coding the PATH every time we want to "override" the
default path because of passed-in values or re-finding based on a temporary
item. etc.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=187352512-25062007></SPAN></FONT> </DIV>
<DIV><FONT face=Courier size=2><SPAN class=187352512-25062007>PROCEDURE
PATH</SPAN></FONT></DIV>
<DIV><FONT face=Courier size=2><SPAN
class=187352512-25062007>BEGIN</SPAN></FONT></DIV>
<DIV><FONT face=Courier size=2><SPAN class=187352512-25062007> IF
T-UserId NE " "</SPAN></FONT></DIV>
<DIV><FONT face=Courier size=2><SPAN
class=187352512-25062007> THEN LET PATH =
1</SPAN></FONT></DIV>
<DIV><FONT face=Courier size=2><SPAN class=187352512-25062007> IF PATH =
0</SPAN></FONT></DIV>
<DIV><FONT face=Courier size=2><SPAN
class=187352512-25062007> THEN PROMPT
T-UserId</SPAN></FONT></DIV>
<DIV><FONT face=Courier size=2><SPAN
class=187352512-25062007>...</SPAN></FONT></DIV>
<DIV><FONT face=Courier size=2><SPAN
class=187352512-25062007>END</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=187352512-25062007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=187352512-25062007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=187352512-25062007>Ken</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=187352512-25062007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<P></P>
<DIV> </DIV></BLOCKQUOTE></DIV>
<DIV> </DIV>
<DIV> This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you. </DIV></BODY></HTML>