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