Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i wrote down this but got an error:
INV_TOP_CUSTOMERS:
LOAD
IVCOST,
IV,
IVDATE,
TYPE AS IV_TYPE,
CURRENCY ,
TOTPRICE AS IVA_TOTPRICE,
COMP as INV_COMP,
BONUSFLAG AS IVA_BONUSFLAG
from [lib://clinton/InvoiceItems.qvd](qvd)
/*WHERE IVCOST > 10000*/
ORDER BY IVDATE ASC;
concatenate (INV_TOP_CUSTOMERS)
LOAD
CUST,
CUSTNAME,
COUNTRY,
CURRENCY
FROM [lib://clinton/customers.qvd](qvd);
concatenate (INV_TOP_CUSTOMERS)
LOAD
COST,
CURRENCY,
IV
FROM [lib://clinton/Trans.qvd](qvd);
concatenate (INV_TOP_CUSTOMERS)
LOAD
IVDATE,
CURRENCY,
IVNUM as INV_NUMBER,
FINAL AS INV_FINAL
RESIDENT [lib://clinton/Invoices.qvd]
ORDER BY INV_NUMBER ASC;
You cannot use Order By here. It only works together with Load ... Resident.
HIC
i changed the script but keep getting the same error msg:
INV_TOP_CUSTOMERS:
LOAD
IVCOST,
IV,
IVDATE,
TYPE AS IV_TYPE,
CURRENCY ,
TOTPRICE AS IVA_TOTPRICE,
COMP as INV_COMP,
BONUSFLAG AS IVA_BONUSFLAG
from [lib://clinton/InvoiceItems.qvd](qvd)
WHERE IVCOST > 10000 ;
concatenate (INV_TOP_CUSTOMERS)
LOAD
CUST,
CUSTNAME,
COUNTRY,
CURRENCY
FROM [lib://clinton/customers.qvd](qvd);
concatenate (INV_TOP_CUSTOMERS)
LOAD
COST,
CURRENCY,
IV
FROM [lib://clinton/Trans.qvd](qvd);
concatenate (INV_TOP_CUSTOMERS)
LOAD
IVDATE,
CURRENCY,
IVNUM as INV_NUMBER,
FINAL AS INV_FINAL
from [lib://clinton/Invoices.qvd](qvd);
Try
concatenate (INV_TOP_CUSTOMERS)
LOAD * ORDER BY INV_NUMBER ASC;
LOAD
IVDATE,
CURRENCY,
IVNUM as INV_NUMBER,
FINAL AS INV_FINAL
RESIDENT [lib://clinton/Invoices.qvd];
Hi Clever Anjos,
Can we make a resident load from a qvd file? I might be very wrong, but I don't think it is possible...
Regards,
MB
O.K i have changed the syntax and still got the same reuslt...
INV_TOP_CUSTOMERS:
LOAD
IVCOST,
IV,
IVDATE,
TYPE AS IV_TYPE,
CURRENCY ,
TOTPRICE AS IVA_TOTPRICE,
COMP as INV_COMP,
BONUSFLAG AS IVA_BONUSFLAG
from [lib://clinton/InvoiceItems.qvd](qvd)
WHERE IVCOST > 10000 ;
concatenate (INV_TOP_CUSTOMERS)
LOAD
CUST,
CUSTNAME,
COUNTRY,
CURRENCY
FROM [lib://clinton/customers.qvd](qvd);
concatenate (INV_TOP_CUSTOMERS)
LOAD
COST,
CURRENCY,
IV
FROM [lib://clinton/Trans.qvd](qvd);
concatenate (INV_TOP_CUSTOMERS)
LOAD
IVDATE,
CURRENCY,
IVNUM as INV_NUMBER,
FINAL AS INV_FINAL
from [lib://clinton/Invoices.qvd](qvd);
Does the library path 'lib://clinton/' exist? After all - if the error message is "Invalid Path", I would suspect that the path is incorrect.
HIC
it looks like regardless of the syntax chnages you make, the invalid path error still exists. Please verify it exists and the user you are running under has access to it.
you can paste lib://clinton into your windows explorer address bar