Refresh Problem

Relativity Server
1

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);
begin
    tbl_mbp_list.Refresh;
end;

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.

2017-06-02 11_51_19-Hotel.jpg924×332 51.7 KB

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…
Shalom
Manfred

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 3.13.0.42
Platform: Unix

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

RemObject
DA Ver.9.3.104.1299

2

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: CloneSource.zip (46.4 KB)
Note: It from DA7 so may require some changes for DA 9.2

3

Will try that, thank you

Shalom
Manfred

4

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.

5

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.

6

Everything works fine now, thank you very much,

Shalom
Manfred