Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Writeback Feature in Database

I have created writeback report..but right back is not working for me..
can you pls provide me simple example writeback in Databse.

Thi is macro which i used in

sub PullData

dim sServer, sConn, oConn,oRS
sServer="sqlservername"
sConn="Provider=SQLOLEDB.1;Initial Catalog=ClientBISDb;Data Source=ibdsql4004,2431"
Set oConn = CreateObject("ADODB.Connection")
oConn.Open sConn, "Username", "Password"
Set oRS =CreateObject("ADODB.Recordset")
sSQL="Select name from qliktest"
oRS.Open sSQL, oconn

set Result = oRS

While (Not Result.EOF)
msgbox(Result.Fields(0).Value)
SET Inputting = ActiveDocument.DynamicUpdateCommand ("INSERT INTO qliktest (F1) VALUES (" + Result.Fields(0).Value + ")")
Result.MoveNext
Wend

end sub

4 Replies
Not applicable
Author

Please help on this...

aveeeeeee7en
Specialist III
Specialist III

ashfaq_haseeb
Champion III
Champion III

Hi,

have a look at the below extension.

http://community.qlik.com/docs/DOC-5970

Regards

ASHFAQ

Not applicable
Author

can you pls share working example with me...becasue zip example already there.

So I need simple example with working.