Hi All !

I am working with ESS and it works very nicely, but there is one problem : ESS seems to lag behind in the refreshing/updating of the data.

Example : When searching in a sql-based table in ESS I find less records then when doing the same search in the sql table directly.

What could be causing this ? Can I somehow check if the ESS-connection is alive ? Can I force a refresh of the shadow table ?

TIA

I havent really seen this issue, but you can always try the refresh window script with flushing of the cached SQL data.

Apperently, the problem was the primary key. There was none, so in FM I defined one by checking several fields. As the values none unique this problem started to occur.

Adding a primary key in the SQL-table fixed this.