Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
You got two AS in the following line
[INTERNAL] AS AS INVOICES_INTERNAL,
and missing ";" at the end.
Hope it helps
Sasi
You are missing a semi-colon at the end of your script.
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.
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);
You should write semicolon after load script "(qvd);"
Hi,
You have 2 Invoices Load. The first part of the Invoice load is missing semicolon (;) after the (qvd). Please add semicolon and reload
Hi
You got two AS in the following line
[INTERNAL] AS AS INVOICES_INTERNAL,
and missing ";" at the end.
Hope it helps
Sasi