I have servoy running as well as a web based UI written in PHP. Both of which see to the same database. Obviously when changes are made to a record in servoy, it can be seen on the web when refreshed. But if a change is made on the web side, Servoy will not see the change. In fact, from what I can gather, unless you relaunch your servoy client, the changed data is NEVER seen.
Is there a way to disable the cache in Servoy?
No, there is no way to disable, and you wouldn’t want to - as all the clients would have to refresh all data all the time.
What you can do in Servoy is to use databaseManager.refreshRecordFromDatabase(). You can specify a single record or the whole foundset.
Hope this helps.
Does headless client have anything to do with this? As far as keeping the data current?
If you use headless client then Servoy server knows what data has changed and can tell the other clients that that part of their cache is invalid. They will then reload that data when needed and have the latest data.
So yes, Headless client would be a solution.
Hope this helps.