Standard DBAware Components.

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
cnmcdee
Posts: 4
Joined: Thu 26 Feb 2009 04:01

Standard DBAware Components.

Post by cnmcdee » Thu 26 Feb 2009 04:06

I have a standard Mysql Database with a table, and a set of corresponding DBGrid, and DBComponents (DBEdit).

However when I change data in the DBEdit, the Record is not automatically being updated back on the server, only when I use DBGrid.

In the MyQuery Update SQL I had the component generate the standard set of SQL instructions..

I tried adding a 'POST' button which activates the following commands.

MyQuery1.SQLUpdate;
MyQuery1.SQLRefresh;

But that does not work... Any suggestions. DBGrid can edit and post back the records fine, but DBEdit will not.

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Thu 26 Feb 2009 13:10

To save data in the server table you should execute the TMyQuery.Post method (in the 'POST' button ).

Post Reply