Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Anyone know how qlikview can write data back to mysql or any other database?
If by using macro, may I have any sample of the vbscript?
Extension objects are the more elegant solution.
You'll need a WebService for that to handle the SQL queries.
Hi!
You can write to any SQL straight from script.
Normally you write to script:
SQL Select * From Users;
You can write:
SQL Insert into Users
Values ('ID1','John','Smith');
Br,
Miikka
I've made that with for-loop and variables.
I don't have that example here, but it was something like this:
for i=0 to 10
Read:
Load
Dim1,
Val1
From
Example.qvd (qvd)
Where
RowNo() = $(i)
;
Write:
SQL
Insert into Example
Values(chr(39)&Dim1&Chr(39),chr(39)&Val1&Chr(39));
Next
You have to use Chr(39), you'll see:)
Br,
Miikka
I want from front end instead of scripting. But anyway, I used dynamic update. This action can help to upload the data into table. But need to store into qvd or other table files because dynamic update action just update the data to memory, after reload, it's gone.