Garbage after statement

Mon, 30 Nov 2015 09:43:57 GMT

Hey for some reason i am getting this error :

Garbage after statement: Returns: Load TRANS_TYPE, TRANS_CURDATE, (if(TRANS_TYPE='X',TRANS_IVCUST,TRANS_CUST))AS TRANS_CUST, TRANS_BRANCH, TRANS_DOCNO, TRANS_IVNUM, (if(TRANS_TYPE='X',TRANS_IVAGENT,TRANS_DOCAGENT)) AS TRANS_AGENT, TRANS_PART, TRANS_IVCOST, TRANS_IVIEXCHANGE, TRANS_IVPRICE , TRANS_TQUANT, TRANS_IVTQUANT, IF(TRANS_TYPE= 'X',NIS_TRANS_IVPRICE, (TRANS_PRICE * TRANS_TQUANT) * (100 - TRANS_PERCENT)/100 * (IF (TRANS_TYPE='N',(-1),1)) * TRANS_IEXCHANGE * (100 - TRANS_DOCPERCENT)/100) AS NIS_TRANS_TOTPRICE, IF(TRANS_TYPE= 'X',NIS_TRANS_IVPRICE, (TRANS_PRICE * TRANS_TQUANT) * (100 - TRANS_PERCENT)/100 * (IF (TRANS_TYPE='N',(-1),1)) * TRANS_IEXCHANGE * (100 - TRANS_DOCPERCENT)/100) / (IF(CURREG_EXCHANGE2 > 0 ,CURREG_EXCHANGE2 , CUR_EXCHANGE2) ) AS DOLLAR_TRANS_TOTPRICE, IF(TRANS_TYPE= 'X',NIS_TRANS_IVPRICE, (TRANS_PRICE * TRANS_TQUANT) * (100 - TRANS_PERCENT)/100 * (IF (TRANS_TYPE='N',(-1),1)) * TRANS_IEXCHANGE * (100 - TRANS_DOCPERCENT)/100) / (IF(CURREG_EXCHANGE3 > 0 ,CURREG_EXCHANGE3 , CUR_EXCHANGE3) ) AS CURRENCY_TRANS_TOTPRICE (if(TRANS_TYPE='X',TRANS_IVCUST,TRANS_CUST))& '_' & (if(TRANS_TYPE='X',TRANS_IVAGENT,TRANS_DOCAGENT))& '_' & TRANS_BRANCH&'_' & TRANS_PART & '_'& TRANS_CURDATE AS Sales_KEY Resident Returns_tmp Where TRANS_CURDATE >= '01/01/2010'

Re: Garbage after statement

MK_QSL — Mon, 30 Nov 2015 09:50:24 GMT

You missed comma after AS CURRENCY_TRANS_TOTPRICE

IF(TRANS_TYPE= 'X',NIS_TRANS_IVPRICE, (TRANS_PRICE * TRANS_TQUANT) * (100 - TRANS_PERCENT)/100 * (IF (TRANS_TYPE='N',(-1),1)) * TRANS_IEXCHANGE * (100 - TRANS_DOCPERCENT)/100) / (IF(CURREG_EXCHANGE3 > 0 ,CURREG_EXCHANGE3 , CUR_EXCHANGE3) ) AS CURRENCY_TRANS_TOTPRICE,

topic Garbage after statement in App Development

Garbage after statement

Re: Garbage after statement