topic Re: Update SQL Table from Qlikview in QlikView

Update SQL Table from Qlikview

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Is it possible to connect to a table in SQL server. Create changes to that table in Qlikview and save those changes back to the SQL Server table?

vinieme12 — Fri, 24 Mar 2017 13:42:04 GMT

if an Extension is an option

adamdavi3s — Fri, 24 Mar 2017 13:43:04 GMT

Yes using a macro or JS extension, but its iffy practice at best

theivestjens — Mon, 11 Dec 2017 07:07:48 GMT

LET V_ROWS = NoOfRows('Item_Requirements');

//exit script;

// Loop through the records and insert into Database table

FOR V_ROW = 0 TO V_ROWS - 1

LET V_FIELD2 = Peek('Item',V_ROW);

LET V_FIELD3 = Peek('Language',V_ROW);

LET V_FIELD4 = Peek('Description',V_ROW);

LET V_FIELD5 = Peek('Sequence',V_ROW);

//Invoegen in SQL

SQL INSERT INTO [DateBase].dbo.table(Item, Language, Description, Sequence)

VALUES('$(V_FIELD2)', '$(V_FIELD3)','$(V_FIELD4)','$(V_FIELD5)');

NEXT;

alis2063 — Mon, 11 Dec 2017 17:53:33 GMT

Thanks so we need to learn Window communication foundation when we face this scenario.