topic writinig to DB in QlikView

writinig to DB

adiarnon — Thu, 08 Oct 2015 08:06:01 GMT

hi,

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

TNX,

ADI

arulsettu — Thu, 08 Oct 2015 08:09:03 GMT

check this

tamilarasu — Thu, 08 Oct 2015 08:10:25 GMT

Check this too,

petter — Thu, 08 Oct 2015 08:10:31 GMT

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 — Thu, 08 Oct 2015 08:11:17 GMT