SET_GROUP_NUMBER_CELL Built-in
Description
Sets the value for the record group cell identified by the given row and column.
Syntax
SET_GROUP_NUMBER_CELL
(groupcolumn_id GroupColumn,
row_number NUMBER,
cell_value NUMBER);
SET_GROUP_NUMBER_CELL
(groupcolumn_name VARCHAR2,
row_number NUMBER,
cell_value NUMBER);
Built-in Type unrestricted procedure
Enter Query Mode yes
Parameters
- groupcolumn_id
-
- The unique ID that Oracle Forms assigns when it creates the column for
the record group. Use the FIND_COLUMN Built-in to return the ID to an appropriately
typed variable. The data type of the ID is GroupColumn.
-
- groupcolumn_name
-
- The name you gave to the column when you created it, preceded by the record
group name and a dot, as in recordgroup_name.groupcolumn_name. The data type
of the name is VARCHAR2.
-
- row_number
-
- Specifies the row number that contains the cell whose value you intend to
set. Specify as a whole NUMBER.
-
- cell_value
-
- Specifies the NUMBER value you intend to enter into a cell.
SET_GROUP_NUMBER_CELL Restrictions
- You must create the specified row before setting the value of a cell in
that row. Explicitly add a row with the ADD_GROUP_ROW Built-in or populate
the group with either POPULATE_GROUP or POPULATE_GROUP_WITH_QUERY.
- Not valid for a static record group. A static record group is a record group
that was created at design time and that has the Record Group Type property
set to Static.
SET_GROUP_NUMBER_CELL Example
/*
** Built-in: SET_GROUP_NUMBER_CELL
** Example: See ADD_GROUP_ROW
*/