CODEWITHSUNDEEP
mysqldatabasedelphitdbgridunidac
Hidden
Hidden

Reputation: 3626

How to change values of a mysql database via dbgrid?

Hey guys good morning,

i got a DBGrid and the UniDac components. I a use a popupmenu and select a row. I fill via the onclick event from the popupmenu a new form with my data in my TEdit.

Now the problem is, that i want to edit my data which i selected from the dbgrid.

This code works until dbgrid is refreshed and then the old values are back again in my dbgrid. How can i change it for the mysql table too not only for the dbgrid?

My actually Code:

   FQuery.Edit;
   FQuery.FieldByName('CfgUID').AsString := Edit4.Text;
   FQuery.FieldByName('CfgMod').AsString := Edit1.Text;
   FQuery.Post;

Upvotes: 0

Views: 1075

Answers (1)

Hidden
Hidden

Reputation: 3626

The solution was to disable CachedUpdates or call ApplyUpdates after Post.

Upvotes: 1

Related Questions