Re: placements???????

[Bob Helm <Bob.Helm@MEDIWARE.COM>]

Or perhaps use the EVALUATE statements.

B
The Programmer formerly known as Bob
Mediware Information Systems Inc.
(913) 307-1045
Bob.Helm@Mediware.com


This message has been sent using 100% recycled electrons


-----Original Message-----
From: Sam Spritzer [mailto:teknogeek9@YAHOO.COM]
Sent: Wednesday, March 20, 2002 1:15 PM
To: SQR-USERS@list.iex.net
Subject: Re: placements???????


The problem lies with the use of CASE.  While that might be acceptable in
SQL
Server, it isn't in SQR.  What Jennifer means is to rewrite your CASE part
into
IF-THEN-ELSE statements.
SQRly yours,
Sam


--- chandrashekhar jinna <csjinna@YAHOO.COM> wrote:
> thanks Jennifer
>
> I understand that ELSE is used with IF but the query
> works fine and fetches the result....the problem comes
> when I wanna put it in SQR.
>
>
> --- Jennifer Tran <jtran@BMS.CALSTATE.EDU> wrote:
> > Check the syntax you are using for WHEN statement.
> > ELSE is used in
> > combination with IF/ENIF statement.
> > Jennifer
> >
> > chandrashekhar jinna wrote:
> >
> > > hi,
> > > I have a following query which is running fine.
> > but
> > > when I am trying to add it to my SQR it is
> > allowing me
> > > to do so.. am I wrong somewhere with the placement
> > > parameters..or may be something ele??????
> > >
> > > the following is the Query and then follows the
> > SQR
> > > Procedure and lastly the error!!! Help appreciated
> > >
> > > ***********Query*********
> > > SELECT B.DESCR,R.ACAD_GROUP,
> > > (CASE WHEN IsNull(CBT.CRSE_RATE_ID,'')=''
> > >    THEN CBT.AMT_PER_UNIT
> > >    ELSE R.AMT_PER_UNIT
> > >   END) AS AMT_PER_UNIT,
> > >  (CASE WHEN IsNull(CBT.CRSE_RATE_ID,'')=''
> > >    THEN CBT.FLAT_AMT
> > >    ELSE R.FLAT_AMT
> > >   END) AS FLAT_AMT,
> > >  CBT.CRSE_RATE_ID
> > > FROM PS_CLASS_SBFEE_TBL CBT
> > > INNER JOIN PS_ITEM_TYPE_TBL B ON
> > > CBT.ITEM_TYPE=B.ITEM_TYPE AND CBT.SETID=B.SETID
> > > LEFT JOIN PS_CRSE_RATE_TBL R  ON
> > > CBT.CRSE_RATE_ID=R.CRSE_RATE_ID AND
> > CBT.SETID=R.SETID
> > > WHERE   CBT.SETID = 'MATC1'
> > >         AND CBT.STRM = '1014'
> > >         AND CBT.CRSE_ID = '000562'
> > >         AND CBT.CRSE_OFFER_NBR = '1'
> > >         AND (R.ACAD_GROUP='ASSOC' OR
> > > IsNull(R.ACAD_GROUP,'')='')
> > > ****************************
> > >
> > > **********sqr procedure*********
> > > BEGIN-PROCEDURE GET-CLASS-AMOUNTS
> > > !*************************************
> > >         LET #AMT_PER_UNIT = 0
> > >         LET #FLAT_AMT = 0
> > > BEGIN-SELECT
> > > B.DESCR
> > > (CASE WHEN IsNull(CBT.CRSE_RATE_ID,'')='' THEN
> > > CBT.AMT_PER_UNIT ELSE R.AMT_PER_UNIT END)
> > > (CASE WHEN IsNull(CBT.CRSE_RATE_ID,'')='' THEN
> > > CBT.FLAT_AMT ELSE R.FLAT_AMT END)
> > > FROM
> > > PS_CLASS_SBFEE_TBL CBT
> > > INNER JOIN PS_ITEM_TYPE_TBL B ON
> > > CBT.ITEM_TYPE=B.ITEM_TYPE AND CBT.SETID=B.SETID
> > > LEFT JOIN PS_CRSE_RATE_TBL R  ON
> > > CBT.CRSE_RATE_ID=R.CRSE_RATE_ID AND
> > CBT.SETID=R.SETID
> > > WHERE   CBT.SETID = $INSTITUTE
> > >         AND CBT.STRM = $STRM
> > >         AND CBT.CRSE_ID = $COURSE_ID
> > >         AND CBT.CRSE_OFFER_NBR = #CRSE_OFFER_NBR
> > >
> > > END-SELECT
> > > !*************************************
> > > END-PROCEDURE
> > >
> > > **********error****************8
> > > (SQR 5528) ODBC SQL dbdesc: SQLNumResultCols error
> > 156
> > > in cursor 13:
> > >    [Microsoft][ODBC SQL Server Driver][SQL
> > > Server]Incorrect syntax near the keyword 'CASE'.
> > >
> > > Error on line 201:
> > >    (SQR 3716) Error in SQL statement.
> > >
> > > Errors were found in the program file.
> > >
> > > SQR: Program Aborting.
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Yahoo! Sports - live college hoops coverage
> > > http://sports.yahoo.com/
> >
> > --
> > *********************************
> > California State University
> >        -----------
> >         Jennifer Tran
> > Email: jtran@bms.calstate.edu
> > Phone: (562)951-4395
> >
> >  Making everyday a better day
> > *********************************
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Sports - live college hoops coverage
> http://sports.yahoo.com/


=====
************************************************************
"In the beginning, there was something...which exploded yet, they find
nothing."

__________________________________________________
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
http://sports.yahoo.com/