writinig to DB

[adiarnon]

hi,

is there any option in the qv apllication that the user will write back to the DB?

TNX,

ADI

[arulsettu]

check this

SQL Writeback from QlikView extension object.

https://community.qlik.com/docs/DOC-3054/version/2

[tamilarasu]

Check this too,

Write Back to Database

Write-back Capability in Qlikview

[petter]

Yes you can in the load script have a statement like this:

CONNECT ..... ;

SQL

     INSERT INTO dbo.CalcResult VALUES( 1 , 'Negative' , 234 );

And you can have multiple INSERTS or even a single INSERT with multiple rows.

Mind you - you might have to remember to allow read/write in the settings of the LOAD SCRIPT editor:

[petter]