My code works but it reloads the whole database from scratch which selects the row from the beginning. How can I fix the code?
Andreas' answer not withstanding:
To autoselect the row you changed after the reload:
Remember the ID before you update, do the Update, do the Reload, Locate the ID in the Grid/DataSet, Done