<!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.2900.3132" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV><SPAN class=384215013-11072007><FONT face=Arial color=#0000ff size=2>Don't
know if I still think that fast :-) And I do have some other things to do
first.</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:49
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=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></BLOCKQUOTE></BODY></HTML>