Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
If you provide more details then will be ok
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?