DynamicUpdateCommand

Fri, 30 Sep 2011 16:00:00 GMT

HI,

I have trouble getting DynamicUpdateCommand to work in my application. I have made a simple example to verify server settings are correct an license is applied.

The code I have trouble with is;

LOAD STATEMENT

sqlPlanner:

CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=qlikview;Initial Catalog=qlikview;Data Source=OER1EUWEBW01;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=OER1EUNB136926;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is WeVWYAJMDLMETZQK);

REPLACE LOAD so_key,

userid as PLANNERuserid,

"d_timestamp" as PLANNERtimestamp,

comment as PLANNERComment,

ID as PLANNERid;

SQL SELECT *

FROM qlikview.dbo."planner_comment";

VBScript

SET Result = ActiveDocument.DynamicUpdateCommand ("INSERT INTO * (so_key, PLANNERuserid, PLANNERtimestamp, PLANNERComment) VALUES (" + sOrderID + "," + getADUser(" ") + "," + Now() + "," + sComment + ")")

ActiveDocument.GetApplication.Sleep 700

If Result = False Then

ActiveDocument.GetSheetObject("TX09").SetText Result.ErrorMessage

Else

ActiveDocument.GetSheetObject("TX09").SetText ""

End If

Can anyone understand why this doesn't work?

Thanks,

Jonas

topic DynamicUpdateCommand in QlikView

DynamicUpdateCommand