Update Records
To update records in a table, use the recordUpdate
method of the Datastore
class. This method updates all records that match a filter. You can update all of the columns for the record, or just some of them.
In Create Tables, a table was introduced that stored a reference and a last modified date. This sample code updates a single record in that table:
DatastoreRecord filter = new DatastoreRecord(); filter.setString("Reference", "C:\\data\\file1.txt"); DatastoreRecord update = new DatastoreRecord(); update.setString("LastModified", "2014/12/28 17:21:07"); datastore.recordUpdate("Documents", filter, update);
The first argument specifies which table to update. The second argument is a filter that selects all records with the given reference. The third argument is a record. Any fields set in this record are set in matching records in the table, while any fields that are not set are ignored. In the example above, only the “LastModified” field is set, so that is updated and the Reference is not changed.