9 245 UPDATE_IN_SPACE

9.245 UPDATE_IN_SPACE

Þ Note: Built-In Function Rules.

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

For use with

LANSA for i YES Only available for RDMLX. Visual LANSA for Windows YES   Visual LANSA for Linux YES

 

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.