If data can be updated external to a client how do you enable a web client to see the changed data? I’ve tried a controller.loadallrecords() but it is not picking up the changes and display on the form.
So you are saying that you manipulate the data in the DB from an external tool?
Servoy isn’t aware of these changes.
As soon as you already loaded records from the database, these are cached in Servoy.
To update 1 or more records, you have to use: databaseManager.refreshRecordFromDatabase(foundset, numberIndex)
where ‘numberIndex’ is the index of the record to update, or -1 to update all records in the foundset.\
Note that if you’ve added records to the database that match the criteria of your current foundset, you should first query the pk’s, convert the pk’s into a foundset, update that foundset.
This is quite an expensive operation, so you might want to look at setting up a webservice in Servoy.
The external tool can update the records via the webservice rather than updating directly on the database.
Hope this helps.
Perfect … thanks