topic Re: Writeback Feature in Database in QlikView

Writeback Feature in Database

Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Writeback Feature in Database

Tue, 22 Jul 2014 10:17:35 GMT

Please help on this...

Re: Writeback Feature in Database

aveeeeeee7en — Tue, 22 Jul 2014 10:24:44 GMT

See this:

http://community.qlik.com/message/523059#523059

Re: Writeback Feature in Database

ashfaq_haseeb — Tue, 22 Jul 2014 10:34:27 GMT

Hi,

have a look at the below extension.

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

Regards

ASHFAQ

Re: Writeback Feature in Database

Tue, 22 Jul 2014 10:46:08 GMT

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

So I need simple example with working.