SQL Insert Data from a variable and from edit script load
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)
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:
See Settings option on the second link to allow the Read/Write.
Best I can offer with what you provided.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.