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

GET_GROUP_ROW_COUNT Built-in

Description

Returns the number of rows in the record group.

Syntax

FUNCTION GET_GROUP_ROW_COUNT
(recordgroup_id RecordGroup);

FUNCTION GET_GROUP_ROW_COUNT
(recordgroup_name VARCHAR2);

Built-in Type unrestricted function

Returns NUMBER

Enter Query Mode yes

Parameters

recordgroup_id 
 
Specifies the unique ID that Oracle Forms assigns to the record group when it creates it. Use the FIND_GROUP Built-in to return the ID to a variable. The data type of the ID is RecordGroup.
 
recordgroup_name 
 
Specifies the name of the record group that you gave to the group when creating it. The data type of the name is VARCHAR2.

Restrictions

GET_GROUP_ROW_COUNT Examples

/*

** Built-in: GET_GROUP_ROW_COUNT
** Example: Determine how many rows were retrieved by a
** Populate_Group for a query record group.
*/
DECLARE
rg_id RecordGroup;
status NUMBER;
the_rowcount NUMBER;
BEGIN
rg_id := Create_Group_From_Query('MY_QRY_GROUP',
'SELECT ENAME,EMPNO,SAL FROM EMP ORDER BY SAL DESC');
status := Populate_Group( rg_id );
*/ *** Zero status is success*** /
IF status = 0 THEN
the_rowcount := Get_Group_Row_Count( rg_id );
Message('The query retrieved '||to_CHAR(the_rowcount)||
' record(s)');
ELSE
Message('Error creating query record group.');
RAISE Form_Trigger_Failure;
END IF;
END;