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.




      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 *




      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.