You can get and set the value of a cell at the intersection of a specific row and column.
To get the current value of a column in a specific row, use the function appropriate to the datatype of the cell:
When you reference columns in a record group, use the complete group_name.column_name syntax. Alternatively, you can reference columns by their internal object IDs. To get the ID of a specific column, use the FIND_COLUMN function.
To set the value of a column in a specific row, use the procedure appropriate to the data type of the cell:
Note: You cannot set the values of cells in a static record group.
/* The following example gets the current value of the
** amount_in_stock column in the third row of the group
** my_group.
*/
DECLARE
quantity NUMBER;
col_id GroupColumn :=
Find_Column('my_group.amount_in_stock');
BEGIN
quantity := Get_Group_Number_Cell(col_id,3);
END;
/* The next example sets the value of the name column to
** Lisa Jean in the first row of the group named my_group.
*/
Set_Group_Char_Cell('my_group.name',1,'lisa jean');
About record group Built-in subprograms