SQL Insert Data from a variable and from edit script load

padmanabhv — Sat, 16 Nov 2024 19:17:47 GMT

May seem like a long-ish question.
I have 1. An input box where users can enter a comma separated list of fruits for example:
vFruit = apple, orange , mango

2. Clicking on a button creates a reload, which then takes into account how many fruits were entered (here, 3) , then does a sql select from a db and gets me 3 unique IDs, lets say :
newIDS = 123,456,789

What I want:
The same edit script to do a sql insert:
sql insert into DB
values (apple,123),(orange,456),(mango,789) ;

I cant seem to figure out how to create said sql insert statement using the 'newIDS' and looping through all the values in vFruit in the edit script, so that dynamic reload (i have a condition vFlag = 1, so only that portion runs)

Thank you !

Re: SQL Insert Data from a variable and from edit script load

Brett_Bleess — Wed, 12 Feb 2020 21:36:20 GMT

Firstly, I would caution against performing write-backs to databases using QlikView, this is not really what the product was intended to do and could lead to unintended consequences. That being said, I suspect you have not gotten any responses, as I was a little confused on exactly what you are asking here, it is not clear exactly what piece you need help solving?

You would need to enable EXECUTE and the Write options in the Desktop Client script editor, not sure whether you have done that or not:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/Execute.htm

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Edit_Script_dialog_box.htm

See Settings option on the second link to allow the Read/Write.

Best I can offer with what you provided.

Regards,
Brett

topic SQL Insert Data from a variable and from edit script load in QlikView

SQL Insert Data from a variable and from edit script load

Re: SQL Insert Data from a variable and from edit script load