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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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

Labels (1)
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.