9.225 UPDATE_IN_SPACE

Note: Built-In Function Rules     Usage Options

Updates a single cell row that matches the key values supplied.

Arguments

No

Type

Req/ Opt

Description

Min Len

Max Len

Min Dec

Max Dec

1

A

R

Space Name

1

256

 

 

2-20

w

O

Fields that specify the values to be used to locate and update the cells row.  

1

Unlimited

0

Unlimited

 

Return Values

No

Type

Req/ Opt

Description

Min Len

Max Len

Min Dec

Max Dec

1

A

O

Standard Return Code

"OK" = A cell row was found and updated.

"NR" = No cell row could be found to update.

"ER" = Update attempt failed. Messages issued will indicate more about the cause of the failure.  

2

2

 

 

 

Technical Notes

You cannot change the values of keys cells in a space object. To alter the values of key cells you must delete and (re)insert the cell row. 

The field values must be specified in the same order as the cells in the space were defined. Cells are matched by the order of their specification in arguments 2 -> 20. The names of the fields used have no bearing whatsoever on the cell mapping logic.     

If you specify less field values than there are cells in the space then the non-specified cells are set to blank/zero/null values as appropriate.

If you specify more field values than there are cells in the space then the additional field values are ignored.

If a key value longer than 256 bytes is specified, a fatal error will occur.