Joost Miltenburg Posted January 30, 2009 Share Posted January 30, 2009 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 Link to comment Share on other sites More sharing options...
mr_vodka Posted January 30, 2009 Share Posted January 30, 2009 I havent really seen this issue, but you can always try the refresh window script with flushing of the cached SQL data. Link to comment Share on other sites More sharing options...
Joost Miltenburg Posted February 5, 2009 Author Share Posted February 5, 2009 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5558 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now