From my past experiences we can use to insert, delete from a SQL Server but on Oracle it fails.
To Achieve the above you can write a Macro and can execute it on the button click.
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;"
sSQL="Delete from Tablename Where FieldName in " & ValuesToDelete
Set oConn = Nothing
You will need to enable the "Script (Allow Database Write and Execute Statements)" property inside User Preferences -> Security.
Hope this helps.
Did you resolve this ? I too had issues to delete table in MS access, but tried using excel vba to do the same and used the same connection string in QV and it worked.
see the example below
AppPath = "S:\Phase I\After Run1\Database v1.1.accdb"
Set objADO = CreateObject("ADODB.Connection")
objADO.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & "Data Source=" & AppPath & ";"
objADO.Execute("delete * from Basedata where Filename="&chr(34)& fnm &chr(34))
Basically test the connection in Excel or other application and bring it to the QV. It should work.
I would be very wary of using QlikView to write back to the database. Direct Discovery was not designed for this, indeed I have seen QlikTech advise using a read only database connection.
Notwithstanding I get asked about this kind thing every now & then, and if you give it a try I'd be interested in your experiences.
Best Regards, Bill