RefreshOption in TMyQuery does not work if TMyUpdateSQL used

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
gundars.k
Posts: 1
Joined: Mon 08 Sep 2008 08:31

RefreshOption in TMyQuery does not work if TMyUpdateSQL used

Post by gundars.k » Mon 08 Sep 2008 08:36

I tested TMyQuery and everything worked fine,
however I need to update to tables, second one is outer join. So I used TMyUpdateSQL where OnUpdateRecord to change ModifySQL depending whether second table on outer join needs insert or update and call
TMyUpdateSQL.Apply(UpdateKind).
With TMyQuery record refethed new values. When I set UpdateObject property of TMyQuery refresh is not called anymorel

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

Post by Dimon » Mon 08 Sep 2008 12:56

Try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com.

Post Reply