7 Replies Latest reply: Mar 4, 2015 12:07 PM by Enrica Tosato RSS

    Question

    Enrica Tosato

      Dears,
      i am really new and not so technical.
      I am trying to create a ODBC connection from my ERP database
      I go in Edit scrip and I followed the web suggestion on ODBC connection
      I obtained this attached script (see end of the message)
      I have an error when I try to load the data:
      Unknown statement
      ODBC CONNE
      SQL SELECT "alfa_alsis_scope",
          artbeskr,
          artikelvariant,
          extordtyp,
          ordantal,
          orddatum,
          saljare,
          varugruppkod,
          "vb_pris"
      FROM ArtecAirSU.dbo.orp
      I suppose it depnd from alfa_alsis_scope and "vb_pris"
      Please, How to solve it? Many thanks

      ODBC CONNE
      //-------- Start Multiple Select Statements ------
      SQL SELECT "alfa_alsis_scope",
           artbeskr,
           artikelvariant,
           extordtyp,
           ordantal,
           orddatum,
           saljare,
           varugruppkod,
          
      "vb_pris"
      FROM ArtecAirSU.dbo.orp;


      SQL SELECT kundbestdat,
           kundref2,
           ordstat,
           slutkundnamn1
      FROM ArtecAirSU.dbo.oh;

      SQL SELECT ftgnamn
      FROM ArtecAirSU.dbo.fr;
      //-------- End Multiple Select Statements ------


      CT TO AirArtecSu (XUserId is GLBPNZVMQbbEHaZL);