Re[2]: QUICK - Bridge

[rshah@mcp.com]

     John,
     
     AR-YEAR is NUM*4  ( after it is expanded from NUM*2) in our
                        application )
     
     We are going a subsystem at a time in which :
     
     1) AR-YEAR in couple of Datasets is NUM*2 
     2) Changed one have NUM*4
     
     We have to build bridges when data goes across multiple subsystems.
     
     Now from your mail 
     
     1) How do I use ADDCENTURY for a NUM*4 field ?
     
     
     Err... forgot to mention We are on 7.09

     
    Roshan Shah
    Consultant
    "Man made Computer - Man must be able to Fix anything"

______________________________ Reply Separator _________________________________
Subject: RE: QUICK - Bridge
Author:  pickerij@norbord.com at internet
Date:    6/3/98 2:34 PM


Consider this ugly chunk of code ...
     
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
     
... which could so simply become ...
     
let AR-YEAR  OF AR-AUDIT-CASH &
  =  addcentury(AU-CHECKDATE OF ORDER-HEADER , &
         century(AU-CHECKDATE OF ORDER-HEADER ))
     
... if Cognos would ever deliver our copy of version 8.1x   :-(
     
     
John "still waiting" Pickering
JWP Systems Inc
Toronto
     
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
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.