RE: ready to pull my hair out final SQL question of the day

Douglas,
        You need to define the size of "margin" otherwise the system will do
that for you.  Try this; 

        cast(sum(ipprice) - sum(ipcscst) as numeric(8,2)) as margin

This will create the result field as zoned 8.2.  


Thank you,
Matt Tyler
WinCo Foods, LLC
mattt@xxxxxxxxxxxxxx

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Douglas W. Palme
Sent: Thursday, July 14, 2005 10:18 AM
To: RPG Group
Subject: ready to pull my hair out final SQL question of the day

after this I am going to go home, throw the phone out the back door, fill 
the ice bucket with ice, grab a tumbler and a bottle of single malt and park

my carcus on the sofa and not move for the rest of the day......

I started expanding my select statement, which includes a calculated field :

sum(ilneprice) - sum(ilneuavcst) as margin

I have declared a variable dmargin as a type S length of 8 with two 
decimals.....so far so good....

In my fetch statement I have the following:


C/EXEC SQL                                                             
C+ FETCH DETAILCURSOR                                                  
C+ INTO :ALPHA, :CUSTNO, :DNAME, :STKNO, :DESC, :PRICE, :COST, :DMARGIN
C/END-EXEC

When I go to compile the sql precompiler balks and tells me that the 
variable DMARGIN is not defined or usable.....nothing else.

Its declared properly and everything else seems to work.  I checked the 
order of the select fields and that is ok as well.

I would post the relevant code but I did not want the message to be too
long.

Ideas?

If you bought, it was hauled by a truck - somewhere, sometime.