Re[2]: QUICK - Bridge

[Hamilton, Allison]

 Roshan
I suppose the simplest answer is that 'twas ever thus.  Yes, I know
that's not a very good answer.  When I first joined COGNOS, I think I
did figure out why this happened but that was a decade ago, and I've
forgotten.  This is one of the PowerHouse folklore tidbits that I've
used for 19 years now (yes, I've been a QUIZ user for that long!) and
it's just become habit to code things with the expression on the right.
It does pose a problem if you want to compare two expressions though!
You sometimes have to put one into a temporary and compare the temp with
the second expression.
Allison Hamilton

> ----------
> From: 	rshah@mcp.com[SMTP:rshah@mcp.com]
> Sent: 	Wednesday, June 03, 1998 4:40 PM
> To: 	powerh-l@lists.swau.edu; Conley; Steve
> Subject: 	Re[2]: QUICK - Bridge
> 
>      Thanks Steve,
>      
>      It works this way without introducing any new variables...
>      
>      QUESTION to COGNOS - Why is it so ??
>      
>      Why does ( Expr > Value ) not work
>      
>      and
>      
>      ( value < Expr ) work ??
>      
>      
>      Roshan
> 
> 
> ______________________________ Reply Separator
> _________________________________
> Subject: RE: QUICK - Bridge
> Author:  "Conley; Steve" <SConley@VICTORIA.COM> at internet
> Date:    6/3/98 1:29 PM
> 
> 
> Roshan,
>      
> I believe that you have to move your equation to the other side of the
> 
> operator.  Notice that the sample code does not compile until I put
> the 
> arithmetic operation to the right side of the > sign.  I have always
> had 
> more success with any calculations to the right side.
>      
> VSSDAC-->TY TESTQKS.LIS
> > SCREEN RCPTCTL
> > FILE RCPTCTL
> > FIELD PO_RCTL OF RCPTCTL
> > PROCEDURE INIT
> > BEGIN
> >  IF ((1*50) > PO_RCTL)
>          ^
> *E* Expected:  <  =  >  GT  LT  EQ  LE  GE  NE  EXISTS  IS  MISSING
> NULL
>          ^
> >   THEN BEGIN
> >    INFO "IT WORKS"
> >   END
> > END
> > REV
>      
> change with calc on right side of comparison!!!!
>      
> CAN CLE
> SCREEN RCPTCTL
> FILE RCPTCTL
> FIELD PO_RCTL OF RCPTCTL
> PROCEDURE INIT
> BEGIN
>  IF (PO_RCTL < (1*50))
>   THEN BEGIN
>    INFO "IT WORKS"
>   END
> END
>      
>      
> > -----Original Message-----
> > From: rshah@mcp.com [SMTP:rshah@mcp.com] 
> > Sent: Wednesday, June 03, 1998 2:51 PM
> > To:   powerh-l@lists.swau.edu
> > Subject:      QUICK - Bridge
> > 
> >      Hello Listers
> >      
> >      During the Compilation of QUICK Screens .... the floowing piece
> of 
> >      code gives me error
> >      
> >      
> >      Y2KARRSB at the end of the line shows the new code added.... 
> >      
> >      
> >      
> >    IF PY-TYPE OF ORDER-HEADER = 9 AND OH-PAYTYPE NE 3 AND PY-FLAG LT
> 1 
> >    THEN BEGIN
> >      LET CU-CUSTNO    OF AR-AUDIT-CASH = CU-BILLTO    OF
> ORDER-HEADER 
> >      LET IV-NUMBER    OF AR-AUDIT-CASH = IV-NUMBER    OF
> ORDER-HEADER 
> >      LET CU-NAME      OF AR-AUDIT-CASH = CU-NAME OF CUSTOMER
> >      IF (( MOD( FLOOR( AU-CHECKDATE OF ORDER-HEADER / 10000) &
> ;Y2KARRSB 
> >      ,100 )) < 50 )
> ;Y2KARRSB 
> >      THEN BEGIN
> ;Y2KARRSB 
> >      LET AR-YEAR      OF AR-AUDIT-CASH = &
> >          2000 + MOD( FLOOR(AU-CHECKDATE OF ORDER-HEADER /
> 10000)&;Y2KARRSB 
> >          , 100)
> ;Y2KARRSB 
> >      END
> ;Y2KARRSB 
> > 
> >      
> >      
> >      ....
> >      ....
> >      
> >      
> >      
> >      I get the Error after IF (( MOD ( FLoor 
> >       
> >      
> >      Any help appreciated well in advance... 
> >      
> >      Roshan
> > = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> = = = 
> > =
> > Subscribe: "subscribe powerh-l" in message body to 
> > majordomo@lists.swau.edu
> > Unsubscribe: "unsubscribe powerh-l" in message to
> majordomo@lists.swau.edu 
> > powerh-l@lists.swau.edu is gatewayed one-way to
> bit.listserv.powerh-l
> > This list is closed, thus to post to the list, you must be a
> subscriber. 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> = = = 
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu 
> Unsubscribe: "unsubscribe powerh-l" in message to
> majordomo@lists.swau.edu 
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a
> subscriber.
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> = = =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to
> majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a
> subscriber.
> 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.