Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.