Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to writeback to the database without using webservice? Please guide.
Hi snehal,
Can you please elaborate more on what are you trying to do? That would be really helpful to solve your problem.
Regards,
KC
You are talking about general Database scenario or Qlik scenario?
Hi,
In Qlik Scenario,
Some selections are made in Qv and the same should be updated in the database on click of a button.
QV is a analytical tool, it does not allow you to edit/insert/update data in database as per my understanding
Hope this help you https://community.qlik.com/docs/DOC-6386
Vikas
Hi Vikas,
The link you have shared describes has details for the script level writeback.
I would like to know if the writeback can be performed without the use of webservice from the accesspoint/UI.
You can write a macro that uses ADO to do the SQL work. I'm not sure (doubtful) that this would work on an Ajax client though.
-Rob
try with this code in VBscript
dim sConn, oConn
Set oConn = CreateObject("ADODB.Connection")
sConn = "Provider=MSDAORA;User ID="yourlogin";Password="yourpassword";Data Source="your data source";OLEDB.NET=true;SPPrmsLOB=true;Persist Security Info=False;"
oConn.Open sConn
sSQL="your request"
oConn.Execute(sSQL)
oConn.Close
Set oConn = Nothing