topic Re: Update SQL Table with a QV variable in QlikView

Update SQL Table with a QV variable

Anonymous — Fri, 10 Aug 2012 13:54:05 GMT

Dear All,

I´m trying to update a field in a SQL table with the data in a QV variable. The problem is to the macro understand the variable (looks simple but I´m new ...). If I fix a value it works.

Bellow is the macro and the variable used is the v_VARCHAR

sub Rec_Data()

dim sServer, sConn, oConn,oRS

sServer="ARPoint-AR\SQL2008"

sConn="Provider=SQLOLEDB.1;Initial Catalog=QV;Data Source=arpoint-AR\sql2008"

Set oConn = CreateObject("ADODB.Connection")

oConn.Open sConn, "sa", "123"

Set oRS =CreateObject("ADODB.Recordset")

sSQL="UPDATE Table_1 SET Col1_Varchar = " + $v_VARCHAR

oRS.Open sSQL, oconn

end sub

Thanks in advance.

Re: Update SQL Table with a QV variable

Fri, 10 Aug 2012 13:55:43 GMT

try $(v_VARCHAR) or '$(v_VARCHAR)'

Re: Update SQL Table with a QV variable

Anonymous — Fri, 10 Aug 2012 14:17:05 GMT

Felim,

Both failed. I also tryed it

sSQL="UPDATE Table_1 SET Col1_Varchar = ' " + $(v_VARCHAR) + " ' "

Thanks.

Re: Update SQL Table with a QV variable

fosuzuki — Fri, 10 Aug 2012 14:23:28 GMT

Hi,

the macro module doesn't understand dollar sign expansion.

You must use:

sSQL="UPDATE Table_1 SET Col1_Varchar = ' " + ActiveDocument.Variables("v_VARCHAR").GetContent.String + " ' "

Hope this helps

Fernando

Re: Update SQL Table with a QV variable

Anonymous — Fri, 10 Aug 2012 21:46:25 GMT

Fernando,

Work fine. Thanks.