Question
cognizant
US
Last activity: 23 Jun 2021 3:00 EDT
Update a existing record in data table
Hello
How do i update existing record in a data table?
For example i have a row in Data table with 2 colums id and file name.
One row has values id as 1 and file name as abc.xml now if i want to update id as 2 from 1 howcan i achieve it.
Id is the primary key for the table
Cognitonic Systems Australia
AU
@BHARGAVP2854 In general once the record is created in a table Primary Key column data cannot be modified unlike other columns data. If you are adding manually its better to create new record and remove old one. If you are doing through any activity follow these steps.
1. Open the existing record which is 1 using obj-open.
2. Copy all required data of id 1 to a temporary page , assign new value to id .
3. Save temporary page data and delete the previous one.
So, only one record with updated id and previous data will be present in the table.