5 Replies Latest reply: Jan 21, 2014 1:30 AM by vikas mahajan RSS

    QlikView Fields to Sql

      Sub Inserta_en_SQL

      dim strServer, strConexion, oConn,oRS

       

      strServer="servername"

      strConexion="provider=sqloledb;data source=" & strServer & ";initial catalog=dbMain"

       

      Set oConn = CreateObject("ADODB.Connection")

      oConn.Open strConexion, "sa", "password"

      Set oRS =CreateObject("ADODB.Recordset")

       

      sSQL="insert into tbUsuarios (intEmpresa,intSucursal,strUsuario,strConstrasena)  values (0,0,'Field?','123')"

       

      ors.open sSQL, oconn

       

      end sub

       

      How can I put  a field or variable in an SQL sentence?.

      It is possible?

       

      Or read an QVD and store it into an sql database?.

       

      Help and Thanks!!