A script-enabled browser is required for this page to function properly.

Getting and Setting Cell Values

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.

Getting and setting cell values: Examples

/* 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

About manipulating a record group at runtime

Modifying an existing record group