RefreshOption in TMyQuery does not work if TMyUpdateSQL used
Posted: 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
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