9 245 UPDATE_IN_SPACE

LANSA Technical

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.