topic Re: missing/misplaced FROM in App Development

missing/misplaced FROM

Sun, 29 Nov 2015 17:15:52 GMT

Hey everyone i am getting the following erroe but i don't realiy understand the problem

Syntax error, missing/misplaced FROM: INV_SALES: LOAD CUST_CUST AS INV_CUST, INV_IVDATE AS IVDATE, INV_INVNUM, CUST_AGENTNAME AS INV_AGENTNAME, IV_AGENT, IV_BRANCH, INV_TYPE, IV_PART, TRANS_COST, IV_QUANT, IV_QUANT*IF(DEBIT ='C',-1,1) AS RIV_QUANT, IV_PERCENT, IV_COMMISSION, IV_IVCOST, (IF(ISNULL(IV_TRANS) =-1,0,IV_TRANS)) AS IV_TRANS, IV_CREDITFLAG, (IF(DEBIT='C',(-1),1)) AS IVCAL_CREDIT, (IV_IVCOST * (IF (DEBIT ='C',(-1),1)) * (IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3 = INV_CURRENCY,FNC_EXCHANGE3, if(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))) AS NIS_TOTPRICE, (IV_IVCOST * (IF (DEBIT='C',(-1),1)) * (IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3=INV_CURRENCY,FNC_EXCHANGE3, IF(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))) / IF(FNC_EXCHANGE2 > 0 , FNC_EXCHANGE2, IF(CURREG_EXCHANGE2 > 0 , CURREG_EXCHANGE2 , CUR_EXCHANGE2)) AS DOLLAR_TOTPRICE, נבדק לא פה השגיאה של הדי באגר (IV_IVCOST * (IF (DEBIT='C',(-1),1)) * (IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3 = INV_CURRENCY,FNC_EXCHANGE3, IF(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))) / IF(CURREG_EXCHANGE3 > 0 , CURREG_EXCHANGE3 , CUR_EXCHANGE3) AS CURRENCY_TOTPRICE, CUST_CUST&'_'&IV_AGENT&'_'&IV_BRANCH&'_'&IV_PART&'_'&INV_IVDATE AS SALES_KEY RESIDENT INV_SALES_TEMP : INV_SALES: LOAD CUST_CUST AS INV_CUST, INV_IVDATE AS IVDATE, INV_INVNUM, CUST_AGENTNAME AS INV_AGENTNAME, IV_AGENT, IV_BRANCH, INV_TYPE, IV_PART, TRANS_COST, IV_QUANT, IV_QUANT*IF(DEBIT ='C',-1,1) AS RIV_QUANT, IV_PERCENT, IV_COMMISSION, IV_IVCOST, (IF(ISNULL(IV_TRANS) =-1,0,IV_TRANS)) AS IV_TRANS, IV_CREDITFLAG, (IF(DEBIT='C',(-1),1)) AS IVCAL_CREDIT, (IV_IVCOST * (IF (DEBIT ='C',(-1),1)) * (IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3 = INV_CURRENCY,FNC_EXCHANGE3, if(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))) AS NIS_TOTPRICE, (IV_IVCOST * (IF (DEBIT='C',(-1),1)) * (IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3=INV_CURRENCY,FNC_EXCHANGE3, IF(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))) / IF(FNC_EXCHANGE2 > 0 , FNC_EXCHANGE2, IF(CURREG_EXCHANGE2 > 0 , CURREG_EXCHANGE2 , CUR_EXCHANGE2)) AS DOLLAR_TOTPRICE, נבדק לא פה השגיאה של הדי באגר (IV_IVCOST * (IF (DEBIT='C',(-1),1)) * (IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3 = INV_CURRENCY,FNC_EXCHANGE3, IF(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))) / IF(CURREG_EXCHANGE3 > 0 , CURREG_EXCHANGE3 , CUR_EXCHANGE3) AS CURRENCY_TOTPRICE, CUST_CUST&'_'&IV_AGENT&'_'&IV_BRANCH&'_'&IV_PART&'_'&INV_IVDATE AS SALES_KEY RESIDENT INV_SALES_TEMP

Re: missing/misplaced FROM

swuehl — Mon, 30 Nov 2015 10:04:02 GMT

Yes, can't see any FROM statement.

Could you please post your actually script statement, not the unformatted errror message, which is hard to read anyway.

In addition, what is

נבדק לא פה השגיאה של הדי באגר (IV_IVCOST * (IF (DEBIT='C',(-1),1)) * (IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3 = INV_CURRENCY,FNC_EXCHANGE3, IF(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))) / IF(CURREG_EXCHANGE3 > 0 , CURREG_EXCHANGE3 , CUR_EXCHANGE3) AS CURRENCY_TOTPRICE,

supposed to do?

Re: missing/misplaced FROM

Mon, 30 Nov 2015 10:13:58 GMT

just noticed it thanks! now for some reason i am getting this error:

Error in expression: ')' expected: INV_SALES: LOAD CUST_CUST AS INV_CUST, INV_IVDATE AS IVDATE, INV_INVNUM, CUST_AGENTNAME AS INV_AGENTNAME, IV_AGENT, IV_BRANCH, INV_TYPE, IV_PART, TRANS_COST, IV_QUANT, IV_QUANT*IF(DEBIT ='C',-1,1) AS RIV_QUANT, IV_PERCENT, IV_COMMISSION, IV_IVCOST, (IF(ISNULL(IV_TRANS) =-1,0,IV_TRANS)) AS IV_TRANS, IV_CREDITFLAG, (IF(DEBIT='C',(-1),1)) AS IVCAL_CREDIT, (IV_IVCOST * (IF (DEBIT ='C',(-1),1)) * (IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3 = INV_CURRENCY,FNC_EXCHANGE3, if(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))) AS NIS_TOTPRICE, (IV_IVCOST * (IF (DEBIT='C',(-1),1)) * (IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3=INV_CURRENCY,FNC_EXCHANGE3, IF(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))) / IF(FNC_EXCHANGE2 > 0 , FNC_EXCHANGE2, IF(CURREG_EXCHANGE2 > 0 , CURREG_EXCHANGE2 , CUR_EXCHANGE2)) AS DOLLAR_TOTPRICE, (IV_IVCOST * (IF (DEBIT='C',(-1),1)) * (IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3 = INV_CURRENCY,FNC_EXCHANGE3, IF(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))) / IF(CURREG_EXCHANGE3 > 0 , CURREG_EXCHANGE3 , CUR_EXCHANGE3) AS CURRENCY_TOTPRICE, IF ((IsNull(TRANS_COST)=0 OR TRANS_COSTFLAG = 'M') OR (IV_TRANS <> 0 AND TRANS_CURDATE <=MAXACC_COSTDATE), TRANS_COST * (IF (TRANS_QUANT * IV_TQUANT < 0.0,(-1),1)), (IV_PART_COST * IV_QUANT / PART_COSTQUANT * (IF (DEBIT='C',(-1),1)) * (IF (IV_CREDITFLAG='Y',0,1)))) AS NIS_COST, IF ((IsNull(TRANS_SECONDCOST)= 0 OR TRANS_COSTFLAG = 'M') OR (IV_TRANS <> 0 AND TRANS_CURDATE <= MAXACC_COSTDATE), TRANS_SECONDCOST * (IF (TRANS_QUANT * IV_TQUANT < 0.0,(-1),1)), PART_SECONDCOST * IV_QUANT / PART_COSTQUANT * (IF (DEBIT ='C',(-1),1)) * (IF (IV_CREDITFLAG = 'Y',0,1))) AS DOLLAR_COST, (IF ((IsNull(TRANS_SECONDCOST)= 0 OR TRANS_COSTFLAG = 'M') OR (IV_TRANS <> 0 AND TRANS_CURDATE <= MAXACC_COSTDATE), TRANS_COST * (IF (TRANS_QUANT * IV_TQUANT < 0.0,(-1),1)), IV_PART_COST * IV_QUANT / PART_COSTQUANT * (IF (DEBIT ='C',(-1),1)) * (IF (IV_CREDITFLAG='Y',0,1))) ) / IF(CURREG_EXCHANGE3 > 0 ,CURREG_EXCHANGE3 , CUR_EXCHANGE3) AS CURRENCY_COST, (IV_DUTYCOST * (IF (DEBIT ='C',(-1),1)) * (IF((=1) AND IV_DUTYCOST <> 0,IV_IEXCHANGE,(IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3=INV_CURRENCY,FNC_EXCHANGE3, if(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))))) AS NIS_DUTYCOST, CUST_CUST&'_'&IV_AGENT&'_'&IV_BRANCH&'_'&IV_PART&'_'&INV_IVDATE AS SALES_KEY RESIDENT INV_SALES_TEMP

Re: missing/misplaced FROM

Mon, 30 Nov 2015 10:14:34 GMT

i got it for this script:

(IV_DUTYCOST * (IF (DEBIT ='C',(-1),1)) * (IF(($(vEXPORTEXCHANGE)=1) AND IV_DUTYCOST <> 0,IV_IEXCHANGE,(IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3=INV_CURRENCY,FNC_EXCHANGE3,

if(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE ))))))) AS NIS_DUTYCOST,

(IV_DUTYCOST * (IF (DEBIT = 'C',(-1),1)) * (IF(($(vEXPORTEXCHANGE) =1) AND IV_DUTYCOST <> 0,IV_IEXCHANGE,(IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3 = INV_CURRENCY,FNC_EXCHANGE3,

if(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE )))))))/ IF(FNC_EXCHANGE2 > 0 , FNC_EXCHANGE2, IF(CURREG_EXCHANGE2 > 0 ,

CURREG_EXCHANGE2 , CUR_EXCHANGE2)) As DOLLAR_DUTYCOST,

(IV_DUTYCOST * (IF (DEBIT ='C',(-1),1)) * (IF(($(vEXPORTEXCHANGE)=1) AND IV_DUTYCOST <> 0,IV_IEXCHANGE,(IF(INV_CURRENCY = (-1) ,1,IF(FNC_CURRENCY3=INV_CURRENCY,FNC_EXCHANGE3,

if(CURREG_EXCHANGE > 0 , CURREG_EXCHANGE, CUR_EXCHANGE )))))))/ IF(CURREG_EXCHANGE3 > 0 ,CURREG_EXCHANGE3 , CUR_EXCHANGE3) As CURRENCY_DUTYCOST,

Re: missing/misplaced FROM

undergrinder — Mon, 30 Nov 2015 11:07:34 GMT

Hi Jhonatan,

It is hard to say anything, but I'm sure it will be just a syntax problem.

Missing comma, extra comma, missing brackets, extra brackets whatever, missing semicolon and so on.

If I have to write a complex expressions , I'll check it in Notepad++ to ensure all brackets have pairs and so on.

Re: missing/misplaced FROM

sunny_talwar — Mon, 30 Nov 2015 11:12:11 GMT

How do you define vEXPORTEXCHANGE?