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



      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!!