Hi,
I've tried using the nice code provided by Ashfaq Mohammad in the attached QV file.
My steps:
1. I load the original data from qvd file (then i include a dummy additional column named "comments" during the load statement in script)
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"
3. I press button UPDATE in order to update the column "comments" in the data but the update does not work.
Maybe there is a problem with the update statement.
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
I attached my source files in the current post. Grateful if you could please help.