topic Check request for qlikview app to insert/update comments associated to a record in Qlikview? in QlikView https://community.qlik.com/t5/QlikView/Check-request-for-qlikview-app-to-insert-update-comments/m-p/759365#M1042386 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I've tried using the nice code provided by Ashfaq Mohammad in the attached QV file.</P><P> <BR />My steps:</P><P>1. I load the original data from qvd file (then i include a dummy additional column named "comments" during the load statement in script)<BR />2. I try to select one line of data in the straight table and i manually input a line of comment in the input box "comments"</P><P>3. I press button UPDATE in order to update the column "comments" in the data but the update does not work.</P><P></P><P>Maybe there is a problem with the update statement.<BR /> <BR />As you may notice, there are duplicate lines of data in source QVD. So in the update statement, can i do the update using "where condition" while referring to only the selected line of date (example: where rowno = rowid)? My aim is to update only one selected line of data at a time</P><P> <BR />I attached my source files in the current post. Grateful if you could please help.</P></BODY></HTML> Tue, 02 Dec 2014 12:50:41 GMT 2014-12-02T12:50:41Z Check request for qlikview app to insert/update comments associated to a record in Qlikview? https://community.qlik.com/t5/QlikView/Check-request-for-qlikview-app-to-insert-update-comments/m-p/759365#M1042386 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I've tried using the nice code provided by Ashfaq Mohammad in the attached QV file.</P><P> <BR />My steps:</P><P>1. I load the original data from qvd file (then i include a dummy additional column named "comments" during the load statement in script)<BR />2. I try to select one line of data in the straight table and i manually input a line of comment in the input box "comments"</P><P>3. I press button UPDATE in order to update the column "comments" in the data but the update does not work.</P><P></P><P>Maybe there is a problem with the update statement.<BR /> <BR />As you may notice, there are duplicate lines of data in source QVD. So in the update statement, can i do the update using "where condition" while referring to only the selected line of date (example: where rowno = rowid)? My aim is to update only one selected line of data at a time</P><P> <BR />I attached my source files in the current post. Grateful if you could please help.</P></BODY></HTML> Tue, 02 Dec 2014 12:50:41 GMT https://community.qlik.com/t5/QlikView/Check-request-for-qlikview-app-to-insert-update-comments/m-p/759365#M1042386 2014-12-02T12:50:41Z