Dev Express Quantum Grid column.EditValue

I am using dev express with one column in the cxgrid called Column1. I successfully retrieve the records and they are listed in the grid under Column1.

I want to update the value of Column1 by using the Column1.EditValue set property. If I use my mouse and select the 1st record in the grid then click on the buttom that calls Column1.EditValue := 'Test' it changes the selected row in Column1 to value 'Test'. But then the the grid jumps to the last record, instead of either staying on the 1st record or going to the next record. Can someone please help me to prevent this.

Or is there another way to update Column1's value with a value from an edit box?

Thank you in advance!
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Geert GOracle dbaCommented:
if you want to change data in a devexpress grid

var r: integer;

with gridview.datacontroller do
  r := FocusedRecordIndex;
  if r >= 0 then // avoid filter and insert row
      Values[r, Column1.Index] := 'Test';

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
skynergyAuthor Commented:
Thank you!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.