6 Replies Latest reply: Nov 4, 2015 6:03 AM by Miguel Braga RSS

    Table not found- might be a residente problem?

    jhonatan ben ami

      hey i am trying to run this but keep getting  the error message on the bottom,

       

      INV_TOP_CUSTOMERS:

      LOAD

      IVCOST,

      IV,

      IVDATE,

      TYPE AS IV_TYPE,

      CURRENCY ,

      TOTPRICE AS IVA_TOTPRICE,

      COMP as INV_COMP,

      BONUSFLAG AS IVA_BONUSFLAG

      RESIDENT [lib://clinton/InvoiceItems.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;

      TABLE NOT FOUND.PNG