<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV dir=ltr align=left><SPAN class=234264813-11072007><FONT face=Arial
color=#0000ff size=2>Sooooooooooooooo, I should have my answer in about 10
minutes or so???</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=234264813-11072007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Deskin, Bob [mailto:Bob.Deskin@Cognos.COM]
<BR><B>Sent:</B> July 11, 2007 9:43 AM<BR><B>To:</B> Ken Langendock;
mcl_systems@telus.net<BR><B>Cc:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B>
RE: Powerhouse Enhancement - ACCESS VIA, USING, IF<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=401054213-11072007><FONT face=Arial color=#0000ff size=2>I
suspect it wouldn't make much difference in development time for us. We'd
basically encapsulate everything generated from that ACCESS statement within the
IF. On the surface it looks straightforward, but I need to think about side
effects, inter-relationship with the FIND procedure, relational database
effects, etc.</FONT></SPAN></DIV>
<DIV><SPAN class=401054213-11072007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=401054213-11072007><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> Ken Langendock
[mailto:Ken@Langendock.com] <BR><B>Sent:</B> July 11, 2007 9:40
AM<BR><B>To:</B> Deskin, Bob; mcl_systems@telus.net<BR><B>Cc:</B>
powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: Powerhouse Enhancement -
ACCESS VIA, USING, IF<BR><BR></FONT></DIV>
<DIV dir=ltr align=left><SPAN class=093433713-11072007><FONT face=Arial
color=#0000ff size=2>As an option to make the implementation easier you could
make the REQUEST and IF mutually exclusive.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=093433713-11072007><FONT face=Arial
color=#0000ff size=2>I think it would be better in the long run to be able to
specify both, but for the example provided that would be
enough.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=093433713-11072007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=093433713-11072007><FONT face=Arial
color=#0000ff size=2>Ken</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=093433713-11072007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Deskin, Bob
[mailto:Bob.Deskin@Cognos.COM] <BR><B>Sent:</B> July 11, 2007 9:33
AM<BR><B>To:</B> mcl_systems@telus.net<BR><B>Cc:</B> Ken Langendock;
powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: Powerhouse Enhancement -
ACCESS, VIA, USING, IF<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=751023313-11072007><FONT face=Arial color=#0000ff
size=2>Okay. I'll think on this one. As usual, no
promises.</FONT></SPAN></DIV>
<DIV><SPAN class=751023313-11072007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=751023313-11072007><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> Michael Lee
[mailto:mcl_systems@telus.net] <BR><B>Sent:</B> July 9, 2007 6:37
PM<BR><B>To:</B> Deskin, Bob<BR><B>Cc:</B> Ken Langendock;
powerh-l@lists.sowder.com<BR><B>Subject:</B> Re: Powerhouse Enhancement -
ACCESS, VIA, USING, IF<BR><BR></FONT></DIV>That's a great suggestion. I've
had to modify the PATH and FIND procedure several times for just such cases.
<BR><BR><BR>Deskin, Bob wrote:<BR>
<BLOCKQUOTE
cite=mid2B4E386EAEC90947802323BF373DC0EC0B971CD3@sottemail1.ent.ad.cognos.com
type="cite">
<META content="MSHTML 6.00.2900.3132" name=GENERATOR>
<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> </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> </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 class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> <A
class=moz-txt-link-abbreviated
href="mailto:powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com">powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com</A>
[<A class=moz-txt-link-freetext
href="mailto:powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com">mailto:powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com</A>]
<B>On Behalf Of </B>Ken Langendock<BR><B>Sent:</B> June 25, 2007 8:33
AM<BR><B>To:</B> <A class=moz-txt-link-abbreviated
href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A><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> </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> </DIV>
<DIV> </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> </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> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=187352512-25062007>Ken</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<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></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>