Open topic with navigation

# Update Records

To update records in a table, use the `Update` method of the `Table` 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:

           docs.Update(
            	docs.Column("Reference") == @"C:\data\file1.txt",
            	new Record().Add("LastModified", DateTime.Now));

The first argument is a filter that selects all records with the given reference. The second 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.

© 2018 Micro Focus or one of its affiliates | Send documentation feedback to Micro Focus Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a web mail client, and send this email to swpdl.idoldocsfeedback@microfocus.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_FT_HTML5_bannerTitle.htm