Duplicate row created after editing a row

Mark Semple

Hi all,

I have an issue with the Editor. Each row has a unique ID - two letter ISO country code. Unfortunately, some countries/territories share the same country code.

When I go to edit a row to change some value for the country (not the ISO, just some other data), all the countries details are sent to my Python backend via JSON. I then do the unique lookup within the DB and make any changes just fine. When I return the value back to the Editor however, Editor creates a duplicate row (with the updated values) and leaves the original row (with original values) in place within the UI.

This only started occurring after I modified the return JSON object coming from the server to specifically return the country that was modified (since remember, some countries/territories share an ISO code).

Before making that change, the changed value would get updated in the database but nothing would show up in the Editor - I would need to refresh the page for the updated results to show.

Anyone have any idea what is going on here?

Thanks in advance ...