I have aan SQL query which is run when a user clicks a button. A readwrite cursor is created and used to populate a grid. When the user make the change I want to then update the changes made to the cursor to the main table. I could scan all records in the cursor and update the main table but this is pointless I feel. Is is best to have a field say changed and set all records to 0 when running the query.

Then I thought if they change the record it set the field to 1. Then when they click save I could then scan the table where change = 1 and then do the update.

Is this viable?