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

Are any of the other fields Zoned too?
Just an idea, first, why use zoned anyway, but how about changing it to 9P2
instead. Perhaps the expected result is going to be longer than the 8-digit
zoned field?

-Bob Cozzi
www.RPGxTools.com
If everything is under control, you are going too slow.
- Mario Andretti


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Douglas W. Palme
Sent: Thursday, July 14, 2005 11: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.