6 Replies Latest reply: Nov 2, 2015 9:20 AM by Sasidhar Parupudi RSS

    Syntax error, missing/misplaced FROM

      i got this error but i cant realiy understand why....

       

      The following error occurred:

      Syntax error, missing/misplaced FROM:

      [Invoices]:

      LOAD

      [IVDATE] AS INVOICES_IVDATE,

      [IVNUM],

      [DOC],

      [IV] AS INVOICES_IV,

      [QPRICE] AS INVOICES_QPRICE,

      [TOTPRICE] AS INVOICES_TOTPRICE,

      [CURRENCY] AS INVOICES_CURRENCY,

      [CUST] AS INVOICES_CUST,

      [DEBIT],

      [IVREF],

      [VAT],

      [UDATE] AS INVOICES_UDATE,

      [T$USER] AS INVOICES_T$USER,

      [PRINTED],

      [FINAL],

      [ORD],

      [DISCOUNT],

      [DISPRICE],

      [MONTHLY] AS INVOICES_MONTHLY,

      [PAY] AS INVOICES_PAY ,

      [FNCPATTERN] AS INVOICES_FNCPATTERN,

      [PAYDATE],

      [FNCTRANS],

      [BOOKNUM]AS INVOICES_BOOKNUM ,

      [AGENT] AS INVOICES_AGENTS,

      [PIV],

      [CALQPRICE] AS INVOICES_CALQPRICE,

      [TYPE] AS INVOICES_TYPE,

      [CHECKING],

      [IMPFILE],

      [IMPFIVTYPE],

      [CASH] AS INVOICES_CASH,

      [TOCASH],

      [NOVATPRICE],

      [VATPRICE],

      [WARHS],

      [TOWARHS],

      [LCURRENCY],

      [LEXCHANGE],

      [WTAX],

      [AFTERWTAX],

      [WTAXPERCENT],

      [IVBALANCE],

      [ADVFLAG],

      [ACCOUNT] AS INVOICES_ACCOUNT,

      [CASHPAYMENT],

      [STORNOFLAG] AS INVOICES_STORNOFLAG,

      [TAX] AS INVOICES_TAX,

      [INTERNAL] AS AS INVOICES_INTERNAL,

      [BRANCH]AS INVOICES_BRANCH ,

      [LIV],

      [ADJPRICEFLAG],

      [FNCITEMSFLAG],

      [DETAILS],

      [OWNER] AS INVOICES_OWNER,

      [PHONE] AS INVOICES_PHONE,

      [DESTCODE],

      [SHIPTYPE] AS INVOICES_SHIPTYPE,

      [BALDATE],

      [PLIST],

      [T$PERCENT] AS INVOICES_T$PERCENT,

      [PACK],

      [MWEIGHT],

      [WEIGHT],

      [AIRWAYBILL]

      FROM [lib://clinton/Invoices.qvd] (qvd)

      The error occurred here:

      [Invoices]:

      LOAD

      [IVDATE] AS INVOICES_IVDATE,

      [IVNUM],

      [DOC],

      [IV] AS INVOICES_IV,

      [QPRICE] AS INVOICES_QPRICE,

      [TOTPRICE] AS INVOICES_TOTPRICE,

      [CURRENCY] AS INVOICES_CURRENCY,

      [CUST] AS INVOICES_CUST,

      [DEBIT],

      [IVREF],

      [VAT],

      [UDATE] AS INVOICES_UDATE,

      [T$USER] AS INVOICES_T$USER,

      [PRINTED],

      [FINAL],

      [ORD],

      [DISCOUNT],

      [DISPRICE],

      [MONTHLY] AS INVOICES_MONTHLY,

      [PAY] AS INVOICES_PAY ,

      [FNCPATTERN] AS INVOICES_FNCPATTERN,

      [PAYDATE],

      [FNCTRANS],

      [BOOKNUM]AS INVOICES_BOOKNUM ,

      [AGENT] AS INVOICES_AGENTS,

      [PIV],

      [CALQPRICE] AS INVOICES_CALQPRICE,

      [TYPE] AS INVOICES_TYPE,

      [CHECKING],

      [IMPFILE],

      [IMPFIVTYPE],

      [CASH] AS INVOICES_CASH,

      [TOCASH],

      [NOVATPRICE],

      [VATPRICE],

      [WARHS],

      [TOWARHS],

      [LCURRENCY],

      [LEXCHANGE],

      [WTAX],

      [AFTERWTAX],

      [WTAXPERCENT],

      [IVBALANCE],

      [ADVFLAG],

      [ACCOUNT] AS INVOICES_ACCOUNT,

      [CASHPAYMENT],

      [STORNOFLAG] AS INVOICES_STORNOFLAG,

      [TAX] AS INVOICES_TAX,

      [INTERNAL] AS AS INVOICES_INTERNAL,

      [BRANCH]AS INVOICES_BRANCH ,

      [LIV],

      [ADJPRICEFLAG],

      [FNCITEMSFLAG],

      [DETAILS],

      [OWNER] AS INVOICES_OWNER,

      [PHONE] AS INVOICES_PHONE,

      [DESTCODE],

      [SHIPTYPE] AS INVOICES_SHIPTYPE,

      [BALDATE],

      [PLIST],

      [T$PERCENT] AS INVOICES_T$PERCENT,

      [PACK],

      [MWEIGHT],

      [WEIGHT],

      [AIRWAYBILL]

      FROM [lib://clinton/Invoices.qvd] (qvd)

      Data has not been loaded. Please correct the error and try loading again.

        • Re: Syntax error, missing/misplaced FROM
          Onno van Knotsenburg

          You are missing a semi-colon at the end of your script.

            • Re: Syntax error, missing/misplaced FROM

              hey i corrected it but still got an error

               

              The following error occurred:

              Syntax error, missing/misplaced FROM:

              [Invoices]:

              LOAD

              [IVDATE] AS INVOICES_IVDATE,

              [IVNUM],

              [DOC],

              [IV] AS INVOICES_IV,

              [QPRICE] AS INVOICES_QPRICE,

              [TOTPRICE] AS INVOICES_TOTPRICE,

              [CURRENCY] AS INVOICES_CURRENCY,

              [CUST] AS INVOICES_CUST,

              [DEBIT],

              [IVREF],

              [VAT],

              [UDATE] AS INVOICES_UDATE,

              [T$USER] AS INVOICES_T$USER,

              [PRINTED],

              [FINAL],

              [ORD],

              [DISCOUNT],

              [DISPRICE],

              [MONTHLY] AS INVOICES_MONTHLY,

              [PAY] AS INVOICES_PAY ,

              [FNCPATTERN] AS INVOICES_FNCPATTERN,

              [PAYDATE],

              [FNCTRANS],

              [BOOKNUM]AS INVOICES_BOOKNUM ,

              [AGENT] AS INVOICES_AGENTS,

              [PIV],

              [CALQPRICE] AS INVOICES_CALQPRICE,

              [TYPE] AS INVOICES_TYPE,

              [CHECKING],

              [IMPFILE],

              [IMPFIVTYPE],

              [CASH] AS INVOICES_CASH,

              [TOCASH],

              [NOVATPRICE],

              [VATPRICE],

              [WARHS],

              [TOWARHS],

              [LCURRENCY],

              [LEXCHANGE],

              [WTAX],

              [AFTERWTAX],

              [WTAXPERCENT],

              [IVBALANCE],

              [ADVFLAG],

              [ACCOUNT] AS INVOICES_ACCOUNT,

              [CASHPAYMENT],

              [STORNOFLAG] AS INVOICES_STORNOFLAG,

              [TAX] AS INVOICES_TAX,

              [INTERNAL] AS AS INVOICES_INTERNAL,

              [BRANCH]AS INVOICES_BRANCH ,

              [LIV],

              [ADJPRICEFLAG],

              [FNCITEMSFLAG],

              [DETAILS],

              [OWNER] AS INVOICES_OWNER,

              [PHONE] AS INVOICES_PHONE,

              [DESTCODE],

              [SHIPTYPE] AS INVOICES_SHIPTYPE,

              [BALDATE],

              [PLIST],

              [T$PERCENT] AS INVOICES_T$PERCENT,

              [PACK],

              [MWEIGHT],

              [WEIGHT],

              [AIRWAYBILL]

              FROM [lib://clinton/Invoices.qvd] (qvd)

              The error occurred here:

              [Invoices]:

              LOAD

              [IVDATE] AS INVOICES_IVDATE,

              [IVNUM],

              [DOC],

              [IV] AS INVOICES_IV,

              [QPRICE] AS INVOICES_QPRICE,

              [TOTPRICE] AS INVOICES_TOTPRICE,

              [CURRENCY] AS INVOICES_CURRENCY,

              [CUST] AS INVOICES_CUST,

              [DEBIT],

              [IVREF],

              [VAT],

              [UDATE] AS INVOICES_UDATE,

              [T$USER] AS INVOICES_T$USER,

              [PRINTED],

              [FINAL],

              [ORD],

              [DISCOUNT],

              [DISPRICE],

              [MONTHLY] AS INVOICES_MONTHLY,

              [PAY] AS INVOICES_PAY ,

              [FNCPATTERN] AS INVOICES_FNCPATTERN,

              [PAYDATE],

              [FNCTRANS],

              [BOOKNUM]AS INVOICES_BOOKNUM ,

              [AGENT] AS INVOICES_AGENTS,

              [PIV],

              [CALQPRICE] AS INVOICES_CALQPRICE,

              [TYPE] AS INVOICES_TYPE,

              [CHECKING],

              [IMPFILE],

              [IMPFIVTYPE],

              [CASH] AS INVOICES_CASH,

              [TOCASH],

              [NOVATPRICE],

              [VATPRICE],

              [WARHS],

              [TOWARHS],

              [LCURRENCY],

              [LEXCHANGE],

              [WTAX],

              [AFTERWTAX],

              [WTAXPERCENT],

              [IVBALANCE],

              [ADVFLAG],

              [ACCOUNT] AS INVOICES_ACCOUNT,

              [CASHPAYMENT],

              [STORNOFLAG] AS INVOICES_STORNOFLAG,

              [TAX] AS INVOICES_TAX,

              [INTERNAL] AS AS INVOICES_INTERNAL,

              [BRANCH]AS INVOICES_BRANCH ,

              [LIV],

              [ADJPRICEFLAG],

              [FNCITEMSFLAG],

              [DETAILS],

              [OWNER] AS INVOICES_OWNER,

              [PHONE] AS INVOICES_PHONE,

              [DESTCODE],

              [SHIPTYPE] AS INVOICES_SHIPTYPE,

              [BALDATE],

              [PLIST],

              [T$PERCENT] AS INVOICES_T$PERCENT,

              [PACK],

              [MWEIGHT],

              [WEIGHT],

              [AIRWAYBILL]

              FROM [lib://clinton/Invoices.qvd] (qvd);

              Data has not been loaded. Please correct the error and try loading again.

            • Re: Syntax error, missing/misplaced FROM
              sasi k

              hi,

              [INTERNAL] AS  AS  INVOICES_INTERNAL,

              Here you wrote 2 AS keywords remove one and end of the script give one semi colon

               

              use the following script

               

              [Invoices]:

              LOAD

              [IVDATE] AS INVOICES_IVDATE,

              [IVNUM],

              [DOC],

              [IV] AS INVOICES_IV,

              [QPRICE] AS INVOICES_QPRICE,

              [TOTPRICE] AS INVOICES_TOTPRICE,

              [CURRENCY] AS INVOICES_CURRENCY,

              [CUST] AS INVOICES_CUST,

              [DEBIT],

              [IVREF],

              [VAT],

              [UDATE] AS INVOICES_UDATE,

              [T$USER] AS INVOICES_T$USER,

              [PRINTED],

              [FINAL],

              [ORD],

              [DISCOUNT],

              [DISPRICE],

              [MONTHLY] AS INVOICES_MONTHLY,

              [PAY] AS INVOICES_PAY ,

              [FNCPATTERN] AS INVOICES_FNCPATTERN,

              [PAYDATE],

              [FNCTRANS],

              [BOOKNUM]AS INVOICES_BOOKNUM ,

              [AGENT] AS INVOICES_AGENTS,

              [PIV],

              [CALQPRICE] AS INVOICES_CALQPRICE,

              [TYPE] AS INVOICES_TYPE,

              [CHECKING],

              [IMPFILE],

              [IMPFIVTYPE],

              [CASH] AS INVOICES_CASH,

              [TOCASH],

              [NOVATPRICE],

              [VATPRICE],

              [WARHS],

              [TOWARHS],

              [LCURRENCY],

              [LEXCHANGE],

              [WTAX],

              [AFTERWTAX],

              [WTAXPERCENT],

              [IVBALANCE],

              [ADVFLAG],

              [ACCOUNT] AS INVOICES_ACCOUNT,

              [CASHPAYMENT],

              [STORNOFLAG] AS INVOICES_STORNOFLAG,

              [TAX] AS INVOICES_TAX,

              [INTERNAL] AS   INVOICES_INTERNAL,

              [BRANCH] AS INVOICES_BRANCH ,

              [LIV],

              [ADJPRICEFLAG],

              [FNCITEMSFLAG],

              [DETAILS],

              [OWNER] AS INVOICES_OWNER,

              [PHONE] AS INVOICES_PHONE,

              [DESTCODE],

              [SHIPTYPE] AS INVOICES_SHIPTYPE,

              [BALDATE],

              [PLIST],

              [T$PERCENT] AS INVOICES_T$PERCENT,

              [PACK],

              [MWEIGHT],

              [WEIGHT],

              [AIRWAYBILL]

              FROM [lib://clinton/Invoices.qvd] (qvd);

              • Re: Syntax error, missing/misplaced FROM
                ervin jafari

                You should write semicolon after load script "(qvd);"

                • Re: Syntax error, missing/misplaced FROM
                  Gabriel Oluwaseye

                  Hi,

                   

                  You have 2 Invoices Load. The first part of the Invoice load is missing semicolon (;) after the (qvd). Please add semicolon and reload

                  • Re: Syntax error, missing/misplaced FROM
                    Sasidhar Parupudi

                    Hi

                     

                    You got two AS in the following line

                    [INTERNAL] AS AS INVOICES_INTERNAL,

                     

                    and missing ";" at the end.

                     

                    Hope it helps

                    Sasi