Refresh Problem

Refresh Problem

I have 1 Mysql Table with 2 Table connected in the Data Abstract Schema Modeler.
( Reason i use 1 List for a DB-Grid and the other to show all Details )

If i delete a entry in MBP i use following code to refresh to MBP_LIST

procedure TDM_mbp.tbl_mbpAfterDelete(DataTable: TDADataTable);

The Problem is that the Table MBP_LIST is not refreshed and still shows the entry.
If i refresh MBP manually with the Dataset Navigator afterwards, MBP_LIST is updated.

I use only the tow Tables because if the DB-Grind and the View of the Date are on the same Table i get Problems ( Chanel-Busy- Error ) while scrolling in the Grid.

Hope i could explain the Problem…

My System is:
Relativity Server: v9.3.104.1297
Data Abstract: v9.3.104.1297
RemObjects SDK: v9.3.104.1297

Framework: v4.0.30319.42000
Operating System: Unix
Platform: Unix

with FPC 3.0.2 on 2017/05/29 at 17:13:03
using LCL and Win32/Win64 widget set

DA Ver.

a few remarks:

  • you can use cloned tables feature instead of using 2 tables. cloned tables has own position so changing of location of main table has no any effect to position of cloned tables.
  • you can refresh table with table.RefreshFromServer or just perform Close/Open;

I’ve attached example of usage of this feature: (46.4 KB)
Note: It from DA7 so may require some changes for DA 9.2

Will try that, thank you


It works with the Clone Table, but the Problem with the refresh is the same.
Did try Table.RefreshFromServer and Table.Refresh.

With RefreshFromServer i get this Error:

Table.Refresh does nothing. Posting a entry is not a problem just delete.

in case of cloned tables, you shouldn’t use RefreshFromServer at all because cloned tables use master recordset.
RefreshFromServer should be used for separated tables as you used before.

Everything works fine now, thank you very much,