SET_GROUP_CHAR_CELL Built-in
Description
Sets the value for the record group cell identified by the given row and column.
Syntax
SET_GROUP_CHAR_CELL
(groupcolumn_id GroupColumn,
row_number NUMBER,
cell_value VARCHAR2);
SET_GROUP_CHAR_CELL
(groupcolumn_name VARCHAR2,
row_number NUMBER,
cell_value VARCHAR2);
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
-
- For a VARCHAR2 column, specifies the VARCHAR2 value you intend to enter
into a cell; for a LONG column, specifies the LONG value you intend to enter
into a cell.
SET_GROUP_CHAR_CELL Restrictions
- You must create the specified row before setting the value of a cell in
that row. Oracle Forms does not automatically create a new row when you
indicate one in this Built-in. Explicitly add the 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_CHAR_CELL Example
/*
** Built-in: SET_GROUP_CHAR_CELL
** Example: See ADD_GROUP_ROW
*/