topic DynamicUpdateCommand Returning False in QlikView https://community.qlik.com/t5/QlikView/DynamicUpdateCommand-Returning-False/m-p/716556#M257600 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I am having a problem using DynamicUpdateCommand to insert a row into a SQL Server table in a Macro, only doing something simple at the moment</P><P></P><P>SET Inputting = ActiveDocument.DynamicUpdateCommand("INSERT INTO Campaign_Management (Name, CreatedAt,CreatedBy) VALUES (123, 2014-07-21 ,patxxx)").</P><P></P><P>I can do a select ok</P><P></P><P>This statement is returning false and when I try Inputting.ErrorMessage this returns just an empty string.</P><P></P><P>I have set the Server settings in my Document Properties as below</P><P><IMG alt="settings.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/62775_settings.png" /></P><P></P><P>Any help would be appreciated</P></BODY></HTML> Mon, 21 Jul 2014 10:30:27 GMT 2014-07-21T10:30:27Z DynamicUpdateCommand Returning False https://community.qlik.com/t5/QlikView/DynamicUpdateCommand-Returning-False/m-p/716556#M257600 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I am having a problem using DynamicUpdateCommand to insert a row into a SQL Server table in a Macro, only doing something simple at the moment</P><P></P><P>SET Inputting = ActiveDocument.DynamicUpdateCommand("INSERT INTO Campaign_Management (Name, CreatedAt,CreatedBy) VALUES (123, 2014-07-21 ,patxxx)").</P><P></P><P>I can do a select ok</P><P></P><P>This statement is returning false and when I try Inputting.ErrorMessage this returns just an empty string.</P><P></P><P>I have set the Server settings in my Document Properties as below</P><P><IMG alt="settings.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/62775_settings.png" /></P><P></P><P>Any help would be appreciated</P></BODY></HTML> Mon, 21 Jul 2014 10:30:27 GMT https://community.qlik.com/t5/QlikView/DynamicUpdateCommand-Returning-False/m-p/716556#M257600 2014-07-21T10:30:27Z