Question
Citiustech
IN
Last activity: 14 Jun 2023 9:57 EDT
Updating the existing record in Data table.
Hi,
I have a requirement to update the existing record including the primary keys on click of a button, When i click on submit the changes that made in the form should replace the existing values that are in the old record including the primary keys. is there any process that i can do to do these with out creating a duplicate record.
Thank you.
TSPi
US
You can do this using activty. Call the actvity in the post processing. Pass the Primary key value that you want to change to Obj-delete by Handle . then set all the porperties to add the record with the data given in UI. and use Obj-save with write now option.
But , I dont understand why do you need to change the primary Key value , If you are changing it then DB never thinks it as duplicate record.
Hope this helps
Citiustech
IN
Hi, @Satish Sudagoni
Can i achieve it without using delete option because if we didn't select all the primary keys then it is creating a duplicate record.
TSPi
US
@SuryavamsiR How many primary keys are there?
How you are assuming that its a duplicate record.
for Example:
Country and state are Primary key ithen
India Bihar Patna
India Bihar Gaya , Now the second will never store in the db since it is duplicated .
India Goa Panaji, will work,
Citiustech
IN
Let's say i have a record on one operatorID i don't want to have multiple records on same operatorID, But if i use delete method it is creating a multiple record on same operatroID.