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

POPULATE_GROUP Built-in

Description

Executes the query associated with the given record group and returns a number indicating success or failure of the query. Upon a successful query, POPULATE_GROUP returns a 0 (zero). An unsuccessful query generates an ORACLE error number that corresponds to the particular SELECT statement failure. The rows that are retrieved as a result of a successful query replace any rows that exist in the group.

POPULATE_GROUP is necessary to populate a record group before using the SET_TREE_PROPERTY(RECORD_GROUP) option.

Note: Be aware that the POPULATE_GROUP array fetches 100 records at a time. To improve network performance, you may want to restrict queries, thus limiting network traffic.

Syntax

FUNCTION POPULATE_GROUP
(recordgroup_id RecordGroup);

FUNCTION POPULATE_GROUP
(recordgroup_name VARCHAR2);

Built-in Type unrestricted function

Returns NUMBER

Enter Query Mode yes

Parameters

recordgroup_id 
 
The unique ID that Oracle Forms assigns when it creates the group. The data type of the ID is RecordGroup.
 
recordgroup_name 
 
The name you gave to the record group when creating it. The data type of the name is VARCHAR2.
 

On Failure

When the Populate_Group Built-in fails because the record group does not exist, a NULL value is returned.

POPULATE_GROUP Restrictions

Valid only for record groups:

POPULATE_GROUP Example

/*

** Built-in: POPULATE_GROUP
** Example: See GET_GROUP_ROW_COUNT and CREATE_GROUP_FROM_QUERY
*/