7 Replies Latest reply: Nov 4, 2015 9:11 AM by Adam Krepistman RSS

    invalid path error

    jhonatan ben ami

      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;

      Invalid Path ERROR1.PNG

        • Re: invalid path error
          Henric Cronström

          You cannot use Order By here. It only works together with Load ... Resident.

           

          HIC

            • Re: invalid path error
              jhonatan ben ami

              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);

            • Re: invalid path error
              Clever Anjos

              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];

                • Re: invalid path error
                  Miguel Braga

                  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

                    • Re: invalid path error
                      jhonatan ben ami

                      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);

                  • Re: invalid path error
                    Adam Krepistman

                    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