3 Replies Latest reply: Jul 2, 2013 12:49 PM by Michael Solomovich RSS

    Fetching my tables is not working the right way

      I have this five tables, where i want to insert in the QV so i can make my tables by them.

       

      THE SCRIPT CODE:

       

      OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=PRIN;Data Source=AMRCCSLR835X0A\SQLEXPRESS;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=AMRCCSLR835X0A;Use Encryption for Data=False;Tag with column collation when possible=False];

       

      SQL SELECT *

      FROM PRIN.dbo."Presentaciones_Dolares";

       

      SQL SELECT *

      FROM PRIN.dbo."Presentaciones_Dosis";

       

      SQL SELECT *

      FROM PRIN.dbo."Presentaciones_Unidades";

       

      SQL SELECT *

      FROM PRIN.dbo."PROD_LAB_TIPO";

       

       

      SQL SELECT *

      FROM PRIN.dbo."Productos_Dolares";

       

      SQL SELECT *

      FROM PRIN.dbo."Productos_Unidades";

       

      And when I hit Reload here is what happens:

       

       

       

      If you can see, almost all the tables are being inserted into just one.

       

      Help please.