<HTML xmlns:eXclaimer="http://www.exclaimer.co.uk">
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=UTF-16">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-16">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 5.50.4943.400" name=GENERATOR>
<STYLE>@font-face {
font-family: Tahoma;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: blue; TEXT-DECORATION: underline
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman"
}
SPAN.EmailStyle18 {
COLOR: navy; FONT-FAMILY: Arial
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD><BODY lang=EN-US vLink=blue link=blue><DIV>
<DIV><SPAN class=939135110-23092005><FONT face=Arial color=#0000ff size=2>The
PowerHouse parser requires that expressions appear on the right in a condition.
If you have a simple item name on the left it will work, i.e. IF ITEM_NAME = 0,
however, once you have an expression or substring, the constant must go on the
left and the expression on the right, i.e. IF 0 = SIZE(FIELDTEXT). This
also means that if you're comparing two expressions, you have to declare at
least one of them as a DEFINE and use that on the left. I know that strictly
speaking you could argue that it's still an expression, but that's the way the
parser works rather than when it's processed.</FONT></SPAN></DIV>
<DIV><SPAN class=939135110-23092005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=939135110-23092005><FONT face=Arial color=#0000ff size=2>So the
parser checks tokens and loads the expression processor at parse time. The
parser doesn't mind a simple item on the left even if it's a defined item
because it's the item reference that's loaded. At execution time, the expression
processor sees the defined item reference, evaluates the define and then
proceeds with the expression on the right.</FONT></SPAN></DIV>
<DIV><SPAN class=939135110-23092005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=939135110-23092005><FONT face=Arial color=#0000ff size=2>As for
why the parser is like this, I don't know. That's the way it was written many
years ago and we never changed. At this point we won't because we don't want to
introduce any negative functional differences (bugs or
otherwise).</FONT></SPAN></DIV>
<DIV><SPAN class=939135110-23092005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=939135110-23092005><FONT face=Arial color=#0000ff size=2>Sorry
if that was a bit long winded.</FONT></SPAN></DIV>
<DIV><SPAN class=939135110-23092005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=939135110-23092005><FONT face=Arial color=#0000ff
size=2>Bob</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader 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>fernando.olmos@hpa.com.au<BR><B>Sent:</B> September 22, 2005 9:18
PM<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: I need proof
of this...<BR><BR></FONT></DIV>
<DIV><SPAN class=766481601-23092005><FONT face=Arial color=#0000ff size=2>So
you're saying that if I have a field without a value on the left hand side,
the program will fail? But I thought all temporaries default to 0 or blank
before they are used? This sounds familiar. Thanks</FONT></SPAN></DIV>
<DIV><SPAN class=766481601-23092005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
mgo@columbus.rr.com [mailto:mgo@columbus.rr.com] <BR><B>Sent:</B> Friday,
September 23, 2005 11:15 AM<BR><B>To:</B> Fernando Olmos;
powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: I need proof of
this...<BR><BR></FONT></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><!-- Converted from text/rtf format -->Fernando,</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Powerhouse must have
a constant value or one field that contains a value on the left side of the
comparison operation. The right side may contain equations or other values
that can be derived and distilled into a value for the purpose of the
comparison.</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Mike</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original
Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B>
powerh-l-bounces+mgo=columbus.rr.com@lists.sowder.com
[mailto:powerh-l-bounces+mgo=columbus.rr.com@lists.sowder.com] <B><SPAN
style="FONT-WEIGHT: bold">On Behalf Of
</SPAN></B>fernando.olmos@hpa.com.au<BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Thursday, September 22, 2005 9:07
PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B>
powerh-l@lists.sowder.com<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> I need proof of
this...</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I cannot remember why I do it this
way, but I was wondering if someone out there may be able to help me
remember.</SPAN></FONT> </P>
<P style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">For some reason, I write my IF
statements with the literal FIRST before the item been tested
...</SPAN></FONT> </P>
<P style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">i.e.: if 0 = t_field1
...</SPAN></FONT> </P>
<P style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Some people write it as
...</SPAN></FONT> </P>
<P style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">
</SPAN></FONT><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">if t_field1 = 0 ...</SPAN></FONT>
</P>
<P style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Now I would prefer to do it the
2nd way, but I believe there are some cases in Powerhouse where it gets
confused if you do it like in the 2nd method. I think if you tried
...</SPAN></FONT></P>
<P style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">
</SPAN></FONT><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">if index(T_field, "string") >
0</SPAN></FONT> </P>
<P style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">it's not the same as
...</SPAN></FONT> <BR> <FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">if 0 <
index (t_field, "string")</SPAN></FONT> </P>
<P style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Now I know that sounds ridiculous,
but I did come across problems with this years ago, but I don't remember
exactly what it was. The point now is that I have got stuck into a habit with
the 1st method mentioned above.</SPAN></FONT></P>
<P style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Cheers</SPAN></FONT> </P>
<P style="MARGIN-LEFT: 0.5in"><I><FONT face=Arial color=blue size=4><SPAN
style="FONT-SIZE: 13.5pt; COLOR: blue; FONT-STYLE: italic; FONT-FAMILY: Arial">Fernando
Olmos</SPAN></FONT></I> <BR><B><FONT face=Arial size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">M.I.S.</SPAN></FONT></B>
</P>
<P style="MARGIN-LEFT: 0.5in"><B><FONT face=Arial color=blue size=2><SPAN
lang=EN-AU
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">HPA</SPAN></FONT></B><FONT
face=Arial><SPAN style="FONT-FAMILY: Arial"><BR></SPAN></FONT><FONT face=Arial
color=black size=2><SPAN lang=EN-AU
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial">Direct: 03
9217 5411</SPAN></FONT><BR><FONT face=Arial color=black size=2><SPAN
lang=EN-AU style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial">Mobile:
0410 382 857</SPAN></FONT><FONT face=Arial><SPAN
style="FONT-FAMILY: Arial"><BR></SPAN></FONT><FONT face=Arial color=black
size=2><SPAN lang=EN-AU
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial">Fax:
03 9217 5716</SPAN></FONT><SPAN lang=EN-AU> </SPAN></P>
<P style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><A
href="file:///H:\Appdata\Microsoft\Signatures\www.hpa.com.au"><B><FONT
face=Arial size=2><SPAN lang=EN-AU
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial">www.hpa.com.au</SPAN></FONT></B></A>
</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV></BLOCKQUOTE></DIV>
<DIV> </DIV>
<DIV> <FONT FACE="Arial" SIZE="2">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.</FONT>
</DIV>
<DIV>
<P>
<FONT FACE="Arial" SIZE="2"> </FONT>
</P>
</DIV></BODY></HTML>