Refreshing a form

Classic Servoy
1

Hi,

I’ve got a number of table view forms, set out in a tab panel. My underlying databases are Foxpro dbf’s although I’m not 100% that is relevant.
If I add records to a table/database via my Foxpro app, they don’t appear in the Servoy app until close it down and re-open it.

I’ve tried forcing the current table view, via the onTabChange event, to reload the records, using various combinations of the following to no avail.

var _form = globals.CurrForm;
forms[_form].foundset.loadAllRecords();
//forms.trk_lst.controller.loadAllRecords()

Whilst I understand that Servoy broadcasts the data, how do I get my app to refresh and display these new records which have been added outside of the Servoy app.
Oddly, changes to existing records don’t seem to be a problem. I haven’t quite got as far as adding/deleting records from my Servoy app, but some general advice on how I can force a refresh would be most appreciated.

Kind regards,

Tony

2

Hi Tony,

Once records are cached by Servoy, Servoy is only aware of the changes broadcasted within the application server.

To force an update of the foundset cache, call: databaseManager.refreshRecordFromDatabase() > please look at the docs for information about the arguments to be passed to this function.

Hope this helps.