I display a field with at the dataprovider a relation to a view. How do I update Servoy so I can see a new added value to the view, without restarting Servoy?
I am not familiar with view but won’t DatabaseManager.refreshRecordFromDatabase(…) do it for you?
Tried it already but it doesn’t work
hmm, another suggestion but maybe not really preferred: plugins.rawSQL.flushAllClientsCache(…)
Thank you. That did work.
Can you explain me, why it is not preferred?
It is documented when I am not mistaken.
It can be an expensive operation because it really flushes all cache…
But when it does the job and you are happy with it I would say: go ahead
It’s a bit strange that the DatabaseManager.refreshRecordFromDatabase() didn’t do the trick.
What syntax did you use ?
I build a test form where I tested DatabaseManager.refreshRecordFromDatabase. The view was updated. But in my application a record of the view must be updated en that updated record containts a name. I show on my form, the name in the view by a relation. That is where DatabaseManager.refreshRecordFromDatabase doesn’t work.
I solved the problem. I have to update the view and refresh the relation.
databaseManager.refreshRecordFromDatabase(relationname.foundset, -1)
relationname.relookup()