Populates a record group with the given query. The record group is cleared and rows that are fetched replace any existing rows in the record group.
If the SELECT statement fails, Oracle Forms returns an ORACLE error number,
which can be tracked with SQLERRM,
if you change the sign to -. If the query
is successful, this Built-in returns 0 (zero).
You can use this Built-in to populate record groups that were created by a call to either:
When you use this Built-in, the indicated query becomes the default query for the group, and will be executed whenever the POPULATE_GROUP Built-in is subsequently called.
Note: Be aware that the POPULATE_GROUP_WITH_QUERY array fetches 20 records at a time. To improve network performance, you may want to restrict queries, thus limiting network traffic.
FUNCTION POPULATE_GROUP_WITH_QUERY
(recordgroup_id RecordGroup,
query VARCHAR2);
FUNCTION POPULATE_GROUP_WITH_QUERY
(recordgroup_name VARCHAR2,
query VARCHAR2);
Built-in Type unrestricted function
Returns NUMBER
Enter Query Mode yes
/*
** Built-in: POPULATE_GROUP_WITH_QUERY
** Example: See CREATE_GROUP
*/