Re: dynamic aggregate column

[Manoj Gurjar <mgurjar@HOTMAIL.COM>]

What error are u getting?

Or else try building entire Select statement in some string variable
and then use that variable in begin-select.

  let $SELECT_AMT = 'SUM(D.MONETARY_AMT_BSE)'

let $dyn_select = 'select.....blah blah...' || $SELECT_AMT ||
                     ' rest of the select blah blah..'

and then

begin-select
[$dyn_select]
end-select

hth,
manoj

>From: Allan Solemnidad <alleyal52@HOTMAIL.COM>
>Reply-To: sqr-users@list.iex.net
>To: SQR-USERS@list.iex.net
>Subject: dynamic aggregate column
>Date: Tue, 11 Jan 2000 13:53:13 PST
>
>Environment
>OS: Win NT
>RDBMS:  MS SQL Server 7.0
>SQR Ver:  4.3.2.2
>
>Hello All,
>
>I'm stumped on the syntax below.  Wondering how do you use the dynamic
>variable $SELECT_AMT with an aggregate column:
>
>using the [$SELECT_AMT] dynamic variable
>
>I've tried unsuccessfully using the following syntax:
>
>let $SELECT_AMT = 'D.MONETARY_AMT_BSE'       !using SUM([$SELECT_AMT])
>let $SELECT_AMT = 'SUM(D.MONETARY_AMT_BSE)'  !using [$SELECT_AMT]
>let $SELECT_AMT = 'D.MONETARY_AMT_BSE'       !using SUM( || [$SELECT_AMT]
>||
>)
>
>
>variables defined as:
>        let $BFR_FROM = 'PS_CC_VCHRHDRD_TAO A, PS_CC_DSTLNBK_TAO D'
>        let $AFTR_FROM = 'PS_CC_VCHRHDRD_TAO H, PS_DIST_LINE_BOOK G'
>        let $SELECT_AMT = 'SUM(D.MONETARY_AMT_BSE)'
>
>procedure
>begin-procedure Get-Before-Data
>
>begin-select
>D.BUSINESS_UNIT         &BFR_BU (+1,{c1}) ON-BREAK skiplines = 1
>A.RECON_FLG             &BFR_CATEGORY (,{c2})
>COUNT(*)                &BFR_COUNT  (,{c3})
>D.BASE_CURRENCY         &BFR_BASE_CUR (,{c4})
>D.LEDGER                &BFR_LEDGER (,{c5})
>D.PRIMARY_LEDGER        &BFR_PRIM_LEDGER  (,{c6})
>[$SELECT_AMT]           &BFR_SELECT_AMT=NUMBER (,{c7}) edit 999999.99
>
>FROM [$BFR_FROM]
>WHERE A.BUSINESS_UNIT = D.BUSINESS_UNIT
>AND A.VOUCHER_ID = D.VOUCHER_ID
>AND A.RECON_FLG = [$CATEGORY]
>GROUP BY D.BUSINESS_UNIT, A.RECON_FLG, D.BASE_CURRENCY,
>         D.LEDGER, D.PRIMARY_LEDGER
>
>end-select
>end-procedure Get-Before-Data
>
>
>Thanks in advance, Al
>______________________________________________________
>Get Your Private, Free Email at http://www.hotmail.com

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com