1 12/01/86 column_value, clv
2
3 Syntax as an active request: clv column_id -control_arguments
4
5
6 Function: returns the value of the specified column for the current
7 row, the previous row, or the next row. This request can only be used
8 as an active request. It is used within a formatted report produced by
9 the display request to obtain a column's value. It is an error to use
10 this request anywhere except in a header/footer or editing string
11 within a report produced by the display request.
12
13
14 Arguments:
15 column_id
16 specifies which column the value should be returned for. column_id
17 can be given as the name of the column as defined in the open
18 model/submodel or the number of the column in the query.
19
20
21 Control arguments:
22 -current_row, -crw
23 specifies that the value of the named column for the current row
24 should be returned. This is the default.
25 -default STR
26 where STR is the character string that will be returned when there
27 is no previous row, or, when there is no next row. If this control
28 argument is not used the default value for STR is "".
29 -next_row, -nrw
30 specifies that the value of the named column for the next row should
31 be returned. If there is no next row, the string "" is returned
32 unless changed by the -default control argument.
33
34
35 -previous_row, -prw
36 specifies that the value of the named column for the previous row
37 should be returned. If there is no previous row, the string "" is
38 returned unless changed by the -default control argument.
39
40
41 Examples:
42 column_value foo
43 column_value 3
44 column_value foo -previous_row
45 column_value foo -next_row -default NULL