The update statement update rows in the database. Validation rules for the type are and Delia halts if there is invalid data.

Specify the fields that you want to update.

The update statement includes a filter expression (see …) where you specify which rows the update should apply to.

 type Customer struct {
  id int primaryKey
  name string
 } end

 insert Customer {id: 1, name: 'Amy Chang'}
 update Customer[1] {name: 'Amy Gonzalez'} //update one row

In the above example we use a primary key filter ("[1]") to identify the row to be updated.

The update statement returns an integer of the number of rows updated.

 let numRowsUpdated = update Customer[1] {name: 'Amy Gonzalez'}