Re: SQL System error in program

[Rob Berendt <rob@xxxxxxxxx>]

First question:
Why is :H in there twice back to back on the into clause?

Second question:
Why are you using a sum instead of TQTY itself?  You are not doing any 
grouping.  And, you are comparing this Sum with a row value, TLOT.

Third question:
Are both TLOT and TPROD really supposed to be equal to the sum of TQTY?

Maybe the reason that this occasionally works is that, since there is no 
sorting, the rows come up in a different order.





Glenn-Cons.T.Geathers@am.pnu.com on 03/31/99 05:40:07 PM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     midrange-l@midrange.com@Internet
cc:      

Subject:        Re: SQL System error in program

      SELECT SUM ( TQTY ) INTO : H : H FROM V_ITH AS ITH WHERE TLOT = : H 
     AND TPROD =  
          : H AND TID = 'TH' AND EXISTS ( SELECT CCCODE FROM V_ZCC WHERE 
     CCTABL =      
          'APINTER' AND CCID = 'CC' AND CCCODE = ITH . TTYPE )              
  
     
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---