Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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

Re: Writeback Feature in Database

Please help on this...

aveeeeeee7en
Valued Contributor III

Re: Writeback Feature in Database

Re: Writeback Feature in Database

Hi,

have a look at the below extension.

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

Regards

ASHFAQ

Not applicable

Re: Writeback Feature in Database

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

So I need simple example with working.