× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.