5 Replies Latest reply: Aug 28, 2013 5:47 PM by omar limon RSS

    Error: Table not found

      Hi everyone;

      I have a query in distinc TAB the first tab is called Mexico and contains

       

      CONNECT TO mgtmexbaan6 (XUserId is VaWfGcRNTLbIXcBK, XPassword is WBLbMZVMBDZWE);
      companies:
      SQL select
      t_cwoc,
      t_dsca,
      t_comp
      from ttcmcs065105 where t_typd = 2;
      //catalogo de purchase office
      concatenate
      SQL select
      t_cwoc,
      t_dsca,
      t_comp
      from ttcmcs065116 where t_typd = 2;
      //catalogo de purchase office
      store companies into Dimensiones\companiestotal.qvd;

       

      the other tab is called USA and contains

       

      CONNECT TO WDM (XUserId is NSeUAcRNTTYeWTBM, XPassword is JTLCLZVMBDZIO);
      companies400:
      SQL select
      t_cwoc,
      t_dsca,
      t_comp
      from ttcmcs065400
      where t_typd = 2;
      //catalogo de purchase office
      store companies400 into Dimensiones\companiestotal400.qvd;
      drop table companies400;

      WHEN I run the  .qvw   appear the next error:

      Table not Found

       

       

      Can you help plis?

      I attached FILE