Re: RUNSQSTM

[Buck Calabro <kc2hiz@xxxxxxxxx>]

On 5/29/2013 4:26 PM, Crystal Reports wrote:

> I have loaded an sql statements into a text member and this does not work as RUNSQLSTM, yet this does work under STRSQL.
>  
> SELECT  IDDOCD AS INV_DATE, IDORD# AS ORD_NUM,         
> IDORDT  AS ORD_TYPE, IDPRLC AS PROD_FAMILY,            
> IDPR$C AS PRICE_CODE,IDCOM#,                           
> MAX(IDPRT#) AS ITEM_REF,IARCC4 AS PROD_TYPE,           
> IARC11 AS PROD_CLASS,IACMQC AS CUM_CODE,               
> SUM(IDSHP#) AS NUM_UNITS,                              
> SUM(IDSHP# * IDCSU$) AS TOT_COST,                      
> SUM(IDSHP# * IDNTU$) AS TOT_SLS                        
> FROM   OEIND94 INNER JOIN ICPRT1   ON IDPRT# = IAPRT#  
> WHERE  IDCOM#='001' AND                                
> IDDOCD >= 20130401    AND                              
> IDDOCD <= 20130430  AND                                
> IARCC4='FIN'                                           
> GROUP BY IDDOCD, IDORD#,IDORDT,IDPRLC,IDPR$C,          
> IDCOM#,IARCC4,IARC11,IACMQC ORDER BY  IDDOCD,IDORD#,   
> IDORDT,IDPRLC,IDCOM#                                   

Yep, as explained earlier, RUNSQLSTM will not process SELECT statements.
 Try it in STRSQL instead.
  --buck