Dynamic Update: Save data after dynamic update

[#1]

Hi Experts,

I am using Dynamic Update. I have inserted two new values into my table(say, employee) how do I save it to the QVD file back from which I am reading them?

Thank you.

[its_anandrjs]

As i under stand you have 2 new fields like say, employee if so then and this into the load script of the table like

tablename:

Load

say,//new field

employee, //new field

..

.

..From location;

Store tablename into tablename.qvd;

[its_anandrjs]

If you provide more details then will be ok

[#4]

I have file Employee.csv, I am reading the data from it. The columns that are available are Emp Name and Emp City.

Using the below load statement I loaded the file.

Employee:

Load EmpName, //field

EmpCity, //field

From Employee.csv;

The script loaded successfully.

I have now 5 employee reocrds in the list box for name and city.

I have created two input fields, Enter New 'Emp Name' and 'Enter New Emp City'. I have 'Add' button with action Dynamic Update. The below Query I used.

INSERT INTO * (EmpName, EmpCity) VALUES ('$(vEmpName)', '$(vEmpCity)')

where vEmpName and vEmpCity variables for input boxes defined above.

When I enter a new name and city in the input text boxes and Click Add, the new values are seen in the list boxes but how do I write this new data in the source file back Employee.csv?