Example of updating an object

Edit online

Use this example to learn how to use the update keyword in an object.

The following example updates part of an object, referencing the varbind to be updated using the -> symbol.

|phoenix:1.> update staff.contractors 
|phoenix:2.> set ExtraInfo->ContractLength=2
|phoenix:3.> where ExtraInfo->ContractLength=1;
|phoenix:4.> go

ContractLength is updated to 2 in any records where the ContractLength within the ExtraInfo field was set to 1.