Page History
9.69 FETCH_IN_SPACE
| Note | ||
|---|---|---|
| title | Note: | Built-In Function Rules Usage Options |
Fetches the first cell row that matches the key values supplied and returns the cell values into the specified fields.
Arguments
No | Type | Req/ Opt | Description | Min Len | Max Len | Min Dec | Max Dec |
|---|---|---|---|---|---|---|---|
1 | A | R | Space Name | 1 | 256 | ||
2-20 | X | O | Fields that specify the key values to be used to locate the first cell row required. | 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 the cell values have been returned. "NR" = No cell row could be found with a key matching the key values supplied. "ER" = Select attempt failed. Messages issued will indicate more about the cause of the failure. | 2 | 2 | ||
2-20 | X | O | Fields to receive the values of the cells in the selected cell row. | 1 | Unlimited | 0 | Unlimited |
Technical Notes
The return fields 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 return values 2 -> 20. The names of the fields used have no bearing whatsoever on the cell mapping logic.
...