Runtime components : Service components : Database services : Database Table Mapping : Tasks : Updating records
  
Updating records
The method updateRecordsMatching() is used to update records in the database according to a search criterion, and takes a search string and formatted data from the context. The data from the context may be either a formatted record, or a context together with a formatter name, or a context together with a formatter. In the last two cases, the service itself calls the format() method of the formatter object to build the new JDBCTable table record.
Each of the update methods, by default, updates every column in the table for every record matching the search criteria. If fewer columns are to be updated, an additional argument is used: a Vector with elements containing the names of the columns to be updated.
Each update method returns an int value containing the number of records updated as a result of the statement execution.
Go up to
Tasks