Operations

Each operation has an equivalent numeric code, and there are special constants insert, update, delete, upsert, and safedelete for these numeric values.

• "insert" means insert a record. It's a run-time error if there is already a record present with those keys.

• "update" means update a record. It's a run-time error if there is no record present with those keys.

• "delete" means delete a record. It's a run-time error if there is no record present with those keys.

• "upsert" means insert a record if no record is present with those keys and update otherwise. This avoids the potential run-time error with "insert" or "update."

• "safedelete" means delete a record if one is already present with those keys and ignore otherwise. This avoids the potential run-time error with "delete."

The operation is set to insert when a record event is created.

Use the function getOpcode to get the operation out of an event, and setOpcode to set the operation. The function setOpcode alters the record event without making a copy. For instance, this prints the numeric codes for insert (which is 1) and safedelete (which is 13):

[ integer k; | string data;] v;
v := [k=9;|];
print('opcode=', string(getOpcode(v)), '\n');
setOpcode(v,safedelete);
print('opcode=', string(getOpcode(v)), '\n');