How to change values of a mysql database via dbgrid?

Question

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;

did you committed transaction after post ? does you query have unique index for rows ? what they reply to you on official forum? forums.devart.com/viewforum.php?f=7 — Arioch 'The
– Arioch 'The, Commented Apr 23, 2013 at 9:38
I didnt comitted...And i have a unique index for rows, Whats the command for the commit? — Hidden
– Hidden, Commented Apr 23, 2013 at 9:44
i don't have UniDAC but read their help about transactions. Transactions are core SQL concepts and you should read at very least wikipedia extract about them. Then, if your table has unique index, it does not necessarily mean your query has it as well, nor that UniDAC knows about that. DevArt have very responsive support team, so just ask on the forums, there can be many reasons and they know in details how to spot it.. — Arioch 'The
– Arioch 'The, Commented Apr 23, 2013 at 9:55

Hidden · Accepted Answer · 2013-04-23 14:05:37Z

1

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

answered Apr 23, 2013 at 14:05

Hidden

3,6265 gold badges37 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to change values of a mysql database via dbgrid?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related