topic Problem with dynamic update in QlikView https://community.qlik.com/t5/QlikView/Problem-with-dynamic-update/m-p/637807#M233858 <HTML><HEAD></HEAD><BODY><P>Hi everybody.</P><P></P><P>I have a problem: I'm trying to user variable values to execute a dynamic update insert, but it's not working. The command line I'm using is</P><P></P><P><SPAN style="font-family: courier new,courier;">INSERT INTO * (ExecProcedure, ExecParametro1, ExecParametro2, ExecParametro3) VALUES (SalvaPedido, $(vL.ProdutosPedido), vL.RepresentantePedido, vL.ProdutoQuantidade) </SPAN></P><P></P><P>It only works if I remove the $ from variable vL.ProdutosPedido, but in this case it inserts the name of variable instead of its value.</P><P></P><P>Anybody can help me?</P><P></P><P>Thanks in advance.</P></BODY></HTML> Tue, 03 Jun 2014 17:38:42 GMT Marcio_Campestrini 2014-06-03T17:38:42Z Problem with dynamic update https://community.qlik.com/t5/QlikView/Problem-with-dynamic-update/m-p/637807#M233858 <HTML><HEAD></HEAD><BODY><P>Hi everybody.</P><P></P><P>I have a problem: I'm trying to user variable values to execute a dynamic update insert, but it's not working. The command line I'm using is</P><P></P><P><SPAN style="font-family: courier new,courier;">INSERT INTO * (ExecProcedure, ExecParametro1, ExecParametro2, ExecParametro3) VALUES (SalvaPedido, $(vL.ProdutosPedido), vL.RepresentantePedido, vL.ProdutoQuantidade) </SPAN></P><P></P><P>It only works if I remove the $ from variable vL.ProdutosPedido, but in this case it inserts the name of variable instead of its value.</P><P></P><P>Anybody can help me?</P><P></P><P>Thanks in advance.</P></BODY></HTML> Tue, 03 Jun 2014 17:38:42 GMT https://community.qlik.com/t5/QlikView/Problem-with-dynamic-update/m-p/637807#M233858 Marcio_Campestrini 2014-06-03T17:38:42Z Re: Problem with dynamic update https://community.qlik.com/t5/QlikView/Problem-with-dynamic-update/m-p/637808#M233859 <HTML><HEAD></HEAD><BODY><P>make this statement a variable. add the quotes for the variable </P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'courier new', courier;">vValues = VALUES (SalvaPedido, '$(vL.ProdutosPedido)', vL.RepresentantePedido, vL.ProdutoQuantidade)</SPAN></P><P></P><P>then do this.</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'courier new', courier;">INSERT INTO * (ExecProcedure, ExecParametro1, ExecParametro2, ExecParametro3) $(<SPAN style="color: #3d3d3d; font-family: 'courier new', courier;">vValues)</SPAN></SPAN></P></BODY></HTML> Tue, 03 Jun 2014 17:57:34 GMT https://community.qlik.com/t5/QlikView/Problem-with-dynamic-update/m-p/637808#M233859 erikzions 2014-06-03T17:57:34Z Re: Problem with dynamic update https://community.qlik.com/t5/QlikView/Problem-with-dynamic-update/m-p/637809#M233860 <HTML><HEAD></HEAD><BODY><P>Erik, thank you for the answer.</P></BODY></HTML> Tue, 03 Jun 2014 18:22:53 GMT https://community.qlik.com/t5/QlikView/Problem-with-dynamic-update/m-p/637809#M233860 Marcio_Campestrini 2014-06-03T18:22:53Z