Update SQL Table from Qlikview

[Anonymous]

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]

NO

if an Extension is an option

SQL Writeback from QlikView extension object.

[adamdavi3s]

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

SQL Writeback from QlikView extension object.

[theivestjens]

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]

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